This broke replication to five hosts today.
Description
Description
Details
Details
Related Changes in Gerrit:
Customize query in gerrit
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Ladsgroup | T300222 Implement normalizing MediaWiki link tables | |||
| Resolved | simon04 | T365497 bldrwnsch update is broken – Unknown column 'pagelinks.pl_title' | |||
| Resolved | Ladsgroup | T299947 Normalize pagelinks table | |||
| Resolved | Ladsgroup | T352010 Gradually drop old pagelinks columns | |||
| Resolved | Umherirrender | T364546 namespaceDupes is not respecting links migration stage (again) |
Event Timeline
Comment Actions
Just for the record, the fix was:
- Re-add the columns:
set session sql_log_bin=0; alter table pagelinks add column `pl_title` varbinary(255) NOT NULL DEFAULT '', add column `pl_namespace` int(11) NOT NULL DEFAULT 0;
- Restart replication
Comment Actions
Change #1029576 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@master] Disable namespaceDupes again
Comment Actions
Change #1029547 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.43.0-wmf.4] Disable namespaceDupes again
Comment Actions
Change #1029548 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.43.0-wmf.3] Disable namespaceDupes again
Comment Actions
Change #1029547 merged by jenkins-bot:
[mediawiki/core@wmf/1.43.0-wmf.4] Disable namespaceDupes again
Comment Actions
Change #1029576 merged by jenkins-bot:
[mediawiki/core@master] Disable namespaceDupes again
Comment Actions
Change #1029548 merged by jenkins-bot:
[mediawiki/core@wmf/1.43.0-wmf.3] Disable namespaceDupes again
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2024-05-09T14:52:10Z] <ladsgroup@deploy1002> Started scap: Backport for [[gerrit:1029547|Disable namespaceDupes again (T364546)]], [[gerrit:1029548|Disable namespaceDupes again (T364546)]]
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2024-05-09T14:54:49Z] <ladsgroup@deploy1002> ladsgroup: Backport for [[gerrit:1029547|Disable namespaceDupes again (T364546)]], [[gerrit:1029548|Disable namespaceDupes again (T364546)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/Mwdebug)
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2024-05-09T15:08:12Z] <ladsgroup@deploy1002> Finished scap: Backport for [[gerrit:1029547|Disable namespaceDupes again (T364546)]], [[gerrit:1029548|Disable namespaceDupes again (T364546)]] (duration: 16m 02s)
Comment Actions
FWIW, the query is this:
UPDATE /* NamespaceDupes::movePage */ `pagelinks` SET pl_from_namespace = 4 WHERE ((pl_from = 13779 AND (pl_namespace = 0 AND pl_title IN ('Qhichwa_simi','Wikipidiya:Qulluy'...Comment Actions
At least we know it's not going to break replication again but someone needs to fix the underlying problem. I might get to it eventually but no cookie licking so if someone else is willing to, sure.
Comment Actions
Change #1032022 had a related patch set uploaded (by Umherirrender; author: Umherirrender):
[mediawiki/core@master] maintenance: Check PageLinksSchemaMigrationStage in namespaceDupes.php
Comment Actions
Change #1032022 merged by jenkins-bot:
[mediawiki/core@master] maintenance: Check PageLinksSchemaMigrationStage in namespaceDupes.php