852772 - [stage] Data on stage appears to be stale (but it's not)

Status: VERIFIED FIXED

(Socorro :: Webapp, task)

Description

[Matt Brandt [:mbrandt]]

I'm having difficulty populating the reports with data for duration=7. mpressman checked and the we should have data on stage, max(date) is 2013-03-18.

- https://crash-stats.allizom.org/products/Firefox#duration=14

Comment 1

[Matt Brandt [:mbrandt]]

Bumping to blocker - automation is failing (in spectacular ways) making it difficult to verify today's release.

Comment 2

[Matt Pressman [:mpressman]]

reakpad=# select max(date_processed) from reports;
              max
-------------------------------
 2013-03-20 18:07:49.253411+00
(1 row)

breakpad=# select max(date) from raw_adu;
    max
------------
 2013-03-19
(1 row)

Comment 3

[Matt Pressman [:mpressman]]

hmm, not sure how this relates, but 
breakpad=# select max(adu_date) from product_adu;
    max
------------
 2013-03-19
(1 row)

Comment 4

[Matt Pressman [:mpressman]]

whoops, posted wrong data for product_adu:

breakpad=# select max(adu_date) from product_adu;
    max
------------
 2013-03-04

Comment 5

[Matt Pressman [:mpressman]]

breakpad=# select max(date) from raw_adu ;
    max
------------
 2013-03-19

Comment 6

[Matt Pressman [:mpressman]]

running backfill in batches for the last two weeks, kicking off now

Comment 7

[Matt Pressman [:mpressman]]

finished backfill for last two weeks

Comment 8

[Matt Pressman [:mpressman]]

Attachment: output of backfill

Comment 9

[Matt Pressman [:mpressman]]

Got confirmation that this is now resolved

Comment 10

[Matt Brandt [:mbrandt]]

Many thx mpressman & selenamarie!

QA verified - 

09:50 qatestbot: socorro.stage: last build: 1818 (19 min ago): SUCCESS: http://qa-selenium.mv.mozilla.com:8080/job/socorro.stage/1818/