Page MenuHomePhabricator
Create Task
Maniphest T231668

MCR schema migration
Closed, ResolvedPublic
Actions

Description

There are remaining tasks necessary to complete the schema migration for MCR. This initiative will resolve those remaining tasks, completing the MCR schema migration.

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedNoneT231668 MCR schema migration
 ResolvedZabeT231674 [Epic] Remove support for writing to the pre-MCR schema
 ResolveddanielT198557 Remove the ability to write pre-MCR fields, limit the ability to read pre-MCR fields to migration scripts
 ResolvedCCicalese_WMFT242764 Test schema update from old versions to MCR-only schema
 ResolveddanielT231673 Make SCHEMA_COMPAT_NEW the default MCR migration schema
 Resolved• ClarakosiT214308 Force usage of MCR aware database schema
 ResolvedNoneT231672 Stop writing to pre-MCR fields in WMF production
 ResolvedNoneT183487 MCR schema migration stage 3: stop using legacy fields
 Resolved• tstarlingT183488 MCR schema migration stage 2: populate new fields
 ResolvedAnomieT183489 MCR schema migration stage 1: Fix Legacy Archive Rows
 ResolvedAnomieT183486 MCR schema migration stage 0: create tables
 ResolvedAnomieT36925 [MCR] create maintenance script for Migration of text from archive table to text table
 ResolvedAnomieT184629 Run maintenance/migrateArchiveText.php on all wikis
 ResolvedAnomieT191307 Run maintenance/populateArchiveRevId.php on all wikis
 ResolvedAnomieT193180 Clean up archive rows with duplicate revision IDs
 ResolvedAnomieT202032 Duplicate ar_rev_id values in several wikis
 ResolvedAnomieT174030 Implement DB schema migration tools for MCR
 ResolveddanielT174028 Finalize database schema for MCR content meta-data
ResolvedAnomieT182678 [MCR] Script for populating empty ar_rev_id fields
 ResolvedAnomieT182682 [MCR] Script(s) for populating new tables (slots, content, content_models, slot_roles)
 ResolvedMarosteguiT190153 DROP unused 'slots' table (WAS: In the slots table, replace slot_inherited with slot_origin)
 ResolvedAnomieT196172 Test schema migration script
 Resolved• tstarlingT197816 Enable MCR migration stage "write both, read old" on live systems
 ResolvedAnomieT197817 Enable MCR migration stage "write both, read old" on testwiki
 ResolvedAnomieT198312 Set the WMF cluster to use the new MCR-only schema
 ResolveddanielT198558 Set testwiki to use the new MCR-only schema
 ResolveddanielT198559 Set Beta Cluster wikis to use the new MCR-only schema
 ResolvedAnomieT198311 Enable MCR migration stage "write both, read new" on commons beta.
 ResolvedAnomieT197818 Enable MCR migration stage "write both, read old" on commons beta.
 ResolveddanielT197619 Introduce SCHEMA_COMPAT_XXX constants to allow more fine grained control over the migration process
 ResolveddanielT198413 Allow multiple slots to be used while still writing to the old as well as the new schema
 ResolveddanielT236735 Allow WikiExporter to function with MCR-only schema
 ResolvedNoneT231671 [EPIC] Ensure all direct or indirect access to pre-MCR fields is gated with the MCR migration stage and emits a warning if any pre-MCR schema fields are accessed
 ResolvedCCicalese_WMFT231689 Can get bulk access from code that has been using the 'text' for getQueryInfo()
ResolvedCCicalese_WMFT231693 No direct or indirect access to pre-MCR fields is ungated
 ResolveddanielT198341 Remove all references to the rev_text_id and ar_text_id fields
 Resolved• PcheloloT198342 Remove all usages of the 'text' flag in calls to Revision::getQueryInfo() and RevisionStore::getQueryInfo().
 ResolveddanielT198706 Make BackupDumper, WikiExporter and XmlDumpWriter compliant with the MCR revision retrival mechanism (main slot only)
 ResolvedBPirkleT203424 Replace the WikiExporter backup dump streaming mode with batched queries
 Resolved• PcheloloT233356 Flow: remove dependency on pre-MCR database schema
 Resolved• ClarakosiT233357 ReplaceText: remove dependency on pre-MCR database schema
 ResolveddanielT233358 SpamBlacklist: remove dependency on pre-MCR database schema
 Resolved• PcheloloT198343 Replace all calls to Revision::getRevisionText()
 Resolved• PcheloloT228675 Remove direct access to the text table from the Translate extension.
 Resolved• PcheloloT228988 Create batch access interface for page content
 Resolved• PcheloloT233173 Make RevisionStore::newRevisionsFromBatch use BlobStore::getBlobBatch
 Resolved• PcheloloT230834 Create batch access interface for BlobStore
 ResolveddanielT234034 Create low level batch access interface for page content
 ResolveddanielT233350 ActiveAbstract: remove dependency on pre-MCR database schema
 Resolved• holger.knustT233353 EntitySchema: remove dependency on pre-MCR database schema
 Resolved• PcheloloT233355 WikimediaMaintenance: remove dependency on pre-MCR database schema
 ResolvedNoneT231699 A warning is emitted if any pre-MCR fields are accessed
 ResolvedNoneT200918 Make sure code that accesses legacy pre-MCR fields triggers warnings before switching off WRITE_OLD (compat) mode.
 ResolveddanielT238958 Remove pre-MCR schema fields during update
 ResolvedNoneT174047 Hide deprecated/unused fields on toolforge replica [MCR]

Event Timeline

CCicalese_WMF created this task.Aug 30 2019, 5:15 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 30 2019, 5:15 PM
CCicalese_WMF triaged this task as Medium priority.Aug 30 2019, 5:15 PM
daniel mentioned this in T214308: Force usage of MCR aware database schema.Sep 17 2019, 1:35 PM
CCicalese_WMF closed subtask T231671: [EPIC] Ensure all direct or indirect access to pre-MCR fields is gated with the MCR migration stage and emits a warning if any pre-MCR schema fields are accessed as Resolved.Nov 4 2019, 3:38 PM
CCicalese_WMF closed subtask T231672: Stop writing to pre-MCR fields in WMF production as Resolved.Nov 22 2019, 9:36 PM
Jdforrester-WMF closed subtask T231673: Make SCHEMA_COMPAT_NEW the default MCR migration schema as Resolved.Nov 22 2019, 10:07 PM
• eprodromou added a project: Platform Team Workboards (Initiatives).Mar 17 2020, 5:37 PM
• eprodromou moved this task from Later to Now on the Platform Team Workboards (Initiatives) board.
• eprodromou moved this task from Now to Paused on the Platform Team Workboards (Initiatives) board.
CCicalese_WMF removed a project: Platform Engineering.Mar 18 2020, 5:05 PM
Naike changed the task status from Open to Stalled.May 29 2020, 9:14 AM
Zabe closed subtask T231674: [Epic] Remove support for writing to the pre-MCR schema as Resolved.Apr 14 2022, 7:15 PM
Aklapper closed this task as Resolved.Aug 14 2023, 11:50 AM

Resolving task (plus archiving https://phabricator.wikimedia.org/project/view/4217/ ) as there are zero open subtasks and no updates for years

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits