Addshore added a comment.
The jobs can be seen running @ https://grafana.wikimedia.org/d/000000400/jobqueue-eventbus?orgId=1&from=now-3h&to=now&var-site=eqiad&var-type=CleanTermsIfUnused F31662183: image.png <https://phabricator.wikimedia.org/F31662183> In order to see if we hit this race condition less I'll rebuild the properties one more time... State before rebuild: mysql:[email protected] [wikidatawiki]> SELECT wbpt_property_id as id, wby_name as type, wbxl_language as language, wbx_text as text FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbx_text IS NULL; +------+-------+----------+------+ | id | type | language | text | +------+-------+----------+------+ | 7850 | alias | NULL | NULL | | 7786 | alias | NULL | NULL | | 7884 | alias | NULL | NULL | | 7885 | alias | NULL | NULL | | 590 | alias | NULL | NULL | | 1440 | alias | NULL | NULL | | 1665 | alias | NULL | NULL | | 3417 | alias | NULL | NULL | | 4474 | alias | NULL | NULL | | 6365 | alias | NULL | NULL | | 2033 | alias | NULL | NULL | | 667 | alias | NULL | NULL | | 477 | alias | NULL | NULL | | 1755 | alias | NULL | NULL | | 190 | alias | NULL | NULL | | 3916 | alias | NULL | NULL | | 508 | alias | NULL | NULL | | 2427 | alias | NULL | NULL | | 1225 | alias | NULL | NULL | | 4223 | alias | NULL | NULL | +------+-------+----------+------+ 20 rows in set (5.93 sec) State after: mysql:[email protected] [wikidatawiki]> SELECT wbpt_property_id as id, wby_name as type, wbxl_language as language, wbx_text as text FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbx_text IS NULL; Empty set (1.09 sec) Now to see if and how many of these holes re appear. TASK DETAIL https://phabricator.wikimedia.org/T244115 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Tarrow, Addshore Cc: Lucas_Werkmeister_WMDE, Tarrow, Ladsgroup, Addshore, Aklapper, Hazizibinmahdi, 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
