1181503 - Drop the files column from the revision table on stage/prod

Status: RESOLVED FIXED

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

Description

[Ed Morley [:emorley]]

Once bug 1179214 is deployed we should drop the files column:

manage.py run_sql -s "ALTER TABLE revision DROP COLUMN files;"

Comment 1

[Ed Morley [:emorley]]

Run on Heroku:

[~/src/treeherder]$ heroku run './manage.py run_sql -s "ALTER TABLE revision DROP COLUMN files;"'
Running `./manage.py run_sql -s "ALTER TABLE revision DROP COLUMN files;"` attached to terminal... up, run.2001
SQL command: ALTER TABLE revision DROP COLUMN files;
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 "A LTER TABLE revision DROP COLUMN files;"
SQL command: ALTER TABLE revision DROP COLUMN files;
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 'files'; check that column/key exists")

real    0m14.402s
user    0m1.122s
sys     0m0.173s

Comment 3

[Ed Morley [:emorley]]

Prod:

[[e-mail]3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "ALTER T ABLE revision DROP COLUMN files;"
SQL command: ALTER TABLE revision DROP COLUMN files;
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 'files'; check that column/key exists")

real    0m21.517s
user    0m1.000s
sys     0m0.151s