Addshore added a comment.
Looking at https://www.wikidata.org/wiki/Property:P642 The current NL label is "van" And this is one of the terms that is missing: | wbpt_id | wbpt_property_id | wbpt_term_in_lang_id | wbtl_id | wbtl_type_id | wbtl_text_in_lang_id | wby_id | wby_name | wbxl_id | wbxl_language | wbxl_text_id | wbx_id | wbx_text | | 320487 | 642 | 361461407 | 361461407 | 1 | 359474163 | 1 | label | 359474163 | nl | 110010309 | NULL | NULL | various edits recently happened https://www.wikidata.org/w/index.php?title=Property:P642&action=history The text "van" does exist in the text table, and is used by 49 different descriptions. But with wbx_id = 121798608, compared to 110010309 that `P642` is trying to refer to. Confirming this row does not exist currently in the text table: mysql:[email protected] [wikidatawiki]> select * from wbt_text where wbx_id = 110010309; Empty set (0.00 sec) But it is referred to: mysql:[email protected] [wikidatawiki]> select * from wbt_text_in_lang where wbxl_text_id = 110010309; +-----------+---------------+--------------+ | wbxl_id | wbxl_language | wbxl_text_id | +-----------+---------------+--------------+ | 359474163 | nl | 110010309 | +-----------+---------------+--------------+ 1 row in set (0.00 sec) After speaking to the #dba <https://phabricator.wikimedia.org/tag/dba/> team, we might be able to figure out when this row was removed from the wbt_text table and thus find the set of queries that happened in the transaction that lead to the decision.. - Wiki: wikidatawiki - Method: DatabaseTermIdsCleaner::cleanTextIds - Table: wbt_text - wbx_id = 110010309 TASK DETAIL https://phabricator.wikimedia.org/T237984 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: abian, JAnD, Ash_Crow, Addshore, PKM, Moebeus, alaa_wmde, VIGNERON, Aklapper, Lydia_Pintscher, Ladsgroup, Lea_Lacroix_WMDE, Iflorez, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
