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

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 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)

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

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

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

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

Change 735723 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/puppet@production] maintain-views.yaml: remove dropped ep_* tables

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

Change 735723 merged by Andrew Bogott:

[operations/puppet@production] maintain-views.yaml: remove dropped ep_* tables

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

Change 737487 had a related patch set uploaded (by Andrew Bogott; author: Andrew Bogott):

[operations/puppet@production] dbproxy1018: depool s1 primary server for maintain_views run

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

Change 737487 merged by Andrew Bogott:

[operations/puppet@production] dbproxy1018: depool s1 primary server for maintain_views run

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

Change 737502 had a related patch set uploaded (by Andrew Bogott; author: Andrew Bogott):

[operations/puppet@production] dbproxy1018: depool s2-s8 primary servers for maintain_views run

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

Change 737502 merged by Andrew Bogott:

[operations/puppet@production] dbproxy1018: depool s2-s8 primary servers for maintain_views run

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

Mentioned in SAL (#wikimedia-cloud) [2021-11-08T21:50:22Z] <andrewbogott> returned clouddb pools back to normal after maintain_views run: https://gerrit.wikimedia.org/r/c/operations/puppet/+/737505 T216481