| Vvjjkkii renamed this task from "wikidatawiki.wb_terms missing label and descriptions for some languages" to "h9baaaaaaa". Vvjjkkii reopened this task as "Open". Vvjjkkii triaged this task as "High" priority. Vvjjkkii removed a subscriber: Aklapper. Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, JADE, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team. Vvjjkkii updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
Starting maybe a week or two ago, the `wikidatawiki.wb_terms` table (on replicas and production) does not match what I see on wikidata.org. Example:
```lang=sql
MariaDB [enwiki_p]> SELECT term_type AS term, term_text, term_language FROM wikidatawiki_p.wb_terms WHERE term_entity_id = 4855000 AND term_type IN ('label', 'description');
+-------+---------------------------------+---------------+
| term | term_text | term_language |
+-------+---------------------------------+---------------+
| label | Bangabandhu-1 | en |
| label | Bangabandhu-1 | pt |
| label | বঙ্গবন্ধু-১ | bn |
| label | Bangabandhu | fr |
+-------+---------------------------------+---------------+
4 rows in set (0.03 sec)
```
but https://www.wikidata.org/wiki/Q4855000 shows a label and description for `cz`, `zh`, etc.
Or:
```lang=sql
MariaDB [enwiki_p]> SELECT term_type AS term, term_text, term_language FROM wikidatawiki_p.wb_terms WHERE term_entity_id = 95 AND term_type IN ('label', 'description') AND term_language = 'en';
Empty set (0.01 sec)
```
but https://www.wikidata.org/wiki/Q95 clearly shows a label and description for `en`.
For Q95 at least, this data //was// in the database before, but is now missing.
This is what is causing T19500026570726f6475636520796f757220627567207573696e67206120726563656e742076657273696f6e206f662074686520736f6674776172652c20746f2068652077696b6920636f6e74656e74206c616e67756167652e0a0a5468616e6b20796f752e0a546167730a436865636b557365720ad70a436f6e6e65637465642d4f70656e2d48657269746167652d42617463682d75706c6f61647320285241c42d4b4d425f315f323031372d3032290ad70a54616d696c2d53697465730ad70a47616d6570726573730ad70a48617368746167730ad70a4a4144450ad70a4b6172746f456469746f720ad70a4c616e67756167652d323031382d4170722d4a756e650ad70a4e65772d456469746f722d457870657269656e6365730ad70a4d61696c0ad70a5443422d5465616d0ad70a53756273637269626572730a4465736372697074696f6e20507265766965770a436f6e74656e77a6f6e652073657474696e6720696e20796f75722070726f66696c652c20636c69636b20746f207265636f6e63696c652e
```lang=sql
MariaDB [enwiki_p]> SELECT term_type AS term, term_text, term_language FROM wikidatawiki_p.wb_terms WHERE term_entity_id = 4855000 AND term_type IN ('label', 'description');
+-------+---------------------------------+---------------+
| term | term_text | term_language |
+-------+---------------------------------+---------------+
| label | Bangabandhu-1 | en |
| label | Bangabandhu-1 | pt |
| label | বঙ্গবন্ধু-১ | bn |
| label | Bangabandhu | fr |
+-------+---------------------------------+---------------+
4 rows in set (0.03 sec)
```
but https://www.wikidata.org/wiki/Q4855000 shows a label and description for `cz`, `zh`, etc.
Or:
```lang=sql
MariaDB [enwiki_p]> SELECT term_type AS term, term_text, term_language FROM wikidatawiki_p.wb_terms WHERE term_entity_id = 95 AND term_type IN ('label', 'description') AND term_language = 'en';
Empty set (0.01 sec)
```
but https://www.wikidata.org/wiki/Q95 clearly shows a label and description for `en`.
For Q95 at least, this data //was// in the database before, but is now missing.
This is what is causing T19500026570726f6475636520796f757220627567207573696e67206120726563656e742076657273696f6e206f662074686520736f6674776172652c20746f2068652077696b6920636f6e74656e74206c616e67756167652e0a0a5468616e6b20796f752e0a546167730a436865636b557365720ad70a436f6e6e65637465642d4f70656e2d48657269746167652d42617463682d75706c6f61647320285241c42d4b4d425f315f323031372d3032290ad70a54616d696c2d53697465730ad70a47616d6570726573730ad70a48617368746167730ad70a4a4144450ad70a4b6172746f456469746f720ad70a4c616e67756167652d323031382d4170722d4a756e650ad70a4e65772d456469746f722d457870657269656e6365730ad70a4d61696c0ad70a5443422d5465616d0ad70a53756273637269626572730a4465736372697074696f6e20507265766965770a436f6e74656e77a6f6e652073657474696e6720696e20796f75722070726f66696c652c20636c69636b20746f207265636f6e63696c652e
TASK DETAIL
EMAIL PREFERENCES
To: Vvjjkkii
Cc: Pasleim, Bawolff, Addshore, MusikAnimal, AndyTan, Zylc, 1978Gage2001, Lahi, Gq86, herron, pan199312, GoranSMilovanovic, Chicocvenancio, alanajjar, QZanden, Tbscho, LawExplorer, Lea_WMDE, Mattias_Ostmar-WMSE, JJMC89, Jseddon, Ryuch, Mkdw, RuyP, JEumerus, Trizek-WMF, KasiaWMDE, 0x010C, srodlund, Luke081515, grin, Bsadowski1, mys_721tx, Wikidata-bugs, Snowolf, aude, Huji, Gryllida, jayvdb, Tobi_WMDE_SW, revi, scfc, He7d3r, Romaine, Mbch331, Jay8g, Glaisher, Krenair, chasemp, Aklapper
Cc: Pasleim, Bawolff, Addshore, MusikAnimal, AndyTan, Zylc, 1978Gage2001, Lahi, Gq86, herron, pan199312, GoranSMilovanovic, Chicocvenancio, alanajjar, QZanden, Tbscho, LawExplorer, Lea_WMDE, Mattias_Ostmar-WMSE, JJMC89, Jseddon, Ryuch, Mkdw, RuyP, JEumerus, Trizek-WMF, KasiaWMDE, 0x010C, srodlund, Luke081515, grin, Bsadowski1, mys_721tx, Wikidata-bugs, Snowolf, aude, Huji, Gryllida, jayvdb, Tobi_WMDE_SW, revi, scfc, He7d3r, Romaine, Mbch331, Jay8g, Glaisher, Krenair, chasemp, Aklapper
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
