Page MenuHomePhabricator
Create Task
Maniphest T243318

FY2020-2021 Q1 codfw -> eqiad switchback
Closed, ResolvedPublic
Actions

Description

Sub-umbrella task for work blocking the switchback from codfw to eqiad, including maintenance work to be done while codfw is primary.

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedRLazarusT243314 FY2020-2021 Q1 DC switchover and switchback
 ResolvedRLazarusT243318 FY2020-2021 Q1 codfw -> eqiad switchback
 Resolved• MarosteguiT237120 Schema change on production for increase the size of wbt_text_in_lang.wbxl_language
 ResolvedKormatT239238 Switchover s8 primary database master db1109 -> db1104 - 2020-09-29 08:00 UTC
 DuplicateNoneT243374 Enable DB replication eqiad -> codfw before the switchover
 Resolved• MarosteguiT232446 Compress new Wikibase tables
 DeclinedNoneT245107 Possibly replace db1087 (s8) with db1127 (x1) due to disk space constrains
 Resolved• MarosteguiT250055 Remove image.img_deleted column from production
 Resolved• MarosteguiT253276 Normalise MW Core database language fields length
 Resolved• MarosteguiT254462 Compress enwiki InnoDB tables
 Resolved• MarosteguiT238966 Apply updates for MCR, actor migration, and content migration, to production wikis.
 Resolved• BstormT252219 Drop MCR-obsoleted fields from the wiki replicas
 ResolveddanielT253289 Remove USE INDEX usertext_timestamp and other references from code
 ResolveddanielT258480 Query plan changes on enwiki.revision queries with MCR change
 Resolved• MarosteguiT259524 Review revision table and make sure that the PK is always rev_id
 Resolved• MarosteguiT256685 pl_namespace index on pagelinks is unique only in s8
 ResolvedKormatT259831 Schema change to make change_tag.ct_rc_id unsigned
 Resolved• MarosteguiT261914 Enable replication eqiad -> codfw and other checks
 ResolvedTrizek-WMFT264364 CommRel support for FY2020-2021 Q2 DC switchback
 Resolved• MarosteguiT260111 All sorts of random drifts in wikis in s3

Event Timeline

