1137144 - Socorro not picking up FennecAndroid 37.0b1

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Robert Kaiser]

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

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]]

Hm looks different from bug 1122145 (the repository looks fine)... I see an entry for this but it's not set as "featured" for some reason. Let me look a little deeper.

Comment 2

[Robert Helmer [:rhelmer]]

It looks like we've got entries in product_versions for Fennec but not for FennecAndroid... I am looking up how that mapping happens now.

Comment 3

[Robert Helmer [:rhelmer]]

It looks like what has changed now the platform names picked up are "android-arm" and "android-x86", but we only have entries in special_product_platforms for "android".

I want to avoid the false starts we had in bug 1122145 so going to modify and backfill this now, and write the migration when I am sure it's right.

Comment 4

[Robert Helmer [:rhelmer]]

(In reply to Robert Helmer [:rhelmer] from comment #3)
> It looks like what has changed now the platform names picked up are
> "android-arm" and "android-x86", but we only have entries in
> special_product_platforms for "android".

I take that back - we're picking up "android-x86", "android-api-9" and "android-api-11" (same build ID for all, which is the important thing from Socorro's PoV - to be able to match crash reports up with the desired display version).

I am testing a backfill for this right now, if it works I'll allow these platforms for both beta and release (since presumably we're going to hit the same issue there)

Comment 5

[Robert Helmer [:rhelmer]]

OK 37.0b1 now appears on https://crash-stats.mozilla.com/home/products/FennecAndroid but there's no data yet, I'm running a backfill now which may take a few hours.

Comment 6

[Robert Helmer [:rhelmer]]

OK the version number is showing up now but the (very few) reports from the past few days aren't getting into tcbs or graphs. What I changed was:

insert into special_product_platforms values ('android-x86', 'mozilla-beta', 'beta', 'mobile', 'FennecAndroid', '37.0');
insert into special_product_platforms values ('android-arm', 'mozilla-beta', 'beta', 'mobile', 'FennecAndroid', '37.0');

Then a backfill:
backfill_matviews('2015-02-25');

Comment 7

[Robert Helmer [:rhelmer]]

(In reply to Robert Helmer [:rhelmer] from comment #6)
> Then a backfill:
> backfill_matviews('2015-02-25');

Note there are a few crash reports on 2015-02-24 so once we figure out what's going on here we should backfill that day too to pick these up.

Comment 8

[Kevin Brosnan [Ex-Mozilla]]

We have not shipped this build backfilling is minor importance.

Comment 9

[Robert Helmer [:rhelmer]]

(In reply to Robert Helmer [:rhelmer] from comment #6)
> insert into special_product_platforms values ('android-x86', 'mozilla-beta',
> 'beta', 'mobile', 'FennecAndroid', '37.0');
> insert into special_product_platforms values ('android-arm', 'mozilla-beta',
> 'beta', 'mobile', 'FennecAndroid', '37.0');

Hm actually looking at the data we picked up from FTP again, we should not have "android-arm" above, we should have "android-api-9" and "android-api-11" as allowed platforms:

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

This shouldn't be stopping TCBS or graphs backfill from working though, because the build ID is the important thing we're picking up (since the crash reports don't come in with the beta version set this is how we know a particular incoming crash was "37.0b1" and not "37.0")

Comment 10

[Selena Deckelmann :selenamarie :selena]

Ok updated and doing a backfill: 

insert into special_product_platforms values ('android-api-9', 'mozilla-beta', 'beta', 'mobile', 'FennecAndroid', '37.0');
insert into special_product_platforms values ('android-api-11', 'mozilla-beta', 'beta', 'mobile', 'FennecAndroid', '37.0');
delete from special_product_platforms where platform = 'android-arm' and repository = 'mozilla-beta';

Comment 11

[Robert Kaiser]

OK, this is fixed now, right?

Comment 12

[Selena Deckelmann :selenamarie :selena]

Yes, this is fixed. I confirmed that reports are being aggregated in TCBS for the 24-26th.