Run maintain-views on the wiki replica servers (labsdb1010, labsdb1009, labsdb1011) for all databases to remove the tables that are being dropped in the upstream schema.
Description
Description
Details
Details
Customize query in gerrit
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | LSobanski | T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) | |||
| Resolved | • Marostegui | T212254 Drop valid_tag table | |||
| Resolved | Ladsgroup | T209525 Migrate tag_summary usage to change_tag and drop the table | |||
| Resolved | • Marostegui | T212255 Drop tag_summary table | |||
| Resolved | • GTirloni | T212308 Rerun maintain-views for all tables to drop valid_tag and tag_summary tables |
Event Timeline
Comment Actions
https://gerrit.wikimedia.org/r/c/operations/puppet/+/480590 is merged and this is ready.
Comment Actions
Change 489220 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] wiki replicas: depool labsdb1009 for updates
Comment Actions
Change 489220 merged by GTirloni:
[operations/puppet@production] wiki replicas: depool labsdb1009 for updates
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2019-02-08T14:51:06Z] <marostegui> Reload haproxy on dbproxy1011 to depool labsdb1009 - https://phabricator.wikimedia.org/T212308
Comment Actions
Change 489239 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] Revert "wiki replicas: depool labsdb1009 for updates"
Comment Actions
Change 489239 merged by GTirloni:
[operations/puppet@production] Revert "wiki replicas: depool labsdb1009 for updates"
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2019-02-08T15:46:01Z] <marostegui> Repool labsdb1009 - T212308
Comment Actions
Change 489683 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] wiki replicas: depool labsdb1010 for changes
Comment Actions
Change 489683 merged by GTirloni:
[operations/puppet@production] wiki replicas: depool labsdb1010 for changes
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2019-02-11T14:09:57Z] <marostegui> Reload haproxy on dbproxy1010 to depool labsdb1010 - T212308
Comment Actions
Change 489713 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] Revert "wiki replicas: depool labsdb1010 for changes"
Comment Actions
Change 489713 merged by GTirloni:
[operations/puppet@production] Revert "wiki replicas: depool labsdb1010 for changes"
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2019-02-11T15:20:57Z] <marostegui> Repool labsdb1010 - T212308
Comment Actions
Change 489714 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] wiki replicas: depool labsdb1011 for changes
Comment Actions
Change 489714 merged by GTirloni:
[operations/puppet@production] wiki replicas: depool labsdb1011 for changes
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2019-02-11T15:23:44Z] <marostegui> Relohad haproxy on dbproxy1010 to depool labsdb1011 - https://phabricator.wikimedia.org/T212308
Comment Actions
Change 489726 had a related patch set uploaded (by GTirloni; owner: GTirloni):
[operations/puppet@production] Revert "wiki replicas: depool labsdb1011 for changes"
Comment Actions
Change 489726 merged by GTirloni:
[operations/puppet@production] Revert "wiki replicas: depool labsdb1011 for changes"
Comment Actions
maintain-view --all-databases --replace-all executed on all replicas (labsdb1009, labsdb1010 and labsdb1011).