[Wikidata-bugs] [Maniphest] [Commented On] T181486: Wikidata database corruption?

[Magnus]

Magnus added a comment.

@jcrespo OK, but that only means the rows were missing since the last edit, presumably, on 5 August 2017‎.

And it doesn't look like it's a one-off; none of these examples have any labels/aliases/descriptions:

MariaDB [wikidatawiki_p]> select page_title from page_props,page WHERE page_id=pp_page AND page_namespace=0 AND pp_propname='wb-sitelinks' AND pp_value>=5 AND NOT EXISTS (SELECT * FROM wb_terms WHERE term_full_entity_id=page_title) limit 50;
+------------+
| page_title |
+------------+
| Q832       |
| Q1153      |
| Q2250      |
| Q2638      |
| Q2806      |
| Q2869      |
| Q3074      |
| Q3088      |
| Q3293      |
| Q3315      |
| Q3316      |
| Q3467      |
| Q3488      |
| Q3706      |
| Q3975      |
| Q4046      |
| Q4163      |
| Q4170      |
| Q4173      |
| Q4268      |
| Q4286      |
| Q4309      |
| Q4312      |
| Q4324      |
| Q4326      |
| Q4385      |
| Q4693      |
| Q4772      |
| Q4811      |
| Q4825      |
| Q4831      |
| Q4874      |
| Q4879      |
| Q4885      |
| Q4938      |
| Q4939      |
| Q5234      |
| Q5241      |
| Q5247      |
| Q6127      |
| Q6450      |
| Q7448      |
| Q7796      |
| Q7845      |
| Q8145      |
| Q8154      |
| Q8169      |
| Q8292      |
| Q8744      |
| Q8829      |
+------------+
50 rows in set (29.47 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T181486

EMAIL PREFERENCES

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

To: Magnus
Cc: Marostegui, Ladsgroup, jcrespo, Aklapper, Magnus, Lahi, Gq86, GoranSMilovanovic, QZanden, Wikidata-bugs, aude, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs