Closed Bug 1150068 Opened 7 years ago Closed 7 years ago

Socorro not picking up FennecAndroid 37.0

Categories

(Socorro :: Database, task)

task
Not set
major

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: kbrosnan, Assigned: lonnen)

References

Details

+++ This bug was initially created as a clone of Bug #1137144 +++

+++ This bug was initially created as a clone of Bug #1122145 +++
Broken with 37.0 release as well now.

Feels like bug 1122145 would only have been fixed for Nightly and Aurora, as FennecAndroid 37.0b1 isn't present on Socorro so far though it has been up at https://ftp.mozilla.org/pub/mozilla.org/mobile/candidates/37.0b1-candidates/build1/ for a few days now.
Looks like similar issue to previous bug, new repository names that aren't in the DB yet:

breakpad=# select * from releases_raw where product_name='mobile' and version = '37.0' and repository='mozilla-release';
 product_name | version |    platform    |    build_id    | build_type | beta_number |   repository    | update_channel | version_build 
--------------+---------+----------------+----------------+------------+-------------+-----------------+----------------+---------------
 mobile       | 37.0    | android-api-11 | 20150325173248 | release    |             | mozilla-release | release        | 
 mobile       | 37.0    | android-api-9  | 20150325173248 | release    |             | mozilla-release | release        | 
 mobile       | 37.0    | android-x86    | 20150325173248 | release    |             | mozilla-release | release        | 
(3 rows)


I've just modified this:

insert into special_product_platforms values ('android-x86', 'mozilla-release', 'release', 'mobile', 'FennecAndroid', '37.0', null), ('android-api-9', 'mozilla-release', 'release', 'mobile', 'FennecAndroid', '37.0', null), ('android-api-11', 'mozilla-release', 'release', 'mobile', 'FennecAndroid', '37.0', null);

Backfilling now.
Assignee: nobody → rhelmer
Status: NEW → ASSIGNED
OK it looks like we're associating the version correctly - I've adjusted the featured versions and am backfilling now.
Backfill for 2015-03-31 completed and I cleared the cache, but I don't see anything on the graph. I do see crashes in reports_clean though.. needs more investigation:

breakpad=# select count(*), date_trunc('day', date_processed) from reports_clean join product_versions using (product_version_id) where date_processed > '2015-03-20' and product_name = 'FennecAndroid' and version_string = '37.0' group by date_trunc('day', date_processed) order by count desc;
 count |       date_trunc
-------+------------------------
 20716 | 2015-04-01 00:00:00+00
  8676 | 2015-03-31 00:00:00+00
(2 rows)
Assignee: rhelmer → chris.lonnen
Between robs backfill and some ADI coming in overnight this appears to be fixed. Is there still an issue?
Flags: needinfo?(kbrosnan)
Looks good. Thanks for the prompt help!
Status: ASSIGNED → RESOLVED
Closed: 7 years ago
Flags: needinfo?(kbrosnan)
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.