Closed Bug 790970 Opened 12 years ago Closed 12 years ago

Aggregated data for 2012-09-12 is missing (reports_clean not updated to the end of 2012-09-12)

Categories

(Socorro :: Database, task)

task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: kairo, Assigned: jberkus)

References

Details

Looks like we're missing aggregated data for yesterday on Socorro - did the mobeta push break running of daily crons or something?
All the nightly jobs are complaining that reports_clean was not updated to the end of yesterday:

InternalError: Reports_clean has not been updated to the end of 2012-09-12

It looks like the reports_clean job has been running so not sure what's going on here.
Depends on: 790996
Filed bug 790970 to backfill yesterday - I don't see any reason it should not have worked, I am guessing it had something to do with the upgrade. 

Assigning to jberkus for investigation, although I'll keep looking.
Assignee: nobody → josh
Summary: Aggregated data for 2012-09-12 is missing (daily crons not run on prod?) → Aggregated data for 2012-09-12 is missing (reports_clean not updated to the end of 2012-09-12)
We ran last night's upgrade pretty near midnight UTC.  I did a manual backfill of reports-clean to make sure it filled to the end of the day, but most likely I did my time calculations incorrectly.  If this problem does not recur tommorrow, that can be assumed to be the diagnosis.
Rob, Josh, this is fixed with the bug 790996 backfill, right? Can we mark it so? ;-)
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.