Get ADI pushed and backfill missing Socorro aggregation data for 2013-03-22

RESOLVED FIXED

Status

RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: kairo, Assigned: selenamarie)

Tracking

Details

(Reporter)

Description

6 years ago
Aggregation data on Socorro prod for the 22nd is missing, so we need to backfill that data for any crash analysis work to be done on it.

Unfortunately, it looks like we still don't have the ADI yet, though, so that needs to be pushed by metrics first:

breakpad=> SELECT max(date) FROM raw_adu;
    max     
------------
 2013-03-21
(1 row)
(Reporter)

Comment 1

6 years ago
Looks to me like ADI are probably there now:

breakpad=> SELECT max(date) FROM raw_adu;
    max     
------------
 2013-03-22
(1 row)
Started...

breakpad=# select backfill_matviews('2013-03-22','2013-03-22');
INFO:  backfilling reports_clean
INFO:  backfilling 06:00:00 of reports_clean starting at 2013-03-22 00:00:00+00
CONTEXT:  SQL statement "SELECT backfill_reports_clean( first_rc, last_rc )"
PL/pgSQL function backfill_matviews(date,date,boolean) line 52 at PERFORM
Severity: major → normal
Assignee: server-ops-database → sdeckelmann
Finished
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.