Closed Bug 822724 Opened 13 years ago Closed 13 years ago

Backfill missing Socorro aggregation data for 2012-12-17

Categories

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

task
Not set
major

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: kairo, Assigned: mpressman)

Details

Aggregation data on Socorro prod for the 17th is missing, so we need to backfill that data for any crash analysis work to be done on it. (Note that IIRC from what I heard in the last few backfills, you nowadays need to specify the date twice for the backfilling function to work correctly.)
Assignee: server-ops-database → mpressman
backfill complete breakpad=# select backfill_matviews('2012-12-17','2012-12-17'); INFO: backfilling reports_clean INFO: backfilling 06:00:00 of reports_clean starting at 2012-12-17 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 INFO: backfilling 06:00:00 of reports_clean starting at 2012-12-17 06: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 INFO: backfilling 06:00:00 of reports_clean starting at 2012-12-17 12: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 INFO: backfilling 06:00:00 of reports_clean starting at 2012-12-17 18: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 INFO: backfilling other matviews for 2012-12-17 INFO: adu INFO: signatures INFO: tcbs NOTICE: table "new_tcbs" does not exist, skipping CONTEXT: SQL statement "DROP TABLE IF EXISTS new_tcbs" PL/pgSQL function backfill_matviews(date,date,boolean) line 66 at SQL statement INFO: crashes by user INFO: home page graph INFO: hang report (slow) INFO: nightly builds INFO: rank_compare INFO: explosiveness (slow) NOTICE: table "crash_madu" does not exist, skipping CONTEXT: SQL statement "DROP TABLE IF EXISTS crash_madu" PL/pgSQL function backfill_explosiveness(date) line 5 at SQL statement SQL statement "SELECT backfill_explosiveness(thisday)" PL/pgSQL function backfill_matviews(date,date,boolean) line 87 at PERFORM NOTICE: table "xtab_mult" does not exist, skipping CONTEXT: SQL statement "DROP TABLE IF EXISTS xtab_mult" PL/pgSQL function backfill_explosiveness(date) line 6 at SQL statement SQL statement "SELECT backfill_explosiveness(thisday)" PL/pgSQL function backfill_matviews(date,date,boolean) line 87 at PERFORM NOTICE: table "crash_xtab" does not exist, skipping CONTEXT: SQL statement "DROP TABLE IF EXISTS crash_xtab" PL/pgSQL function backfill_explosiveness(date) line 7 at SQL statement SQL statement "SELECT backfill_explosiveness(thisday)" PL/pgSQL function backfill_matviews(date,date,boolean) line 87 at PERFORM NOTICE: table "explosive_oneday" does not exist, skipping CONTEXT: SQL statement "DROP TABLE IF EXISTS explosive_oneday" PL/pgSQL function backfill_explosiveness(date) line 8 at SQL statement SQL statement "SELECT backfill_explosiveness(thisday)" PL/pgSQL function backfill_matviews(date,date,boolean) line 87 at PERFORM NOTICE: table "explosive_threeday" does not exist, skipping CONTEXT: SQL statement "DROP TABLE IF EXISTS explosive_threeday" PL/pgSQL function backfill_explosiveness(date) line 9 at SQL statement SQL statement "SELECT backfill_explosiveness(thisday)" PL/pgSQL function backfill_matviews(date,date,boolean) line 87 at PERFORM INFO: correlations backfill_matviews ------------------- t (1 row)
Status: NEW → RESOLVED
Closed: 13 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.