[Wikidata-bugs] [Maniphest] [Commented On] T208695: Duplicate key on several s8 replicas breaking replication
Anomie added a comment. Q123507, specifically this revision. What happened is that one row in the revision_comment_temp table was missing on the master (db1071, I believe) but was present on several replicas. And apparently it was only the one row.TASK DETAILhttps://phabricator.wikimedia.org/T208695EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: AnomieCc: jijiki, Anomie, Addshore, Banyek, Aklapper, jcrespo, Nandana, AndyTan, Imarlier, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Wong128hk, Luke081515, Wikidata-bugs, aude, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, Krenair, akosiaris, greg___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T208695: Duplicate key on several s8 replicas breaking replication
Addshore added a comment. What is the page in question?TASK DETAILhttps://phabricator.wikimedia.org/T208695EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: AddshoreCc: jijiki, Anomie, Addshore, Banyek, Aklapper, jcrespo, Nandana, AndyTan, Imarlier, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Wong128hk, Luke081515, Wikidata-bugs, aude, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, Krenair, greg___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T208695: Duplicate key on several s8 replicas breaking replication
Anomie added a comment. In T208695#4722100, @jcrespo wrote: Could an interaction with archive create issues- eg. the undeletion of a revision so it gets moved from archive to revision and archive is know to been unreliable in the past? The page in question has no entries in the logging table, if it were deleted and undeleted I'd expect to see corresponding entries there. Although it could be something weird from Wikibase, but still why only the one row and not any others before or after?TASK DETAILhttps://phabricator.wikimedia.org/T208695EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: AnomieCc: jijiki, Anomie, Addshore, Banyek, Aklapper, jcrespo, Nandana, AndyTan, Imarlier, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Wong128hk, Luke081515, Wikidata-bugs, aude, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, Krenair, greg___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T208695: Duplicate key on several s8 replicas breaking replication
jcrespo added a comment. it got missed somehow How can that be?, the table was empty or clean at that time according to my notes-and this was verified by 2 people independently (Manuel and me) on 2 different servers as I have on my notes on the 16 oct, and later at T206743#4691048 , unless I am making a huge mistake or missing something. And even if it wasn't and somehow 2 people independently skipped it- the different edits added more than 1 comment, but apparently was 1 row was different? Could an interaction with archive create issues- eg. the undeletion of a revision so it gets moved from archive to revision and archive is know to been unreliable in the past?TASK DETAILhttps://phabricator.wikimedia.org/T208695EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: jcrespoCc: jijiki, Anomie, Addshore, Banyek, Aklapper, jcrespo, Nandana, AndyTan, Imarlier, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Wong128hk, Luke081515, Wikidata-bugs, aude, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, Krenair, greg___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T208695: Duplicate key on several s8 replicas breaking replication
Banyek added a comment. the comparison says there are no differencesTASK DETAILhttps://phabricator.wikimedia.org/T208695EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BanyekCc: Addshore, Banyek, Aklapper, jcrespo, Nandana, AndyTan, Imarlier, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Wong128hk, Luke081515, Wikidata-bugs, aude, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, Krenair, greg___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
