904091 - No ADI for 8/8

Status: RESOLVED FIXED

(Socorro :: Backend, task)

Description

[Laura Thomson :laura]

The cron has been alerting all weekend so I suspect we haven't had data from metrics. But we should check that first.

Comment 1

[Robert Helmer [:rhelmer]]

Looks like we are only missing the 8th, which is causing our auto-backfill to fail.

Comment 2

[Robert Helmer [:rhelmer]]

I started running backfill for 9th through 11th, it's still going (reports_clean done, starting in on other matviews now)

Comment 3

[Selena Deckelmann :selenamarie :selena]

From IRC: 

11:25 <@rhelmer> selenamarie: hey, backfill failed :( ERROR:  null value in column "architecture" violates not-null constraint
11:25 <@    rhelmer> | DETAIL:  Failing row contains (2895542, null, 759, Firefox, 2013-08-09, 54).

This is failing because of a bug in the new signature summary matviews. This is fixed in https://github.com/mozilla/socorro/commit/a53898f279fdaa1fe601fbf45c68f0683b6375c7

Comment 5

[Selena Deckelmann :selenamarie :selena]

Still no ADI for 8/8, running backfill for 8/9->...

Comment 6

[Selena Deckelmann :selenamarie :selena]

8/9-11 are done. Now running 8/12. 

Still waiting on 8/8.

Comment 7

[Selena Deckelmann :selenamarie :selena]

8/12 is done.

Waiting on ADI per https://bugzilla.mozilla.org/show_bug.cgi?id=903644#c4

Comment 8

[Robert Helmer [:rhelmer]]

Backfilling the 8th:

breakpad=> select backfill_matviews('2013-08-08','2013-08-08');

Comment 9

[Robert Helmer [:rhelmer]]

Completed successfully.