688515 - Home page graph not displaying Thunderbird correctly

Status: VERIFIED FIXED

(Socorro :: General, task)

Description

[[:jberkus] Josh Berkus]

Lonnen,
(correct me if it's Bsavage who did the graphs, I can't remember)

In staging, with the 2.2.4 data update, the home page graph for Thunderbird 6.0.2 displays no data:

https://crash-stats.allizom.org/products/Thunderbird/versions/6.0.2

Yet there is data in the underlying tables:

breakpad=# select * from daily_crashes where productdims_id = 677 and adu_day = '2011-09-19';
   id   | count | report_type | productdims_id | os_short_name |       adu_day       
--------+-------+-------------+----------------+---------------+---------------------
 305430 |   123 | C           |            677 | Lin           | 2011-09-19 00:00:00
 305604 |     0 | H           |            677 | Lin           | 2011-09-19 00:00:00
 305477 |   820 | C           |            677 | Mac           | 2011-09-19 00:00:00
 305598 |     0 | H           |            677 | Mac           | 2011-09-19 00:00:00
 305460 |  9641 | C           |            677 | Win           | 2011-09-19 00:00:00
 305610 |     0 | H           |            677 | Win           | 2011-09-19 00:00:00
(6 rows)

breakpad=# select * from product_adu where product_version_id = 677 and adu_date = '2011-09-19';
 product_version_id | os_name  |  adu_date  | adu_count 
--------------------+----------+------------+-----------
                677 | Linux    | 2011-09-19 |     49020
                677 | Mac OS X | 2011-09-19 |    179872
                677 | Unknown  | 2011-09-19 |       653
                677 | Windows  | 2011-09-19 |   3320378

Jabba kicked the cache, so this isn't a caching issue.  Which leaves a middleware or UI bug.  Help?

Comment 1

[Robert Kaiser]

Just for reference, here are the two URLs I'm testing with to see if things are OK:

https://crash-stats.allizom.org/daily?form_selection=by_version&p=Thunderbird&v%5B%5D=6.0%28beta%29&throttle%5B%5D=100.00&v%5B%5D=7.0b2&throttle%5B%5D=100.00&v%5B%5D=7.0b3&throttle%5B%5D=100.00&v%5B%5D=6.0.2&throttle%5B%5D=10.00&hang_type=any&os%5B%5D=Windows&os%5B%5D=Mac&os%5B%5D=Linux&date_start=2011-09-06&date_end=2011-09-20&submit=Generate

All those versions should have some crashes and ADUs over this period, 7.0b3 crashes should only start on the 17th as this build was only created on the 16th.

https://crash-stats.allizom.org/daily?form_selection=by_version&p=SeaMonkey&v%5B%5D=2.3.3&throttle%5B%5D=10.00&v%5B%5D=2.4b2&throttle%5B%5D=100.00&v%5B%5D=2.4b3&throttle%5B%5D=100.00&v%5B%5D=2.3%28beta%29&throttle%5B%5D=100.00&hang_type=any&os%5B%5D=Windows&os%5B%5D=Mac&os%5B%5D=Linux&date_start=2011-09-06&date_end=2011-09-20&submit=Generate

All those builds should have some crashes over that period (as reported by topcrashers), not every day might have some as ADUs are quite low, and ADU data should exist for all those versions.

Those URLs can be used for spot-checking that thing work right. Comparing to topcrasher reports for those versions is helpful to determine the amount of crashes that should show up, as TCBS reports seem to have reasonable data, just graphs / daily crashes seem to be wrong.

Comment 2

[[:jberkus] Josh Berkus]

Lonnen deployed new code which resolved the issue.

Comment 3

[Lonnen :lonnen]

Stage was running an old candidate. Following this morning's merging in of the other code slated for release we pushed another candidate and things look fine.

Comment 4

[Matt Brandt [:mbrandt]]

Attachment: Graphs with data

Bumping to QA verified. From what I can tell the graphs and data look correct now. I'm using the steps to reproduce in comment 1. KaiRo please reopen if I'm mistaken.

Comment 5

[Robert Kaiser]

Yes, I already verified that stage looks good now. I'm buying 2.2.4 :)