1150068 - Socorro not picking up FennecAndroid 37.0

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Kevin Brosnan [Ex-Mozilla]]

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

Comment 1

[Robert Helmer [:rhelmer]]

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.

Comment 2

[Robert Helmer [:rhelmer]]

OK it looks like we're associating the version correctly - I've adjusted the featured versions and am backfilling now.

Comment 3

[Robert Helmer [:rhelmer]]

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)

Comment 4

[Lonnen :lonnen]

Between robs backfill and some ADI coming in overnight this appears to be fixed. Is there still an issue?

Comment 5

[Kevin Brosnan [Ex-Mozilla]]

Looks good. Thanks for the prompt help!