Closed
Bug 800372
Opened 13 years ago
Closed 13 years ago
Explanation of backfill errors: explosiveness failure on tables not existing
Categories
(Socorro :: Database, task)
Tracking
(Not tracked)
RESOLVED
INVALID
People
(Reporter: selenamarie, Assigned: jberkus)
Details
Josh -- could you comment on why the errors below are occurring? I'm tied up with giving a talk until noon today.
-selena
CONTEXT: SQL statement "SELECT backfill_reports_clean( first_rc, last_rc )"
PL/pgSQL function "backfill_matviews" line 51 at PERFORM
psql:run_backfill.sql:3: INFO: rank_compare
psql:run_backfill.sql:3: INFO: explosiveness (slow)
psql:run_backfill.sql:3: NOTICE: table "crash_madu" does not exist, skipping
CONTEXT: SQL statement "DROP TABLE IF EXISTS crash_madu"
PL/pgSQL function "backfill_explosiveness" line 4 at SQL statement
SQL statement "SELECT backfill_explosiveness(thisday)"
PL/pgSQL function "backfill_matviews" line 86 at PERFORM
psql:run_backfill.sql:3: NOTICE: table "xtab_mult" does not exist, skipping
CONTEXT: SQL statement "DROP TABLE IF EXISTS xtab_mult"
PL/pgSQL function "backfill_explosiveness" line 5 at SQL statement
SQL statement "SELECT backfill_explosiveness(thisday)"
PL/pgSQL function "backfill_matviews" line 86 at PERFORM
psql:run_backfill.sql:3: NOTICE: table "crash_xtab" does not exist, skipping
CONTEXT: SQL statement "DROP TABLE IF EXISTS crash_xtab"
PL/pgSQL function "backfill_explosiveness" line 6 at SQL statement
SQL statement "SELECT backfill_explosiveness(thisday)"
PL/pgSQL function "backfill_matviews" line 86 at PERFORM
psql:run_backfill.sql:3: NOTICE: table "explosive_oneday" does not exist, skipping
CONTEXT: SQL statement "DROP TABLE IF EXISTS explosive_oneday"
PL/pgSQL function "backfill_explosiveness" line 7 at SQL statement
SQL statement "SELECT backfill_explosiveness(thisday)"
PL/pgSQL function "backfill_matviews" line 86 at PERFORM
psql:run_backfill.sql:3: NOTICE: table "explosive_threeday" does not exist, skipping
CONTEXT: SQL statement "DROP TABLE IF EXISTS explosive_threeday"
PL/pgSQL function "backfill_explosiveness" line 8 at SQL statement
SQL statement "SELECT backfill_explosiveness(thisday)"
PL/pgSQL function "backfill_matviews" line 86 at PERFORM
psql:run_backfill.sql:3: INFO: correlations
backfill_matviews
-------------------
t
Reporter | ||
Updated•13 years ago
|
Assignee: nobody → josh
Assignee | ||
Comment 1•13 years ago
|
||
Selena,
So that's some CYA in the backfill script. Most of the temp tables in the various Matview functions are created "ON COMMIT DROP" and not explicitly dropped, so the backfill script needs to be sure to drop them if you're doing more than one day in a row. So there's a bunch of DROP IF EXISTS.
This won't be necessary when you move backfill to an external script which commits after each day of work.
Assignee | ||
Comment 2•13 years ago
|
||
Also, those aren't errors, those are INFO statements.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → INVALID
You need to log in
before you can comment on or make changes to this bug.
Description
•