Page MenuHomePhabricator

Database table for request tool needs maintenance to prevent data loss
Closed, ResolvedPublic

Description

The fnbot.review_filter table in the request tool's database is not currently being replicated because the recent toolsdb crash caused a mismatch in some replicated data.

In order to restore replication, we will need to find time to shut down the tool and reimport it.

Event Timeline

Just bumping this task. Is there a good time to take down the tool @FNDE? I can shut it down myself if that works in order to resync this.

I don't know if this table is written to by a webservice or a cron job, though.

nskaggs moved this task from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.

Following up on this; can we safely shutdown the tool and do this work @FNDE ?

@FNDE: Could you please answer the last comment? Thanks in advance!

Change 636469 had a related patch set uploaded (by Bstorm; owner: Bstorm):
[operations/puppet@production] toolsdb: remove temporarily replication filters

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

Bstorm claimed this task.

I removed the filters after restoring replication in T266587

Change 636469 merged by Bstorm:
[operations/puppet@production] toolsdb: remove temporary replication filters

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