RLazarus created this task.Jan 21 2020, 6:43 PM
• Marostegui triaged this task as Medium priority.Jan 22 2020, 6:11 AM
• Marostegui added subtasks: T239238: Switchover s8 primary database master db1109 -> db1104 - 2020-09-29 08:00 UTC, T186188: Failover DB masters in row D, T237120: Schema change on production for increase the size of wbt_text_in_lang.wbxl_language, T239791: DB: perform rolling restart of mariadb daemons to pick up CA changes.
• Marostegui added a subtask: T232446: Compress new Wikibase tables.Jan 22 2020, 9:38 AM
RLazarus renamed this task from 2020 Q3 (or later) codfw -> eqiad switchback to 2020 Q4 (or later) codfw -> eqiad switchback.Feb 10 2020, 10:44 PM
Aklapper renamed this task from 2020 Q4 (or later) codfw -> eqiad switchback to FY2019-20 Q4 (or later) codfw -> eqiad switchback.Feb 11 2020, 2:09 AM
jcrespo changed the status of subtask T186188: Failover DB masters in row D from Open to Stalled.Apr 29 2020, 7:29 AM
jcrespo removed a subtask: T186188: Failover DB masters in row D.
jcrespo changed the status of subtask T239238: Switchover s8 primary database master db1109 -> db1104 - 2020-09-29 08:00 UTC from Open to Stalled.
• Marostegui changed the status of subtask T232446: Compress new Wikibase tables from Open to Stalled.May 1 2020, 5:13 AM
RLazarus renamed this task from FY2019-20 Q4 (or later) codfw -> eqiad switchback to FY2020-2021 Q1 codfw -> eqiad switchback.May 4 2020, 7:05 PM
• Marostegui added a subtask: T250055: Remove image.img_deleted column from production.May 6 2020, 10:10 AM
• Marostegui removed a subtask: T239791: DB: perform rolling restart of mariadb daemons to pick up CA changes.May 6 2020, 10:24 AM
• Marostegui changed the status of subtask T250055: Remove image.img_deleted column from production from Stalled to Open.May 29 2020, 5:19 AM
• Marostegui closed subtask T250055: Remove image.img_deleted column from production as Resolved.May 29 2020, 10:01 AM
• Marostegui added a subtask: T253276: Normalise MW Core database language fields length.Jun 29 2020, 8:30 AM
• Marostegui added a subtask: T254462: Compress enwiki InnoDB tables.Jul 6 2020, 11:08 AM
• Marostegui changed the status of subtask T253276: Normalise MW Core database language fields length from Open to Stalled.Jul 14 2020, 12:59 PM
• Marostegui added a subtask: T238966: Apply updates for MCR, actor migration, and content migration, to production wikis..Jul 15 2020, 5:05 AM
• Marostegui added a subtask: T256685: pl_namespace index on pagelinks is unique only in s8.
• Marostegui changed the status of subtask T256685: pl_namespace index on pagelinks is unique only in s8 from Open to Stalled.Jul 22 2020, 8:15 AM
• Marostegui changed the status of subtask T254462: Compress enwiki InnoDB tables from Open to Stalled.Aug 3 2020, 5:02 AM
RhinosF1 subscribed.Aug 3 2020, 2:22 PM
• Marostegui added a subtask: T259831: Schema change to make change_tag.ct_rc_id unsigned.Aug 7 2020, 10:58 AM
• Marostegui added a subtask: Restricted Task.Aug 27 2020, 10:11 AM
• Marostegui changed the status of subtask T239238: Switchover s8 primary database master db1109 -> db1104 - 2020-09-29 08:00 UTC from Stalled to Open.Aug 28 2020, 11:37 AM
• Marostegui changed the status of subtask T237120: Schema change on production for increase the size of wbt_text_in_lang.wbxl_language from Stalled to Open.Sep 3 2020, 5:41 AM
• Marostegui closed subtask T237120: Schema change on production for increase the size of wbt_text_in_lang.wbxl_language as Resolved.Sep 3 2020, 9:42 AM
• Marostegui changed the status of subtask T254462: Compress enwiki InnoDB tables from Stalled to Open.Sep 7 2020, 4:34 AM
• Marostegui changed the status of subtask T256685: pl_namespace index on pagelinks is unique only in s8 from Stalled to Open.Sep 7 2020, 4:43 AM
• Marostegui changed the status of subtask T232446: Compress new Wikibase tables from Stalled to Open.Sep 7 2020, 5:08 AM
• Marostegui closed subtask T256685: pl_namespace index on pagelinks is unique only in s8 as Resolved.Sep 7 2020, 8:02 AM
• Marostegui changed the status of subtask T253276: Normalise MW Core database language fields length from Stalled to Open.Sep 8 2020, 6:29 AM
LSobanski subscribed.Sep 8 2020, 1:31 PM
Kormat changed the status of subtask Restricted Task from Open to Stalled.Sep 9 2020, 12:09 PM
• Marostegui closed subtask T253276: Normalise MW Core database language fields length as Resolved.Sep 9 2020, 2:12 PM
• Marostegui closed subtask T254462: Compress enwiki InnoDB tables as Resolved.Sep 11 2020, 2:03 PM
• Marostegui closed subtask T232446: Compress new Wikibase tables as Resolved.Sep 14 2020, 5:13 AM
• Marostegui changed the status of subtask T238966: Apply updates for MCR, actor migration, and content migration, to production wikis. from Open to Stalled.Sep 24 2020, 2:55 PM
Daimona subscribed.Sep 26 2020, 12:49 PM
Kormat closed subtask T239238: Switchover s8 primary database master db1109 -> db1104 - 2020-09-29 08:00 UTC as Resolved.Sep 29 2020, 10:18 AM
• Marostegui removed a subtask: Restricted Task.Sep 30 2020, 8:16 AM
• Marostegui added a subtask: T260111: All sorts of random drifts in wikis in s3.Oct 8 2020, 5:48 AM
• Marostegui closed subtask T260111: All sorts of random drifts in wikis in s3 as Resolved.Oct 8 2020, 6:57 AM
Kormat changed the status of subtask T259831: Schema change to make change_tag.ct_rc_id unsigned from Open to Stalled.Oct 13 2020, 12:58 PM
Kormat closed subtask T259831: Schema change to make change_tag.ct_rc_id unsigned as Resolved.Oct 13 2020, 1:07 PM
Kormat reopened subtask T259831: Schema change to make change_tag.ct_rc_id unsigned as Stalled.
Agusbou2015 subscribed.Oct 14 2020, 12:36 AM
• Marostegui closed subtask T261914: Enable replication eqiad -> codfw and other checks as Resolved.Oct 26 2020, 5:14 PM
• Marostegui mentioned this in T266663: Disconnect codfw -> eqiad replication.Oct 28 2020, 1:00 PM
Trizek-WMF closed subtask T264364: CommRel support for FY2020-2021 Q2 DC switchback as Resolved.Nov 4 2020, 2:41 PM
Kormat changed the status of subtask T259831: Schema change to make change_tag.ct_rc_id unsigned from Stalled to Open.Nov 4 2020, 3:42 PM
Kormat changed the status of subtask T238966: Apply updates for MCR, actor migration, and content migration, to production wikis. from Stalled to Open.Nov 4 2020, 3:44 PM
• Marostegui closed subtask T238966: Apply updates for MCR, actor migration, and content migration, to production wikis. as Resolved.Nov 17 2020, 7:54 AM
Kormat closed subtask T259831: Schema change to make change_tag.ct_rc_id unsigned as Resolved.Nov 18 2020, 11:24 AM
LSobanski reopened subtask T253276: Normalise MW Core database language fields length as Open.Dec 7 2020, 9:57 AM
• Marostegui closed subtask T253276: Normalise MW Core database language fields length as Resolved.Dec 14 2020, 9:17 AM
RLazarus closed this task as Resolved.Jan 11 2021, 3:55 PM
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