Due date: Monday, September 7th
Description
Details
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Ladsgroup | T343131 Commons database is growing way too fast | |||
| Resolved | Zabe | T398709 FY2025-26 WE 6.4.1: Move links tables of commons to a dedicated cluster | |||
| Resolved | Zabe | T437108 Move production reads for commons link tables to x4 |
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
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
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
Change #1337635 had a related patch set uploaded (by Zabe; author: Zabe):
[operations/mediawiki-config@master] Move globalimagelinks queries to x4
Change #1336829 merged by jenkins-bot:
[operations/mediawiki-config@master] Disable query pages not yet compatible with commons split
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
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
Change #1337650 merged by jenkins-bot:
[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 10% of requests
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
Change #1337655 merged by jenkins-bot:
[operations/mediawiki-config@master] Move production reads for commons link tables to x4 for 25% of requests
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
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
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
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
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)
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-validationChange #1337969 had a related patch set uploaded (by Zabe; author: Zabe):
[operations/mediawiki-config@master] Do not try to use x4 in beta cluster
Change #1337969 merged by jenkins-bot:
[operations/mediawiki-config@master] Do not try to use x4 in beta cluster
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)