Page MenuHomePhabricator
Create Task
Maniphest T216481

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

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

SubjectRepoBranchLines +/-
dbproxy1018: depool s2-s8 primary servers for maintain_views runoperations/puppetproduction+21 -21
dbproxy1018: depool s1 primary server for maintain_views runoperations/puppetproduction+3 -3
maintain-views.yaml: remove dropped ep_* tablesoperations/puppetproduction+0 -17
Revert "wiki replicas: depool labsdb1011 for changes"operations/puppetproduction+2 -2
wiki replicas: depool labsdb1011 for changesoperations/puppetproduction+2 -2
Revert "wiki replicas: depool labsdb1010 for changes"operations/puppetproduction+2 -2
wiki replicas: depool labsdb1010 for changesoperations/puppetproduction+2 -2
Customize query in gerrit

Related Objects
Search...

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.
StatusSubtypeAssignedTask
· · ·
ResolvedMarosteguiT174802 Archive and drop education program (ep_*) tables on all wikis
Resolved• GTirloniT216481 Remove views on ep_* tables on the wikireplicas hosts
· · ·

Event Timeline

Marostegui triaged this task as Medium priority.Feb 19 2019, 8:36 AM
Marostegui created this task.
Marostegui mentioned this in T174802: Archive and drop education program (ep_*) tables on all wikis.Feb 19 2019, 8:41 AM
Kizule added a project: cloud-services-team (Kanban).Feb 19 2019, 9:30 AM

Per T211939

• GTirloni claimed this task.Feb 19 2019, 12:03 PM
Stashbot subscribed.Feb 19 2019, 1:23 PM

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

• GTirloni mentioned this in T211939: Drop several views from srwikinews.Feb 19 2019, 1:55 PM
gerritbot added a comment.Feb 19 2019, 2:01 PM

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

gerritbot added a project: Patch-For-Review.Feb 19 2019, 2:01 PM

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

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

Stashbot added a comment.Feb 19 2019, 2:04 PM

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

Stashbot added a comment.Feb 19 2019, 3:09 PM

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

Kizule added a comment.Feb 19 2019, 3:37 PM

This is done?

• GTirloni added a comment.Feb 19 2019, 3:39 PM

Not yet.

gerritbot added a comment.Feb 19 2019, 4:15 PM

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

gerritbot added a comment.Feb 19 2019, 4:17 PM

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

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

Stashbot added a comment.Feb 19 2019, 4:18 PM

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

gerritbot added a comment.Feb 19 2019, 4:35 PM

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

gerritbot added a comment.Feb 19 2019, 4:36 PM

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

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

Stashbot added a comment.Feb 19 2019, 4:39 PM

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

gerritbot added a comment.Feb 19 2019, 7:33 PM

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

gerritbot added a comment.Feb 19 2019, 7:35 PM

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

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

Stashbot added a comment.Feb 19 2019, 7:39 PM

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

• GTirloni added a comment.Feb 19 2019, 7:40 PM

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
Liuxinyu970226 unsubscribed.Feb 25 2019, 1:03 AM
gerritbot added a comment.Oct 30 2021, 9:57 PM

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

Zabe subscribed.Oct 30 2021, 9:59 PM
gerritbot added a comment.Nov 8 2021, 8:02 PM

Change 735723 merged by Andrew Bogott:

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

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

gerritbot added a comment.Nov 8 2021, 8:03 PM

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

gerritbot added a comment.Nov 8 2021, 8:04 PM

Change 737487 merged by Andrew Bogott:

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

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

gerritbot added a comment.Nov 8 2021, 9:36 PM

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

gerritbot added a comment.Nov 8 2021, 9:39 PM

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

Andrew added subscribers: • razzi, User-razzi.Nov 8 2021, 9:48 PM
Stashbot added a comment.Nov 8 2021, 9:50 PM

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

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL