Page MenuHomePhabricator
Create Task
Maniphest T299951

Normalize categorylinks table
Closed, ResolvedPublic
Actions

Description

Once T299953: Normalize imagelinks table is done.

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Stop setting CategoryLinksSchemaMigrationStageoperations/mediawiki-configmaster+0 -9
Drop cl_to and cl_collation from categorylinks tablemediawiki/coremaster+351 -74
updater: Proper PRIMARY KEY modificationmediawiki/coremaster+129 -3
Cleanup remainders of categorylinks migrationmediawiki/coremaster+3 -2
Drop categorylinks migration codemediawiki/coremaster+53 -121
Drop support for categorylinks read oldmediawiki/extensions/FlaggedRevsmaster+13 -46
Drop categorylinks read old codemediawiki/coremaster+145 -316
Drop support for categorylinks read oldmediawiki/extensions/intersectionmaster+25 -44
Drop support for categorylinks read oldmediawiki/extensions/Flowmaster+7 -19
Drop support for categorylinks read oldmediawiki/extensions/GoogleNewsSitemapmaster+22 -39
Drop support for categorylinks read oldmediawiki/extensions/Collectionmaster+6 -17
Drop support for categorylinks read oldmediawiki/extensions/GlobalUsagemaster+6 -19
Drop support for categorylinks read oldmediawiki/extensions/CategoryTreemaster+13 -33
Drop support for categorylinks read oldmediawiki/extensions/CategoryTreewmf/1.45.0-wmf.16+13 -33
Only normalize cl_collation oncemediawiki/coremaster+14 -1
Move cl_collation normalization to its own maintenance scriptmediawiki/coremaster+125 -94
Formally drop support for categorylinks read oldmediawiki/coremaster+4 -7
Update categorylinks primary keymediawiki/coremaster+400 -16
Run categorylinks migration for third parties toomediawiki/coremaster+57 -6
Add cl_timestamp_id index to categorylinksmediawiki/coremaster+265 -0
tables-catalog: Temporarily set categorylinks to partially publicoperations/puppetproduction+1 -1
maintain-views: Use linktarget and collation in categorylinks viewoperations/puppetproduction+11 -1
filtered_tables: Add new categorylinks columnsoperations/puppetproduction+2 -0
maintain-views: Update linktarget table filteroperations/puppetproduction+5 -1
Add collation table to production tablesoperations/puppetproduction+7 -0
updateCollation: Add option to only migrate collation normalizationmediawiki/coremaster+70 -0
categorylinks: Add support for write bothmediawiki/coremaster+146 -9
schema: Add cl_target_id and cl_collation_id to categorylinksmediawiki/coremaster+350 -0
Show related patches Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 OpenNoneT300222 Implement normalizing MediaWiki link tables
 ResolvedZabeT299951 Normalize categorylinks table
 Resolved• MarosteguiT384592 Add normalization columns to categorylinks table
 ResolvedLadsgroupT385164 Set categorylinks to write both
 ResolvedLadsgroupT385703 Run the data migration of categorylinks
 ResolvedZabeT385890 Add support for read new for categorylinks migration
 ResolvedamastilovicT397923 Adapt Sqoop for categorylinks schema change
 ResolvedBTullisT403702 Errors from refinery-sqoop-whole-mediawiki.service - September 2025 - re: categorylinks
 ResolvedZabeT397912 Set categorylinks to read new
 ResolvedPRODUCTION ERRORZabeT398380 Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cl_target_id' in 'ON'Function: MediaWiki\Extension\CategoryTree\CategoryTree::renderChildrenQuery: SELECT page_id,page_namespace,page_title,page_is_redirect,page_len,
 ResolvedPRODUCTION ERRORZabeT398823 Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:{query}
 ResolvedPRODUCTION ERRORZabeT398860 Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}
 ResolvedPRODUCTION ERRORZabeT398861 Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:{query}
 ResolvedPRODUCTION ERRORZabeT399037 Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:{query}
 ResolvedPRODUCTION ERRORZabeT399094 Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}
 Resolved• MarosteguiT399249 Add cl_timestamp_id index to categorylinks table
 Resolved• MarosteguiT399533 Switchover s6 master (db2214 -> db2229)
 Declined• MarosteguiT399619 Switchover s6 master (db1201 -> db1173)
 Declined• MarosteguiT399680 Switchover s5 master (db2213 -> db2192)
 ResolvedZabeT399579 Stop writing to cl_to and cl_collation
 ResolvedPRODUCTION ERRORZabeT399641 Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cl_target_id' in 'ON'Function: MediaWiki\Pager\IndexPager::buildQueryInfo (PendingChangesPager)Query: SELECT page_namespace,page_title,page_len,rev_len,page_latest,fp
 ResolvedLadsgroupT402925 Drop cl_to and cl_collation from categorylinks in wmf production
 ResolvedPRODUCTION ERRORZabeT403069 Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
