Page MenuHomePhabricator

Drop wikishared.wikimedia_editor_tasks_entity_description_exists table from x1
Closed, ResolvedPublic

Description

The table wikimedia_editor_tasks_entity_description_exists no longer lives on x1.
It is still there as a left over, but it is empty and should be removed

root@cumin1001:~# mysql.py -hdb1069 -e "select count(*) from wikimedia_editor_tasks_entity_description_exists" wikishared
+----------+
| count(*) |
+----------+
|        0 |
+----------+

Event Timeline

Marostegui moved this task from Triage to In progress on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2019-04-03T09:27:31Z] <marostegui> Drop wikishared.wikimedia_editor_tasks_entity_description_exists table from x1 T219963

Done

root@db1069.eqiad.wmnet[wikishared]> select count(*) from wikimedia_editor_tasks_entity_description_exists;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

root@db1069.eqiad.wmnet[wikishared]> drop table if exists wikimedia_editor_tasks_entity_description_exists;
Query OK, 0 rows affected (0.04 sec)

root@db1069.eqiad.wmnet[wikishared]> select count(*) from wikimedia_editor_tasks_entity_description_exists;
ERROR 1146 (42S02): Table 'wikishared.wikimedia_editor_tasks_entity_description_exists' doesn't exist