Page MenuHomePhabricator

Drop flaggedpage_config.fpc_select column on wmf wikis
Closed, ResolvedPublic


  1. ALTERs to run:
  2. Where to run those changes: flaggedrevs.dblist
  3. When to run those changes: When DBA has time.
  4. If the schema change is backwards compatible: Yes.
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster runs with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: No change to current rules required.

Event Timeline

Ladsgroup triaged this task as Medium priority.
Ladsgroup moved this task from Triage to In progress on the DBA board.
Ladsgroup added a subscriber: Ladsgroup.

I'll do it on Monday, it's quite simple.

Please coordinate with me before doing this. The views need to be recreated

Sure. I have recreated views before (with depool too)

Change 796534 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] mariadb: Remove fpc_select from filtered_tables.txt

Change 796534 abandoned by Ladsgroup:

[operations/puppet@production] mariadb: Remove fpc_select from filtered_tables.txt



@Ladsgroup has the schema change already been applied to production? Or is it just the views that were updated

Both are done.

Cool, thanks (just wondering since I'm used to notes about host by host progress)

Yeah, it's a small table with not that much reads nor writes so I could run the alter on master with replication and in the cloud, I ran maintain-views live.