Addshore added a comment.
Decoding what happens in the transactions... For edits: https://www.wikidata.org/w/index.php?diff=1108479589&oldid=1103620837&title=Property:P356 https://www.wikidata.org/w/index.php?diff=1108479601&oldid=1108479589&title=Property:P356 TRANSACTION 1 (as expected) --------------------------- INSERT term_in_lang row for (label sr DOI), using pre existing text_in_lang INSERT wbt_property_terms for term_in_lang (label sr DOI) DELETE wbt_property_terms for (label sr ДОИ) cleanTermInLangIds DELETE remove term_in_lang for (label sr ДОИ) 40383 cleanTermInLangIds DELETE remove text_in_lang for (sr ДОИ) 40159 <<<<<<<<< cleanTextIds DELETE remove (ДОИ) 32573 TRANSACTION 2 ------------- INSERT IGNORE into text table (ДОИ идентификатор) new text entry (doesnt matter) INSERT IGNORE 2x into text_in_lang .... INSERT IGNORE 3x into term_in_lang for the 3 things being added as an alias - One of these is text_in_lang id 40159 (removed by above transaction) <<<<<<<<< INSERT wbt_property_terms for term_in_lang x3 DELETE wbt_property_terms for x1 (not used removed) No clean up, and no restoration <<<<<<<<< Cleanup would select the term in lang ids that are inserted in this transaction (412045689, 412045690, 412045691) That means that nothing will be re inserted. text_in_lang tables and ids are never checked or attempted to be reinserted in this case. TASK DETAIL https://phabricator.wikimedia.org/T244115 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Tarrow, Ladsgroup, Addshore, Aklapper, Iflorez, darthmon_wmde, alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
