Addshore added a comment.

    mysql:[email protected] [wikidatawiki]> SELECT   * 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 JO IN 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;
    
+---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+---------+---------------+--------------+--------+----------+
    | 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 |
    
+---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+---------+---------------+--------------+--------+----------+
    |  332730 |             7850 |            411848038 | 411848038 |           
 3 |            407983555 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332732 |             7786 |            411848054 | 411848054 |           
 3 |            406931806 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332734 |             7884 |            411848132 | 411848132 |           
 3 |            409421152 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332736 |             7885 |            411848158 | 411848158 |           
 3 |            409421166 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332926 |              932 |            412045499 | 412045499 |           
 3 |                88258 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332933 |              846 |            412045592 | 412045592 |           
 3 |                82909 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332935 |             2326 |            412045606 | 412045606 |           
 3 |               168274 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  332937 |              590 |            412045617 | 412045617 |           
 3 |                63613 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  334566 |             6656 |            412937757 | 412937757 |           
 3 |               279086 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  334720 |             1440 |            413008330 | 413008330 |           
 3 |               123055 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  334722 |             1665 |            413010089 | 413010089 |           
 3 |               135377 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  334883 |             3417 |            413099852 | 413099852 |           
 3 |               212096 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  335048 |             4474 |            413348559 | 413348559 |           
 3 |               240023 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  335149 |             1017 |            413511952 | 413511952 |           
 3 |            411294102 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    |  335196 |             6365 |            413582295 | 413582295 |           
 3 |               274837 |      3 | alias    |    NULL | NULL          |       
  NULL |   NULL | NULL     |
    
+---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+---------+---------------+--------------+--------+----------+
    15 rows in set (19.96 sec)
  
  Properties have a couple more holes, but it looks like the exact same race 
condition that should be fixed with the split transactions, which is 
essentially acceptable as it is for now anyway.

TASK DETAIL
  https://phabricator.wikimedia.org/T244115

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, Addshore
Cc: Lucas_Werkmeister_WMDE, Tarrow, Ladsgroup, Addshore, Aklapper, Beast1978, 
Un1tY, Hook696, Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, Iflorez, 
darthmon_wmde, alaa_wmde, Meekrab2012, joker88john, CucyNoiD, Nandana, 
NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, 
Cpaulf30, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, 
GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, 
LawExplorer, WSH1906, Lewizho99, Maathavan, _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

Reply via email to