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
