[Labs-l] Enwiki database corruption

[John]

See also https://bugzilla.wikimedia.org/show_bug.cgi?id=72226

On Mon, Oct 20, 2014 at 3:36 PM, Russell Blau <russblau at imapmail.org> wrote:

> 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
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20141020/0519eef3/attachment-0001.html>