747898 - Backfill ADU data for April 17 - 21 (and topcrashes /aggregations for April 20)

Status: VERIFIED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Robert Kaiser]

It looks like metrics has pushed the raw ADU data for the missed days to Socorro, so we should process those into the aggregated data used for graphs, etc. - that's for April 17 - 21, which are missing the ADU data right now.

Also, https://crash-stats.mozilla.com/daily?p=Firefox&v[]= shows no crashes for April 20, we need to re-run the jobs for this as well.

Laura, this is high priority for CrashKill, we need to check *today* if we can ship a release tomorrow and data from the betas in the last few days is paramount for that.

Comment 1

[Laura Thomson :laura]

So we need to do the following:
- Backfill ADU for April 17-21
- Re-run daily and aggregate crons for April 20

Moving over to Server Ops: Databases

Comment 2

[Sheeri Cabral [:sheeri]]

breakpad=#  select backfill_adu('2012-04-17');
 backfill_adu 
--------------
 t
(1 row)


I'm suspicious because it did not take very long to run this backfill.

Comment 3

[Sheeri Cabral [:sheeri]]

Reprocessing matviews for 4/20:

breakpad=# select backfill_matviews('2012-04-20 00:00:00','2012-04-21 00:00:00');

Comment 4

[Sheeri Cabral [:sheeri]]

resolving, please re-open if this wasn't actually fixed by the work we did yesterday.

Comment 5

[Robert Kaiser]

Thanks, everything looks fine from what I saw.