Lucas_Werkmeister_WMDE added a comment.
Coming back to José Barreto for a moment, since that item hasn’t been edited
yet and is still missing the terms: The missing alias («José Alberto Barreto»,
Spanish) is not only missing from the term store as a whole; it’s not even
present in the innermost text table:
MariaDB [wikidatawiki]> SELECT * FROM wbt_text WHERE wbx_text = 'José
Alberto Barreto';
Empty set (0.001 sec)
(And just to confirm that this isn’t an input encoding issue with the é – the
text without the middle name works:)
MariaDB [wikidatawiki]> SELECT * FROM wbt_text WHERE wbx_text = 'José
Barreto';
+----------+---------------+
| wbx_id | wbx_text |
+----------+---------------+
| 18515003 | José Barreto |
+----------+---------------+
1 row in set (0.001 sec)
But there is a trace of this alias in `wbt_term_in_lang` and
`wbt_item_terms`! Success!!
MariaDB [wikidatawiki]> SELECT wbit_item_id, wbit_term_in_lang_id,
wby_name, wbtl_text_in_lang_id, wbxl_id FROM wbt_item_terms LEFT JOIN
wbt_term_in_lang ON wbit_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 wbit_item_id IN
(61827465) AND wbxl_id IS NULL;
+--------------+----------------------+----------+----------------------+---------+
| wbit_item_id | wbit_term_in_lang_id | wby_name | wbtl_text_in_lang_id |
wbxl_id |
+--------------+----------------------+----------+----------------------+---------+
| 61827465 | 951539057 | alias | 946668473 |
NULL |
+--------------+----------------------+----------+----------------------+---------+
1 row in set (0.002 sec)
So we must have some race condition here, where the `wbt_text_in_lang` (and
`wbt_text`) gets cleaned up in parallel to its being used for a new
`wbt_term_in_lang` (and `wbt_item_terms`) row.
TASK DETAIL
https://phabricator.wikimedia.org/T309445
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucas_Werkmeister_WMDE
Cc: Lydia_Pintscher, karapayneWMDE, Addshore, Manuel, Lucas_Werkmeister_WMDE,
Aklapper, Moebeus, Astuthiodit_1, Invadibot, maantietaja, ItamarWMDE,
Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden,
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
