[Labs-l] Enwiki database corruption
Nuria Ruiz
nuria at wikimedia.org
Wed Oct 22 17:29:51 UTC 2014
Is thee an update on this regard? Is enwiki back up in labs?
On Mon, Oct 20, 2014 at 12: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/20141022/f9b6f587/attachment.html>
More information about the Labs-l
mailing list