[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Addshore closed this task as "Resolved". Addshore claimed this task. Addshore added a comment. Restricted Application added a project: User-Addshore. SAL logs are connected to T270249 I checked in the DB and the list of issues looked empty :) TA

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE closed subtask T270249: Run maintenance script to remove deleted items from term store on production as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Lucas_Wer

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE closed subtask T274890: Make RemoveDeletedItemsFromTermStore.php maintenance script remove wbt_item_terms rows as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE closed subtask T270247: Write maintenance script for removing deleted items from the term store as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Lucas_Werkmeis

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lydia_Pintscher moved this task from Prioritized Tech (prioritised from top to bottom) to Wikidata-Campsite-Iteration-∞ on the Wikidata-Campsite board. Lydia_Pintscher edited projects, added Wikidata-Campsite (Wikidata-Campsite-Iteration-∞); removed Wikidata-Campsite. TASK DETAIL https://phabr

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

noarave set the point value for this task to "8". TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: noarave Cc: MisterSynergy, Addshore, Aklapper, Lucas_Werkmeister_WMDE, Akuckartz, Nandana, lucamau

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE added a comment. This probably requires a maintenance script to ensure we clean up not just `wbt_term_in_lang`, but also `wbt_text_in_lang` and `wbt_text`. The maintenance script shouldn’t need to do much more than call `TermStoreCleaner::cleanTermInLangIds()`, after c

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Addshore added a comment. So comparing the 2 queries here, in T263730#6490963 and also in P12791 it seems that T263730#6490963 contains more items that we potentially want to cleanup.

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

WMDE-leszek updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: WMDE-leszek Cc: MisterSynergy, Addshore, Aklapper, Lucas_Werkmeister_WMDE, Akuckartz, Nandana, lucamauri,

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Addshore added a project: Wikidata-Campsite. TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: MisterSynergy, Addshore, Aklapper, Lucas_Werkmeister_WMDE, Akuckartz, Nandana, lucamauri,

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE added a comment. (For the record, I also created a list of potentially affected items at P12791, but figured maybe it shouldn’t be public.) TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emai

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

MisterSynergy added a comment. In T263730#6490727 , @Lucas_Werkmeister_WMDE wrote: > In other words, potentially affected is any item that was edited on 10 September between 11:06 and 15:58 (UTC) and then deleted before 7 October 13:27,

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE added a comment. I think this is because we were writing to the new term store at some point when the item was edited, but not when the item was deleted. Timeline: 10 September 2019, 11:06: In T225055#5478485 ,

[Wikidata-bugs] [Maniphest] T263730: Wikidata term store contains rows for deleted items

Lucas_Werkmeister_WMDE created this task. Lucas_Werkmeister_WMDE added projects: Wikidata, MediaWiki-extensions-WikibaseRepository. Restricted Application added a subscriber: Aklapper. TASK DESCRIPTION As a Wikidata editor, I want to create and edit items without getting conflict reports for p