[Labs-l] Enwiki database corruption

Russell Blau russblau at imapmail.org
Mon Oct 20 19:36:45 UTC 2014


The enwiki_p database replica on labsdb seems to be out of synch with
the master. This is manifesting itself on many articles; here is just
one example.

tools.russbot at tools-login:~$ mysql -A -h enwiki.labsdb enwiki_p

MariaDB [enwiki_p]> select cl_to from categorylinks, page where page_id
= cl_from and page_namespace=0 and page_title = "Little_fingers";

+----------------------------------+
| cl_to                            |
+----------------------------------+
| All_article_disambiguation_pages |
| All_disambiguation_pages         |
| Disambiguation_pages             |
| Monitored_short_pages            |
+----------------------------------+
4 rows in set (0.49 sec)

The api equivalent of this database query is
https://en.wikipedia.org/w/api.php?format=jsonfm&action=query&prop=categories&titles=Little%20fingers,
which shows that the page contains _zero_ category links.

--
Russell Blau
russblau at imapmail.org



More information about the Labs-l mailing list