Page MenuHomePhabricator

Drop pre-MCR schema fields in Wikimedia production
Open, HighPublic

Description

  • drop rev_text_id, rev_content_model, and rev_content_format from the revision table
  • drop ar_text_id, ar_content_model, and ar_content_format from the archive table.

It's probably best to first try this on testwiki, see if anything breaks, and only then continue to roll this out too databases.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 23 2019, 12:17 AM
daniel updated the task description. (Show Details)Nov 25 2019, 1:49 PM
daniel updated the task description. (Show Details)Nov 25 2019, 3:52 PM
daniel updated the task description. (Show Details)
WDoranWMF added a subscriber: WDoranWMF.

Following on from email I sent as a heads up for this work, I'm tagging DBA so it's on their radar.

Following on from email I sent as a heads up for this work, I'm tagging DBA so it's on their radar.

Thanks - I am replying to your email now.

As said on the email, I am removing the DBA tag as there is no actionable for us here at the moment.
Once this is ready to go, please send a task with the Schema Change template: https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change

@Marostegui We'll update the format of this ticket to be more in line with T233135 once we've built the migration script. This is currently a placeholder to start planning

@Marostegui We'll update the format of this ticket to be more in line with T233135 once we've built the migration script. This is currently a placeholder to start planning

Excellent - thanks!

daniel triaged this task as High priority.Thu, Jan 9, 12:58 PM

Any ETA on when will this be actionable for DBAs? Not to push, just to organize ourselves around this.
SRE might schedule a DC switchover and it would be helpful for us to know rough timing on when this schema change will be ready to go, as we can save time if we get it scheduled for the switchover.

Thanks!

Anomie added a subscriber: daniel.Fri, Jan 10, 3:24 PM

Current status:

Thanks Anomie, very useful recap! :-)
I will stand by then!
Thanks!