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 +/-
filtered_tables: Drop old categorylinks columnsoperations/puppetproduction+0 -2
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
 ResolvedLadsgroupT300222 Implement normalizing MediaWiki link tables
 ResolvedZabeT299951 Normalize categorylinks table
 ResolvedMarosteguiT384592 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}
 ResolvedMarosteguiT399249 Add cl_timestamp_id index to categorylinks table
 ResolvedMarosteguiT399533 Switchover s6 master (db2214 -> db2229)
 DeclinedMarosteguiT399619 Switchover s6 master (db1201 -> db1173)
 DeclinedMarosteguiT399680 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
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
Reedy mentioned this in T413551: Error with categorylinks table on update from 1.44.2 to 1.45.1.Dec 28 2025, 5:17 PM
Reedy mentioned this in T413670: BlueSpiceFoundation tests failing due to cl_to being dropped.Jan 2 2026, 7:28 PM
hashar subscribed.Jan 14 2026, 10:20 AM

The BlogPage and MediaUploader extensions have not been migrated and fail on CI due to the drop of categorylinks.cl_to.

Ladsgroup added a comment.Jan 14 2026, 10:38 AM
In T299951#11520426, @hashar wrote:

The BlogPage and MediaUploader extensions have not been migrated and fail on CI due to the drop of categorylinks.cl_to.

We don't own nor maintain those extensions, they are not deployed to Wikimedia production and I think it's the responsibility of people behind those extension to fix it not us. If we want to for any change in mw check and fix every single extension in gerrit (and beyond), we can't make any impactful change in our infra.

lcawte subscribed.Jan 14 2026, 11:12 AM
In T299951#11520426, @hashar wrote:

The BlogPage and MediaUploader extensions have not been migrated and fail on CI due to the drop of categorylinks.cl_to.

BlogPage is tracked (T412781) - there's even a master compatible patch, but, it's only merged in the REL1_45 branch for reasons you can see in the master gerrit change.

hashar added a comment.Jan 26 2026, 10:23 AM

MediaUploader has been fixed by https://gerrit.wikimedia.org/r/c/mediawiki/extensions/MediaUploader/+/1221300 (which also addresses deprecation calls made to ParserOutput) 🎉

fnegri unsubscribed.Jan 26 2026, 12:39 PM
TheDJ mentioned this in T416413: CategoryLinksTable migration is broken in 1.45 for postgres due to empty condition.Feb 3 2026, 10:25 PM
gerritbot added a comment.Feb 14 2026, 5:58 PM

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

[operations/puppet@production] filtered_tables: Drop old categorylinks columns

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

gerritbot added a project: Patch-For-Review.Feb 14 2026, 5:58 PM
gerritbot added a comment.Mar 2 2026, 12:53 PM

Change #1239484 merged by Ladsgroup:

[operations/puppet@production] filtered_tables: Drop old categorylinks columns

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

ops-monitoring-bot added a comment.Mar 2 2026, 1:00 PM

Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views

ops-monitoring-bot added a comment.Mar 2 2026, 1:07 PM

Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup executed with errors:

  • an-redacteddb1001.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1017.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1018.eqiad.wmnet (FAIL)
    • Ran Puppet agent
    • The maintain-views run failed, see OUTPUT of 'maintain-views ...' above for details
ops-monitoring-bot added a comment.Mar 2 2026, 1:28 PM

Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views

ops-monitoring-bot added a comment.Mar 2 2026, 1:35 PM

Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup executed with errors:

  • an-redacteddb1001.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1017.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1018.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1019.eqiad.wmnet (FAIL)
    • Ran Puppet agent
    • The maintain-views run failed, see OUTPUT of 'maintain-views ...' above for details
ops-monitoring-bot added a comment.Mar 2 2026, 2:13 PM

Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views

ops-monitoring-bot added a comment.Mar 2 2026, 2:23 PM

Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup executed with errors:

  • an-redacteddb1001.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1017.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1018.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1019.eqiad.wmnet (FAIL)
    • Ran Puppet agent
    • The maintain-views run failed, see OUTPUT of 'maintain-views ...' above for details
ops-monitoring-bot added a comment.Mar 2 2026, 2:26 PM

Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views

ops-monitoring-bot added a comment.Mar 2 2026, 2:31 PM

Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup executed with errors:

  • an-redacteddb1001.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace --auto-depool --all-databases --table categorylinks'
  • clouddb1017.eqiad.wmnet (FAIL)
    • Ran Puppet agent
    • The maintain-views run failed, see OUTPUT of 'maintain-views ...' above for details
Maintenance_bot removed a project: Patch-For-Review.Mar 2 2026, 2:31 PM
Izno added a comment.EditedMar 2 2026, 7:46 PM

In the future, please add "it's finally going away" to tech news at least a week in advance. We already have multiple "what where did it go" on en.wp and I can only assume multiple other wikis were not anticipating an imminent removal.

Zabe added a comment.EditedMar 2 2026, 7:51 PM
In T299951#11665241, @Izno wrote:

In the future, please add "it's finally going away" to tech news at least a week in advance. We already have multiple "what where did it go" on en.wp and I can only assume multiple other wikis were not anticipating an imminent removal.

We sent an announcement to cloud-announce@, but I’m happy to also include it in Tech Weeks for broader visibility in the future.

Zabe mentioned this in T423532: Image Checker throwing 'Unknown column 'cl_to' in 'ON'' error.Wed, Apr 15, 11:02 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