gerritbot added a comment.Jul 8 2025, 9:44 AM

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

[operations/puppet@production] tables-catalog: Temporarily set categorylinks to partially public

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

gerritbot added a project: Patch-For-Review.Jul 8 2025, 9:44 AM
gerritbot added a comment.Jul 8 2025, 9:47 AM

Change #1167159 merged by Ladsgroup:

[operations/puppet@production] tables-catalog: Temporarily set categorylinks to partially public

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

Maintenance_bot removed a project: Patch-For-Review.Jul 8 2025, 10:31 AM
Zabe added a subtask: T399037: Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:{query}.Jul 8 2025, 10:24 PM
gerritbot added a comment.Jul 9 2025, 10:42 AM

Change #1167566 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Add cl_timestamp_id index to categorylinks

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

gerritbot added a project: Patch-For-Review.Jul 9 2025, 10:42 AM
Zabe closed subtask T398861: Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:{query} as Resolved.Jul 9 2025, 2:54 PM
Zabe closed subtask T399037: Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:{query} as Resolved.Jul 9 2025, 3:07 PM
Zabe added a subtask: T399094: Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}.Jul 9 2025, 3:15 PM
gerritbot added a comment.Jul 10 2025, 10:31 PM

Change #1167566 merged by jenkins-bot:

[mediawiki/core@master] Add cl_timestamp_id index to categorylinks

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

Maintenance_bot removed a project: Patch-For-Review.Jul 10 2025, 11:31 PM
gerritbot added a comment.Jul 11 2025, 9:34 PM

Change #1168254 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Run pagelinks migration for third parties too

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

gerritbot added a project: Patch-For-Review.Jul 11 2025, 9:34 PM
gerritbot added a comment.Jul 13 2025, 1:38 PM

Change #1168614 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Update categorylinks primary key

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

gerritbot added a comment.Jul 14 2025, 10:47 PM

Change #1168254 merged by jenkins-bot:

[mediawiki/core@master] Run categorylinks migration for third parties too

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

ReleaseTaggerBot added a project: MW-1.45-notes (1.45.0-wmf.10; 2025-07-15).Jul 14 2025, 11:00 PM
gerritbot added a comment.Jul 15 2025, 11:57 AM

Change #1168614 merged by jenkins-bot:

[mediawiki/core@master] Update categorylinks primary key

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

ReleaseTaggerBot edited projects, added MW-1.45-notes (1.45.0-wmf.11; 2025-07-22); removed MW-1.45-notes (1.45.0-wmf.10; 2025-07-15).Jul 15 2025, 12:00 PM
Zabe added a subtask: T399641: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cl_target_id' in 'ON'Function: MediaWiki\Pager\IndexPager::buildQueryInfo (PendingChangesPager)Query: SELECT page_namespace,page_title,page_len,rev_len,page_latest,fp.Jul 15 2025, 9:44 PM
Zabe closed subtask T399641: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cl_target_id' in 'ON'Function: MediaWiki\Pager\IndexPager::buildQueryInfo (PendingChangesPager)Query: SELECT page_namespace,page_title,page_len,rev_len,page_latest,fp as Resolved.Jul 17 2025, 10:30 PM
Milimetric moved this task from Incoming (new tickets) to Tag with Radar on the Data-Engineering board.Jul 23 2025, 4:30 PM
Milimetric added a project: Data-Engineering-Radar.
Umherirrender mentioned this in T400987: Regression: Category member counts broken in German Wikipedia .Aug 1 2025, 11:57 AM
Tacsipacsi mentioned this in T399458: Move category changes from RecentChanges/Watchlist to separate Special page.Aug 18 2025, 1:48 PM
Zabe closed subtask T397912: Set categorylinks to read new as Resolved.Aug 25 2025, 2:21 PM
Zabe closed subtask T399094: Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query} as Resolved.Aug 25 2025, 2:30 PM
Maintenance_bot removed a project: Patch-For-Review.Aug 25 2025, 2:31 PM
gerritbot added a comment.Aug 26 2025, 12:45 AM

