[Labs-l] Enwiki database corruption

Nuria Ruiz nuria at wikimedia.org
Thu Oct 23 01:25:30 UTC 2014


Ping ....

I imagine that people are pretty swamped but ...is anyone working on the
issue with lack of data in labs?

There are several bugs open:

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


https://bugzilla.wikimedia.org/show_bug.cgi?id=71176




On Wed, Oct 22, 2014 at 10:29 AM, Nuria Ruiz <nuria at wikimedia.org> wrote:

> 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/7db69014/attachment.html>


More information about the Labs-l mailing list