| AntiCompositeNumber renamed this task from "74daaaaaaa" to "Clean up archive rows with duplicate revision IDs". AntiCompositeNumber closed this task as "Resolved". AntiCompositeNumber lowered the priority of this task from "High" to "Normal". AntiCompositeNumber assigned this task to Anomie. AntiCompositeNumber added subscribers: gerritbot, Aklapper. AntiCompositeNumber removed projects: TCB-Team, Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, JADE, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser. AntiCompositeNumber updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
26570726f6475636520796f757220627567207573696e67206120726563656e742076657273696f6e206f662074686520736f6674776172652c20746f2068652077696b6920636f6e74656e74206c616e67756167652e0a0a5468616e6b20796f752e0a546167730a436865636b557365720ad70a436f6e6e65637465642d4f70656e2d48657269746167652d42617463682d75706c6f61647320285241c42d4b4d425f315f323031372d3032290ad70a54616d696c2d53697465730ad70a47616d6570726573730ad70a48617368746167730ad70a4a4144450ad70a4b6172746f456469746f720ad70a4c616e67756167652d323031382d4170722d4a756e650ad70a4e65772d456469746f722d457870657269656e6365730ad70a4d61696c0ad70a5443422d5465616d0ad70a53756273637269626572730a4465736372697074696f6e20507265766965770a436f6e74656e77a6f6e652073657474696e6720696e20796f75722070726f66696c652c20636c69636b20746f207265636f6e63696c652eThere are, broadly, four classes of "duplicates" that may exist and need cleaning up:
* Cases where both a `revision` and an `archive` row exist for the same change.
* Cases where an `archive` row exists with the same revision ID as some other change in `revision`.
* Cases where multiple `archive` rows exist for the same change.
* Cases where multiple `archive` rows use the same revision ID for different changes.
We can probably define "same change" based on the title, sha1, timestamp, and user.
Fixing this should be reasonably straightforward: find the duplicates, classify them, delete the `archive` rows for the two "same change" cases, and assign new revision IDs (as in T182678) for the "different change" cases.
* Cases where both a `revision` and an `archive` row exist for the same change.
* Cases where an `archive` row exists with the same revision ID as some other change in `revision`.
* Cases where multiple `archive` rows exist for the same change.
* Cases where multiple `archive` rows use the same revision ID for different changes.
We can probably define "same change" based on the title, sha1, timestamp, and user.
Fixing this should be reasonably straightforward: find the duplicates, classify them, delete the `archive` rows for the two "same change" cases, and assign new revision IDs (as in T182678) for the "different change" cases.
TASK DETAIL
EMAIL PREFERENCES
To: Anomie, AntiCompositeNumber
Cc: Aklapper, gerritbot, greg, Stashbot, CCicalese_WMF, daniel, Addshore, aude, Jdforrester-WMF, Abit, Anomie, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, PDrouin-WMF, Gq86, Baloch007, E1presidente, Ramsey-WMF, Cparle, Darkminds3113, SandraF_WMF, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tramullas, Acer, LawExplorer, Lewizho99, JJMC89, Maathavan, Agabi10, Susannaanas, Aschroet, Fjalapeno, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, Ricordisamoa, Lydia_Pintscher, Fabrice_Florin, Raymond, Steinsplitter, Mbch331, Ltrlg, AndyTan, Zylc, 1978Gage2001, herron, pan199312, Chicocvenancio, alanajjar, Tbscho, Lea_WMDE, Mattias_Ostmar-WMSE, Jseddon, Ryuch, Mkdw, RuyP, JEumerus, Trizek-WMF, KasiaWMDE, 0x010C, srodlund, Luke081515, grin, Bsadowski1, mys_721tx, Snowolf, Huji, Gryllida, jayvdb, Tobi_WMDE_SW, revi, scfc, He7d3r, Romaine, Jay8g, Glaisher, Krenair, chasemp
Cc: Aklapper, gerritbot, greg, Stashbot, CCicalese_WMF, daniel, Addshore, aude, Jdforrester-WMF, Abit, Anomie, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, PDrouin-WMF, Gq86, Baloch007, E1presidente, Ramsey-WMF, Cparle, Darkminds3113, SandraF_WMF, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tramullas, Acer, LawExplorer, Lewizho99, JJMC89, Maathavan, Agabi10, Susannaanas, Aschroet, Fjalapeno, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, Ricordisamoa, Lydia_Pintscher, Fabrice_Florin, Raymond, Steinsplitter, Mbch331, Ltrlg, AndyTan, Zylc, 1978Gage2001, herron, pan199312, Chicocvenancio, alanajjar, Tbscho, Lea_WMDE, Mattias_Ostmar-WMSE, Jseddon, Ryuch, Mkdw, RuyP, JEumerus, Trizek-WMF, KasiaWMDE, 0x010C, srodlund, Luke081515, grin, Bsadowski1, mys_721tx, Snowolf, Huji, Gryllida, jayvdb, Tobi_WMDE_SW, revi, scfc, He7d3r, Romaine, Jay8g, Glaisher, Krenair, chasemp
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
