| Vvjjkkii renamed this task from "Clean up archive rows with duplicate revision IDs" to "74daaaaaaa". Vvjjkkii reopened this task as "Open". Vvjjkkii raised the priority of this task from "Normal" to "High". Vvjjkkii removed Anomie as the assignee of this task. Vvjjkkii removed subscribers: gerritbot, Aklapper. Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, JADE, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team. Vvjjkkii updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
There 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.26570726f6475636520796f757220627567207573696e67206120726563656e742076657273696f6e206f662074686520736f6674776172652c20746f2068652077696b6920636f6e74656e74206c616e67756167652e0a0a5468616e6b20796f752e0a546167730a436865636b557365720ad70a436f6e6e65637465642d4f70656e2d48657269746167652d42617463682d75706c6f61647320285241c42d4b4d425f315f323031372d3032290ad70a54616d696c2d53697465730ad70a47616d6570726573730ad70a48617368746167730ad70a4a4144450ad70a4b6172746f456469746f720ad70a4c616e67756167652d323031382d4170722d4a756e650ad70a4e65772d456469746f722d457870657269656e6365730ad70a4d61696c0ad70a5443422d5465616d0ad70a53756273637269626572730a4465736372697074696f6e20507265766965770a436f6e74656e77a6f6e652073657474696e6720696e20796f75722070726f66696c652c20636c69636b20746f207265636f6e63696c652e
* 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.26570726f6475636520796f757220627567207573696e67206120726563656e742076657273696f6e206f662074686520736f6674776172652c20746f2068652077696b6920636f6e74656e74206c616e67756167652e0a0a5468616e6b20796f752e0a546167730a436865636b557365720ad70a436f6e6e65637465642d4f70656e2d48657269746167652d42617463682d75706c6f61647320285241c42d4b4d425f315f323031372d3032290ad70a54616d696c2d53697465730ad70a47616d6570726573730ad70a48617368746167730ad70a4a4144450ad70a4b6172746f456469746f720ad70a4c616e67756167652d323031382d4170722d4a756e650ad70a4e65772d456469746f722d457870657269656e6365730ad70a4d61696c0ad70a5443422d5465616d0ad70a53756273637269626572730a4465736372697074696f6e20507265766965770a436f6e74656e77a6f6e652073657474696e6720696e20796f75722070726f66696c652c20636c69636b20746f207265636f6e63696c652e
TASK DETAIL
EMAIL PREFERENCES
To: Vvjjkkii
Cc: greg, Stashbot, CCicalese_WMF, daniel, Addshore, aude, Jdforrester-WMF, Abit, Anomie, AndyTan, Gaboe420, Zylc, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, 1978Gage2001, Lahi, PDrouin-WMF, Gq86, Baloch007, E1presidente, Ramsey-WMF, Cparle, Darkminds3113, SandraF_WMF, Bsandipan, Lordiis, herron, pan199312, GoranSMilovanovic, Adik2382, Chicocvenancio, alanajjar, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tbscho, Tramullas, Acer, LawExplorer, Lea_WMDE, Mattias_Ostmar-WMSE, Lewizho99, JJMC89, Maathavan, Jseddon, Agabi10, Ryuch, Mkdw, RuyP, JEumerus, Trizek-WMF, Susannaanas, KasiaWMDE, 0x010C, srodlund, Luke081515, grin, Bsadowski1, Aschroet, mys_721tx, Fjalapeno, Jane023, Wikidata-bugs, Snowolf, PKM, Base, matthiasmullie, Huji, Gryllida, jayvdb, Ricordisamoa, Tobi_WMDE_SW, Lydia_Pintscher, Fabrice_Florin, Raymond, revi, scfc, He7d3r, Romaine, Steinsplitter, Mbch331, Jay8g, Ltrlg, Glaisher, Krenair, chasemp, gerritbot, Aklapper
Cc: greg, Stashbot, CCicalese_WMF, daniel, Addshore, aude, Jdforrester-WMF, Abit, Anomie, AndyTan, Gaboe420, Zylc, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, 1978Gage2001, Lahi, PDrouin-WMF, Gq86, Baloch007, E1presidente, Ramsey-WMF, Cparle, Darkminds3113, SandraF_WMF, Bsandipan, Lordiis, herron, pan199312, GoranSMilovanovic, Adik2382, Chicocvenancio, alanajjar, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tbscho, Tramullas, Acer, LawExplorer, Lea_WMDE, Mattias_Ostmar-WMSE, Lewizho99, JJMC89, Maathavan, Jseddon, Agabi10, Ryuch, Mkdw, RuyP, JEumerus, Trizek-WMF, Susannaanas, KasiaWMDE, 0x010C, srodlund, Luke081515, grin, Bsadowski1, Aschroet, mys_721tx, Fjalapeno, Jane023, Wikidata-bugs, Snowolf, PKM, Base, matthiasmullie, Huji, Gryllida, jayvdb, Ricordisamoa, Tobi_WMDE_SW, Lydia_Pintscher, Fabrice_Florin, Raymond, revi, scfc, He7d3r, Romaine, Steinsplitter, Mbch331, Jay8g, Ltrlg, Glaisher, Krenair, chasemp, gerritbot, Aklapper
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
