We're not currently using this table - let's just remove it until an actual use-case makes itself clear.

eg on prod: Execute: > SELECT * FROM mozilla_inbound_jobs_1.result_set_artifact + ------- + ------------------ + --------- + --------- + --------- + ------------------ + | id | result_set_id | name | type | blob | active_status | + ------- + ------------------ + --------- + --------- + --------- + ------------------ + | NULL | NULL | NULL | NULL | NULL | NULL | + ------- + ------------------ + --------- + --------- + --------- + ------------------ + 1 rows

Once this lands & is deployed, I'll do a: ./manage.py run_sql -s "DROP TABLE IF EXISTS result_set_artifact;" ...on stage/prod.

Commit pushed to master at https://github.com/mozilla/treeherder https://github.com/mozilla/treeherder/commit/e9efcf85842e65d014da17da449d5f0ad1384659 Bug 1178224 - Remove the unused result_set_artifact table

[emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "DROP TABLE result_set_artifact;" SQL command: DROP TABLE result_set_artifact; 66 datasource found -------------------------- Sql code executed on addon-sdk - jobs: -------------------------- Sql code executed on alder - jobs: <snip> real 0m3.455s user 0m1.025s sys 0m0.140s [emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py dbshell mysql> SELECT table_schema, table_name FROM information_schema.tables WHERE table_name = 'result_set_artifact'; Empty set (0.03 sec)

And prod... [emorley@treeherder-rabbitmq1.private.scl3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "DROP TA BLE result_set_artifact;" SQL command: DROP TABLE result_set_artifact; 72 datasource found -------------------------- Sql code executed on accessibility - jobs: <snip> real 0m2.795s user 0m0.955s sys 0m0.141s [emorley@treeherder-rabbitmq1.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py dbshell mysql> SELECT table_schema, table_name FROM information_schema.tables WHERE table_name = 'result_set_artifact'; Empty set (0.07 sec)

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