Error 404 When Loading Tiny Graphs on Topcrashers with FakeData

RESOLVED FIXED

Status

Socorro
Backend
RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: espressive, Assigned: rhelmer)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

4 years ago
I had an email discussion with rhelmer about this problem and he asked I opened a bug so, here it is ;)

So, when running a local instance of the Django app and connecting to FakeData I get the following 404 error when trying to load the tiny graphs (for lack of a better description|signature history service):

http://sneethling.pastebin.mozilla.org/3428946
(Assignee)

Comment 1

4 years ago
(In reply to Schalk Neethling [:espressive] from comment #0)
> I had an email discussion with rhelmer about this problem and he asked I
> opened a bug so, here it is ;)
> 
> So, when running a local instance of the Django app and connecting to
> FakeData I get the following 404 error when trying to load the tiny graphs
> (for lack of a better description|signature history service):
> 
> http://sneethling.pastebin.mozilla.org/3428946

Odd that it's 404 on the public fakedata server, I get this locally (200 OK):

$ curl 'http://localhost:8883/crashes/signature_history/product/WaterWolf/version/5.0a1/signature/FakeSignature1/end_date/2013-11-04T00%3A00%3A00/start_date/2013-10-28T00%3A00%3A00/'
{"hits": [], "total": 0}
(Assignee)

Comment 2

4 years ago
This is the query:

            /* external.postgresql.crashes.Crashes.get_signature_history */
            WITH hist AS (
                SELECT
                    report_date,
                    report_count
                FROM
                    tcbs JOIN signatures using (signature_id)
                         JOIN product_versions using (product_version_id)
                WHERE
                    report_date BETWEEN %(start_date)s AND %(end_date)s
                    AND product_name = %(product)s
                    AND version_string = %(version)s
                    AND signature = %(signature)s
                GROUP BY
                    report_date, report_count
                ORDER BY 1
            ),
            scaling_window AS (
                SELECT
                    hist.*,
                    SUM(report_count) over () AS total_crashes
                FROM hist
            )
            SELECT
                report_date,
                report_count,
                report_count / total_crashes::float * 100 AS percent_of_total
            FROM scaling_window
            ORDER BY report_date DESC
(Assignee)

Comment 3

4 years ago
Looks like tcbs table isn't getting populated at all in my local test instance.
(Assignee)

Comment 4

4 years ago
(In reply to Robert Helmer [:rhelmer] from comment #3)
> Looks like tcbs table isn't getting populated at all in my local test
> instance.

Oh! I wasn't populating the correct database - sigh.

So it does work for me locally, I may just need to update the fakedata server source - not sure if that is auto-update or not yet.
(Assignee)

Comment 5

4 years ago
OK this now works: http://socorro-api-dev-fakedata.allizom.org/crashes/signature_history/product/WaterWolf/version/5.0a1/signature/FakeSignature1/end_date/2013-11-04T00%3A00%3A00/start_date/2013-10-28T00%3A00%3A00/
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.