Page MenuHomePhabricator

Remove views from flaggedimages
Closed, ResolvedPublic

Description

flaggedimages table has been dropped in production. Please clean up the views accordingly.

This is done except for clouddb1020. When clouddb1020 is ready:

On clouddb1020:
/usr/local/sbin/maintain-views --replace-all --all-databases --clean
revert: https://gerrit.wikimedia.org/r/c/operations/puppet/+/724457
On dbproxy1018:
sudo -i puppet agent -t
sudo systemctl reload haproxy

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

@mdipietro We should put up a patch to remove this at the same time as T291806. I wouldn't worry about announcing this if the table is already dropped. The data would not be changing anyway at best, and it's already gone and throwing errors at worst.

Change 726980 had a related patch set uploaded (by Michael DiPietro; author: Michael DiPietro):

[operations/puppet@production] remove table from maintain-views

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

Change 726980 merged by Michael DiPietro:

[operations/puppet@production] remove table from maintain-views

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

This is now done on all nodes but clouddb[1017-1018].eqiad.wmnet and 1020 (which is offline for repairs)

Change 727438 had a related patch set uploaded (by Michael DiPietro; author: Michael DiPietro):

[operations/puppet@production] depool clouddb1018

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

Change 727438 merged by Michael DiPietro:

[operations/puppet@production] depool clouddb1018

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

All views updated. Need to repool clouddb1018

rook updated the task description. (Show Details)

@Marostegui please let us know when clouddb1020 is ready to be repooled.

I thin it can be repooled now (keep in mind that I am coming from 2 weeks of vacation) but after reading the thread at T292850#7434809 I think it is fine to repool.