1178852 - Drop the old djcelery_* tables

Status: RESOLVED FIXED

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

Description

[Ed Morley [:emorley]]

Older versions of Django required that we use django-celery.
We no longer use it any more, so can remove the old tables left behind:

`treeherder`.`djcelery_crontabschedule`
`treeherder`.`djcelery_intervalschedule`
`treeherder`.`djcelery_periodictask`
`treeherder`.`djcelery_periodictasks`
`treeherder`.`djcelery_taskstate`
`treeherder`.`djcelery_workerstate`

Comment 1

[Ed Morley [:emorley]]

We stopped using django-celery in:
https://github.com/mozilla/treeherder/commit/6dc451372ba70537c412fcd1bdd6fa0a9e8e8d9f

Stage...

mysql> SELECT table_schema, table_name FROM information_schema.tables WHERE table_name LIKE 'djcelery%';
Empty set (0.00 sec)


Prod...

mysql> SELECT table_schema, table_name FROM information_schema.tables WHERE table_name LIKE 'djcelery%';
+--------------+---------------------------+
| table_schema | table_name                |
+--------------+---------------------------+
| treeherder   | djcelery_crontabschedule  |
| treeherder   | djcelery_intervalschedule |
| treeherder   | djcelery_periodictask     |
| treeherder   | djcelery_periodictasks    |
| treeherder   | djcelery_taskstate        |
| treeherder   | djcelery_workerstate      |
+--------------+---------------------------+
6 rows in set (0.04 sec)

mysql> DROP TABLE treeherder.djcelery_periodictask;
Query OK, 0 rows affected (0.09 sec)

mysql> DROP TABLE treeherder.djcelery_periodictasks;
Query OK, 0 rows affected (0.04 sec)

mysql> DROP TABLE treeherder.djcelery_taskstate;
Query OK, 0 rows affected (0.02 sec)

mysql> DROP TABLE treeherder.djcelery_workerstate;
Query OK, 0 rows affected (0.01 sec)

mysql> DROP TABLE treeherder.djcelery_crontabschedule;
Query OK, 0 rows affected (0.02 sec)

mysql> DROP TABLE treeherder.djcelery_intervalschedule;
Query OK, 0 rows affected (0.01 sec)

mysql> SELECT table_schema, table_name FROM information_schema.tables WHERE table_name LIKE 'djcelery%';
Empty set (0.04 sec)