Closed
Bug 857203
Opened 11 years ago
Closed 11 years ago
Backfill Socorro for 04-01-2013
Categories
(Data & BI Services Team :: DB: MySQL, task)
Data & BI Services Team
DB: MySQL
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: laura, Assigned: mpressman)
Details
Please run backfill for yesterday. Thanks! (Investigation is in bug 857100)
Assignee | ||
Updated•11 years ago
|
Assignee: server-ops-database → mpressman
Assignee | ||
Comment 1•11 years ago
|
||
running backfill now... breakpad=# select backfill_matviews('2013-04-01', '2013-04-02');
Assignee | ||
Comment 2•11 years ago
|
||
backfill completed successfully breakpad=# select backfill_matviews('2013-04-01', '2013-04-02'); INFO: last day of backfill period is after final day of ADU. adjusting last day to 2013-04-01 INFO: backfilling reports_clean INFO: backfilling 06:00:00 of reports_clean starting at 2013-04-01 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 2013-04-01 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 2013-04-01 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 2013-04-01 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 06:00:00 of reports_clean starting at 2013-04-02 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 2013-04-02 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 03:00:00 of reports_clean starting at 2013-04-02 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 other matviews for 2013-04-01 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) Time: 4512853.187 ms
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•