Change #1181812 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Formally drop support for categorylinks read old

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

gerritbot added a project: Patch-For-Review.Aug 26 2025, 12:45 AM
gerritbot added a comment.Aug 26 2025, 11:40 AM

Change #1181812 merged by jenkins-bot:

[mediawiki/core@master] Formally drop support for categorylinks read old

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

ReleaseTaggerBot edited projects, added MW-1.45-notes (1.45.0-wmf.17; 2025-09-02); removed MW-1.45-notes (1.45.0-wmf.11; 2025-07-22).Aug 26 2025, 12:00 PM
gerritbot added a comment.Aug 26 2025, 12:04 PM

Change #1182120 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/intersection@master] Drop support for categorylinks read old

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

gerritbot added a comment.Aug 26 2025, 12:15 PM

Change #1182123 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CategoryTree@master] Drop support for categorylinks read old

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

gerritbot added a comment.Aug 26 2025, 12:18 PM

Change #1182124 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/Collection@master] Drop support for categorylinks read old

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

gerritbot added a comment.Aug 26 2025, 12:24 PM

Change #1182126 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/Flow@master] Drop support for categorylinks read new

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

gerritbot added a comment.Aug 26 2025, 12:28 PM

Change #1182127 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/GlobalUsage@master] Drop support for categorylinks read old

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

Bamyers99 unsubscribed.Aug 26 2025, 12:36 PM
gerritbot added a comment.Aug 26 2025, 1:20 PM

Change #1182141 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/GoogleNewsSitemap@master] Drop support for categorylinks read old

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

gerritbot added a comment.Aug 26 2025, 1:33 PM

Change #1182144 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Drop cl_to and cl_collation from categorylinks table

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

gerritbot added a comment.Aug 26 2025, 2:24 PM

Change #1182155 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Move cl_collation normalization to its own maintenance script

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

gerritbot added a comment.Aug 26 2025, 9:48 PM

Change #1182222 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Drop categorylinks read old code

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

gerritbot added a comment.Aug 26 2025, 11:29 PM

Change #1182238 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Only normalize cl_collation once

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

gerritbot added a comment.Aug 26 2025, 11:37 PM

Change #1182155 abandoned by Zabe:

[mediawiki/core@master] Move cl_collation normalization to its own maintenance script

Reason:

In favor of https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1182238

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

gerritbot added a comment.Aug 27 2025, 12:17 AM

Change #1182238 merged by jenkins-bot:

[mediawiki/core@master] Only normalize cl_collation once

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

Zabe added a subtask: T403069: Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}.Aug 27 2025, 2:34 PM
Zabe closed subtask T403069: Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query} as Resolved.Aug 27 2025, 4:02 PM
xcollazo unsubscribed.Aug 27 2025, 4:28 PM
matmarex mentioned this in T403337: Wikimedia\Rdbms\DBQueryError: Inaccessible page in the Project_talk namespace on jawiki.Aug 31 2025, 8:20 PM
gerritbot added a comment.Aug 31 2025, 8:26 PM

Change #1183269 had a related patch set uploaded (by Ladsgroup; author: Zabe):

[mediawiki/extensions/CategoryTree@wmf/1.45.0-wmf.16] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 1 2025, 11:01 AM

Change #1183269 merged by jenkins-bot:

[mediawiki/extensions/CategoryTree@wmf/1.45.0-wmf.16] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 1 2025, 11:02 AM

Change #1182123 merged by jenkins-bot:

[mediawiki/extensions/CategoryTree@master] Drop support for categorylinks read old

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

