934960 - Error 404 When Loading Tiny Graphs on Topcrashers with FakeData

Status: RESOLVED FIXED

(Socorro :: Backend, task)

Description

[Schalk Neethling [:espressive]]

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

Comment 1

[Robert Helmer [:rhelmer]]

(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}

Comment 2

[Robert Helmer [:rhelmer]]

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

Comment 3

[Robert Helmer [:rhelmer]]

Looks like tcbs table isn't getting populated at all in my local test instance.

Comment 4

[Robert Helmer [:rhelmer]]

(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.

Comment 5

[Robert Helmer [:rhelmer]]

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/