Page MenuHomePhabricator

Move production reads for commons link tables to x4
Closed, ResolvedPublic

Description

Due date: Monday, September 7th

Event Timeline

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

[operations/mediawiki-config@master] Move production reads for commons link tables to x4

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

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

[operations/mediawiki-config@master] Disable query pages not yet compatible with commons split

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

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

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for all of requests

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

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

[operations/mediawiki-config@master] Move globalimagelinks queries to x4

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

Change #1336829 merged by jenkins-bot:

[operations/mediawiki-config@master] Disable query pages not yet compatible with commons split

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T15:51:11Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1336829|Disable query pages not yet compatible with commons split (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T15:55:13Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1336829|Disable query pages not yet compatible with commons split (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T16:01:33Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1336829|Disable query pages not yet compatible with commons split (T437108)]] (duration: 10m 22s)

Change #1336120 merged by jenkins-bot:

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 1% of requests

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T19:19:37Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1336120|Move production reads for commons link tables to x4 for 1% of requests (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T19:23:54Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1336120|Move production reads for commons link tables to x4 for 1% of requests (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T19:31:17Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1336120|Move production reads for commons link tables to x4 for 1% of requests (T437108)]] (duration: 11m 40s)

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

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 10% of requests

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

Change #1337650 merged by jenkins-bot:

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 10% of requests

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T19:48:16Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1337650|Move production reads for commons link tables to x4 for 10% of requests (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T19:52:26Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1337650|Move production reads for commons link tables to x4 for 10% of requests (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T19:59:43Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1337650|Move production reads for commons link tables to x4 for 10% of requests (T437108)]] (duration: 11m 27s)

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

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 25% of requests

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

Change #1337655 merged by jenkins-bot:

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 25% of requests

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T20:14:18Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1337655|Move production reads for commons link tables to x4 for 25% of requests (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T20:18:35Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1337655|Move production reads for commons link tables to x4 for 25% of requests (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T20:23:46Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1337655|Move production reads for commons link tables to x4 for 25% of requests (T437108)]] (duration: 09m 28s)

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

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 50% of requests

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T20:38:05Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Set weight of db1261 to zero in s4 (T437108)', diff saved to https://phabricator.wikimedia.org/P96385 and previous config saved to /var/cache/conftool/dbconfig/20260907-203804-ladsgroup.json

Change #1337656 merged by jenkins-bot:

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 50% of requests

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T20:52:35Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:rESCR1337656381c0|Move production reads for commons link tables to x4 for 50% of requests (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T20:57:05Z] <zabe@deploy1003> zabe: Backport for [[gerrit:rESCR1337656381c0|Move production reads for commons link tables to x4 for 50% of requests (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:03:03Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:rESCR1337656381c0|Move production reads for commons link tables to x4 for 50% of requests (T437108)]] (duration: 10m 27s)

Change #1337319 merged by jenkins-bot:

[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for all requests

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:28:07Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1337319|Move production reads for commons link tables to x4 for all requests (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:32:28Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1337319|Move production reads for commons link tables to x4 for all requests (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:37:41Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1337319|Move production reads for commons link tables to x4 for all requests (T437108)]] (duration: 09m 34s)

Change #1337635 merged by jenkins-bot:

[operations/mediawiki-config@master] Move globalimagelinks queries to x4

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

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:40:58Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1337635|Move globalimagelinks queries to x4 (T437108)]]

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:45:07Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1337635|Move globalimagelinks queries to x4 (T437108)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-09-07T21:51:58Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1337635|Move globalimagelinks queries to x4 (T437108)]] (duration: 11m 00s)

Zabe removed a project: Patch-For-Review.
Zabe moved this task from Triage to Done on the DBA board.

Since https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/1337635 was merged, wmf-beta-update-all has been failing with:

[21:54:37] aawiki | InvalidArgumentException from line 238 of /srv/mediawiki-staging/php-master/includes/libs/Rdbms/LBFactory/LBFactoryMulti.php: Unknown cluster 'extension4'
[21:54:37] aawiki | #0 /srv/mediawiki-staging/php-master/includes/libs/Rdbms/LBFactory/LBFactoryMulti.php(255): Wikimedia\Rdbms\LBFactoryMulti->newExternalLB('extension4')
[21:54:37] aawiki | #1 /srv/mediawiki-staging/php-master/includes/libs/Rdbms/LBFactory/LBFactory.php(576): Wikimedia\Rdbms\LBFactoryMulti->getExternalLB('extension4')
[21:54:37] aawiki | #2 /srv/mediawiki-staging/php-master/includes/libs/Rdbms/LBFactory/LBFactory.php(597): Wikimedia\Rdbms\LBFactory->getLoadBalancer('virtual-globalu...')
[21:54:37] aawiki | #3 /srv/mediawiki-staging/php-master/includes/libs/Rdbms/LBFactory/LBFactory.php(551): Wikimedia\Rdbms\LBFactory->getMappedDatabase(-2, Array, 'virtual-globalu...')
[21:54:37] aawiki | #4 /srv/mediawiki-staging/php-master/includes/Installer/DatabaseUpdater.php(575): Wikimedia\Rdbms\LBFactory->getPrimaryDatabase('virtual-globalu...')
[21:54:37] aawiki | #5 /srv/mediawiki-staging/php-master/includes/Installer/DatabaseUpdater.php(544): MediaWiki\Installer\DatabaseUpdater->runUpdates(Array, true, true)
[21:54:37] aawiki | #6 /srv/mediawiki-staging/php-master/maintenance/update.php(192): MediaWiki\Installer\DatabaseUpdater->doUpdates(Array)
[21:54:37] aawiki | #7 /srv/mediawiki-staging/php-master/maintenance/includes/MaintenanceRunner.php(695): UpdateMediaWiki->execute()
[21:54:37] aawiki | #8 /srv/mediawiki-staging/php-master/maintenance/run.php(54): MediaWiki\Maintenance\MaintenanceRunner->run()
[21:54:37] aawiki | #9 /srv/mediawiki-staging/multiversion/MWScript.php(219): require_once('/srv/mediawiki-...')
[21:54:37] aawiki | #10 {main}
[21:54:37] Command failed (exit 1): /usr/local/bin/mwscript update.php --wiki=aawiki --doshared --quick --skip-config-validation
dancy triaged this task as High priority.

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

[operations/mediawiki-config@master] Do not try to use x4 in beta cluster

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

Change #1337969 merged by jenkins-bot:

[operations/mediawiki-config@master] Do not try to use x4 in beta cluster

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

There was a complaint in discord about disabling of Special:WantedCategories because of this. I was a bit confused as to why it was disabled, as it seems like all the tables in question are all on x4 (page, linktarget, categorylinks)