Stashbot mentioned this in T365303: Move update of category members count to CategoryMembershipChangeJob.Sep 1 2025, 11:03 AM
Stashbot mentioned this in T403147: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cl_to' in 'ON'Function: MediaWiki\Extension\CategoryTree\CategoryTree::renderChildrenQuery: SELECT page_id,page_namespace,page_title,page_is_redirect,page_len,page_la.

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:03:56Z] <ladsgroup@deploy1003> Started scap sync-world: Backport for [[gerrit:1183632|ParserTestRunner: Update category counts for articles (T365303)]], [[gerrit:1183633|CategoryCacheTest: Update category count]], [[gerrit:1183269|Drop support for categorylinks read old (T299951 T403147 T403337)]]

Stashbot added a comment.Sep 1 2025, 11:09 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:09:48Z] <ladsgroup@deploy1003> ladsgroup: Backport for [[gerrit:1183632|ParserTestRunner: Update category counts for articles (T365303)]], [[gerrit:1183633|CategoryCacheTest: Update category count]], [[gerrit:1183269|Drop support for categorylinks read old (T299951 T403147 T403337)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Sep 1 2025, 11:16 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:16:24Z] <ladsgroup@deploy1003> Finished scap sync-world: Backport for [[gerrit:1183632|ParserTestRunner: Update category counts for articles (T365303)]], [[gerrit:1183633|CategoryCacheTest: Update category count]], [[gerrit:1183269|Drop support for categorylinks read old (T299951 T403147 T403337)]] (duration: 12m 28s)

gerritbot added a comment.Sep 2 2025, 11:16 AM

Change #1182127 merged by jenkins-bot:

[mediawiki/extensions/GlobalUsage@master] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 2 2025, 11:28 AM

Change #1182126 merged by jenkins-bot:

[mediawiki/extensions/Flow@master] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 2 2025, 11:28 AM

Change #1182124 merged by jenkins-bot:

[mediawiki/extensions/Collection@master] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 2 2025, 11:28 AM

Change #1182141 merged by jenkins-bot:

[mediawiki/extensions/GoogleNewsSitemap@master] Drop support for categorylinks read old

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

ReleaseTaggerBot edited projects, added MW-1.45-notes (1.45.0-wmf.18; 2025-09-09); removed MW-1.45-notes (1.45.0-wmf.17; 2025-09-02).Sep 2 2025, 12:01 PM
Ladsgroup closed subtask T399249: Add cl_timestamp_id index to categorylinks table as Resolved.Sep 2 2025, 2:53 PM
Ladsgroup closed subtask T399579: Stop writing to cl_to and cl_collation as Resolved.Sep 2 2025, 6:51 PM
gerritbot added a comment.Sep 3 2025, 9:29 AM

Change #1182120 merged by jenkins-bot:

[mediawiki/extensions/intersection@master] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 4 2025, 11:26 AM

Change #1182222 merged by jenkins-bot:

[mediawiki/core@master] Drop categorylinks read old code

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

hashar mentioned this in T404346: BlueSpiceFoundation CI fails with: Error 1364: Field 'cl_target_id' doesn't have a default value.Sep 11 2025, 1:49 PM
hashar added a subtask: T404346: BlueSpiceFoundation CI fails with: Error 1364: Field 'cl_target_id' doesn't have a default value.Sep 11 2025, 1:53 PM
Ladsgroup removed a subtask: T404346: BlueSpiceFoundation CI fails with: Error 1364: Field 'cl_target_id' doesn't have a default value.Sep 11 2025, 2:10 PM
gerritbot added a comment.Sep 11 2025, 10:36 PM

Change #1187547 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/FlaggedRevs@master] Drop support for categorylinks read old

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

gerritbot added a comment.Sep 12 2025, 10:35 AM

Change #1187547 merged by jenkins-bot:

[mediawiki/extensions/FlaggedRevs@master] Drop support for categorylinks read old

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

ReleaseTaggerBot edited projects, added MW-1.45-notes (1.45.0-wmf.19; 2025-09-16); removed MW-1.45-notes (1.45.0-wmf.18; 2025-09-09).Sep 12 2025, 11:00 AM
gerritbot added a comment.Sep 12 2025, 2:38 PM

Change #1187825 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Drop categorylinks migration code

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

gerritbot added a comment.Sep 16 2025, 12:04 PM

Change #1187825 merged by jenkins-bot:

[mediawiki/core@master] Drop categorylinks migration code

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

ReleaseTaggerBot edited projects, added MW-1.45-notes (1.45.0-wmf.20; 2025-09-23); removed MW-1.45-notes (1.45.0-wmf.19; 2025-09-16).Sep 16 2025, 1:01 PM
Vedmaka mentioned this in rEPPObc7d6fc5e8e5: [PATCH] Fix JSON export, categorylinks migration support.Sep 26 2025, 1:26 PM
Zabe claimed this task.Sep 29 2025, 9:41 PM
Jdforrester-WMF subscribed.Sep 30 2025, 1:41 AM

Is this just T402925 and then done, or is there more?

Jdforrester-WMF mentioned this in T299953: Normalize imagelinks table.Sep 30 2025, 1:42 AM
gerritbot added a comment.Sep 30 2025, 9:14 AM

Change #1192505 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Cleanup remainders of categorylinks migration

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

Zabe added a comment.Sep 30 2025, 9:15 AM
In T299951#11227630, @Jdforrester-WMF wrote:

Is this just T402925 and then done, or is there more?

No, besides getting https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1192505 and https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1182144 merged, this is done.

gerritbot added a comment.Sep 30 2025, 9:44 AM

Change #1192505 merged by jenkins-bot:

[mediawiki/core@master] Cleanup remainders of categorylinks migration

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

ReleaseTaggerBot edited projects, added MW-1.45-notes (1.45.0-wmf.22; 2025-10-07); removed MW-1.45-notes (1.45.0-wmf.20; 2025-09-23).Sep 30 2025, 10:00 AM
Jdforrester-WMF closed this task as Resolved.Sep 30 2025, 10:55 AM
In T299951#11228219, @Zabe wrote:
In T299951#11227630, @Jdforrester-WMF wrote:

Is this just T402925 and then done, or is there more?

No, besides getting https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1192505 and https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1182144 merged, this is done.

Excellent work. Congratulations!

Maintenance_bot moved this task from In progress to Done on the DBA board.Sep 30 2025, 11:29 AM
gerritbot added a comment.Oct 1 2025, 10:53 AM

Change #1192645 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] updater: Proper PRIMARY KEY modification

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

gerritbot added a comment.Oct 1 2025, 10:56 AM

Change #1192867 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop setting CategoryLinksSchemaMigrationStage

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

gerritbot added a comment.Oct 1 2025, 1:44 PM

Change #1192645 merged by jenkins-bot:

[mediawiki/core@master] updater: Proper PRIMARY KEY modification

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

gerritbot added a comment.Oct 1 2025, 2:58 PM

Change #1182144 merged by jenkins-bot:

[mediawiki/core@master] Drop cl_to and cl_collation from categorylinks table

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

Ladsgroup closed subtask T402925: Drop cl_to and cl_collation from categorylinks in wmf production as Resolved.Oct 1 2025, 3:17 PM
Reedy mentioned this in T406142: Error 1091: Can't DROP INDEX `cl_timestamp`; check that it exists.Oct 1 2025, 3:46 PM
gerritbot added a comment.Oct 2 2025, 9:40 PM

Change #1192867 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop setting CategoryLinksSchemaMigrationStage

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

Stashbot added a comment.Oct 2 2025, 9:41 PM

Mentioned in SAL (#wikimedia-operations) [2025-10-02T21:41:03Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1192867|Stop setting CategoryLinksSchemaMigrationStage (T299951)]]

Stashbot added a comment.Oct 2 2025, 9:46 PM

Mentioned in SAL (#wikimedia-operations) [2025-10-02T21:46:54Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1192867|Stop setting CategoryLinksSchemaMigrationStage (T299951)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Oct 2 2025, 9:53 PM

Mentioned in SAL (#wikimedia-operations) [2025-10-02T21:53:40Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1192867|Stop setting CategoryLinksSchemaMigrationStage (T299951)]] (duration: 12m 37s)

Maintenance_bot removed a project: Patch-For-Review.Oct 2 2025, 10:31 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 · Credits