1179011 - Drop the parse_timestamp column from the job_log_url table on stage/prod

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, defect, P3)

Description

[Ed Morley [:emorley]]

Once bug 1178389 is deployed we should drop the parse_timestamp column:

manage.py run_sql -s "ALTER TABLE job_log_url DROP COLUMN parse_timestamp;"

Comment 1

[Ed Morley [:emorley]]

Dropped on Heroku:

[~/src/treeherder]$ heroku run './manage.py run_sql -s "ALTER TABLE job_log_url DROP COLUMN parse_timestamp;"'
Running `./manage.py run_sql -s "ALTER TABLE job_log_url DROP COLUMN parse_timestamp;"` attached to terminal... up, run.7593
SQL command: ALTER TABLE job_log_url DROP COLUMN parse_timestamp;
44 datasource found
--------------------------
Sql code executed on mozilla-central - jobs:
--------------------------
Sql code executed on mozilla-inbound - jobs:
--------------------------
Sql code executed on b2g-inbound - jobs:
--------------------------
...

Comment 2

[Ed Morley [:emorley]]

Stage:

[[e-mail]3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "ALTER TABLE job_log_url DROP COLUMN parse_timestamp;"
SQL command: ALTER TABLE job_log_url DROP COLUMN parse_timestamp;
67 datasource found
--------------------------
Sql code executed on addon-sdk - jobs:
--------------------------
Sql code executed on alder - jobs:
--------------------------
...
--------------------------
Sql code executed on bugzilla-4_2 - jobs:
--------------------------
Sql code executed on bmo-development - jobs:
--------------------------
!!! Sql code execution failed on mozilla-b2g37_v2_2r - jobs !!!
(1091, "Can't DROP 'parse_timestamp'; check that column/key exists")

real    5m0.301s
user    0m1.081s
sys     0m0.188s

Comment 3

[Ed Morley [:emorley]]

Prod:

[[e-mail]3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "ALTER TABLE job_log_url DROP COLUMN parse_timestamp;"
SQL command: ALTER TABLE job_log_url DROP COLUMN parse_timestamp;
73 datasource found
--------------------------
Sql code executed on accessibility - jobs:
--------------------------
Sql code executed on addon-sdk - jobs:
--------------------------
...
--------------------------
Sql code executed on bugzilla-4_2 - jobs:
--------------------------
Sql code executed on bmo-development - jobs:
--------------------------
!!! Sql code execution failed on mozilla-b2g37_v2_2r - jobs !!!
(1091, "Can't DROP 'parse_timestamp'; check that column/key exists")

real    11m18.319s
user    0m1.107s
sys     0m0.177s