Page MenuHomePhabricator

Remove views on ep_* tables on the wikireplicas hosts
Closed, ResolvedPublic

Description

The following tables were removed from production - please clean up any related views that might exist on the wikireplicas.

ep_articles
ep_cas
ep_courses
ep_events
ep_instructors
ep_oas
ep_orgs
ep_revisions
ep_students
ep_users_per_course

Details

Related Gerrit Patches:

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

Marostegui triaged this task as Medium priority.Feb 19 2019, 8:36 AM
Marostegui created this task.

Mentioned in SAL (#wikimedia-operations) [2019-02-19T13:23:04Z] <gtirloni> running maintain-views --all-databases --replace-all --clean --debug on labsdb1009 (T216481)

Change 491481 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] wiki replicas: depool labsdb1010 for changes

https://gerrit.wikimedia.org/r/491481

Change 491481 merged by GTirloni:
[operations/puppet@production] wiki replicas: depool labsdb1010 for changes

https://gerrit.wikimedia.org/r/491481

Mentioned in SAL (#wikimedia-operations) [2019-02-19T14:04:10Z] <gtirloni> running maintain-views --all-databases --replace-all --clean --debug on labsdb1010 (T216481)

Mentioned in SAL (#wikimedia-operations) [2019-02-19T15:09:44Z] <gtirloni> depooled labsdb1010 T216481

Change 491525 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] Revert "wiki replicas: depool labsdb1010 for changes"

https://gerrit.wikimedia.org/r/491525

Change 491525 merged by GTirloni:
[operations/puppet@production] Revert "wiki replicas: depool labsdb1010 for changes"

https://gerrit.wikimedia.org/r/491525

Mentioned in SAL (#wikimedia-operations) [2019-02-19T16:18:54Z] <gtirloni> re-pooled labsdb1010 T216481

Change 491530 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] wiki replicas: depool labsdb1011 for changes

https://gerrit.wikimedia.org/r/491530

Change 491530 merged by GTirloni:
[operations/puppet@production] wiki replicas: depool labsdb1011 for changes

https://gerrit.wikimedia.org/r/491530

Mentioned in SAL (#wikimedia-operations) [2019-02-19T16:39:26Z] <gtirloni> depooled labsdb1011 T216481

Change 491560 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] Revert "wiki replicas: depool labsdb1011 for changes"

https://gerrit.wikimedia.org/r/491560

Change 491560 merged by GTirloni:
[operations/puppet@production] Revert "wiki replicas: depool labsdb1011 for changes"

https://gerrit.wikimedia.org/r/491560

Mentioned in SAL (#wikimedia-operations) [2019-02-19T19:39:12Z] <gtirloni> re-pooled labsdb1011 T216481

Views removed.

mysql:root@localhost [(none)]> use enwiki_p;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql:root@localhost [enwiki_p]> select * from ep_articles limit 10;
ERROR 1146 (42S02): Table 'enwiki_p.ep_articles' doesn't exist
GTirloni closed this task as Resolved.Feb 19 2019, 7:40 PM