[Labs-l] tewiki_p replication broken

[Arjuna Rao Chavala]

Hi,

Thanks to help by anomie on #wikimedia-labs IRC, I traced the problem to
missing underscores in page titles in place of blanks in the original
titles.

Cheers
Arjuna



On Fri, Jan 24, 2014 at 3:07 PM, Arjuna Rao Chavala <arjunaraoc at gmail.com>wrote:

> Hi Merlijn,
>
>
> On Fri, Jan 24, 2014 at 3:00 PM, Merlijn van Deen <valhallasw at arctus.nl>wrote:
>
>> On 24 January 2014 10:21, Arjuna Rao Chavala <arjunaraoc at gmail.com>wrote:
>>
>>> While doing few database queries, I noticed that the data does not cover
>>> the recent edits.
>>>
>>
>> It does cover them. The correct way to check for replag is checking for
>> the latest change:
>> MariaDB [tewiki_p]> select rev_timestamp from revision order by rev_id
>> desc limit 1;
>> +----------------+
>> | rev_timestamp  |
>> +----------------+
>> | 20140124092716 |
>> +----------------+
>>
>> Revision count query (SELECT count(*) FROM revision;) gives
>>> 9,76,399,while special:stats shows 10,10,990. just a while ago.
>>>
>> This could be on purpose (e.g. hidden revisions, or revisions of deleted
>> pages).
>>
>
> Thanks for the tip. As per your report, which I verified, there does not
> seem to be replication lag.
>
> But for my queries
> <https://te.wikipedia.org/wiki/%E0%B0%B5%E0%B0%BF%E0%B0%95%E0%B1%80%E0%B0%AA%E0%B1%80%E0%B0%A1%E0%B0%BF%E0%B0%AF%E0%B0%BE_%E0%B0%9A%E0%B0%B0%E0%B1%8D%E0%B0%9A:%E0%B0%B5%E0%B0%BF%E0%B0%95%E0%B1%80%E0%B0%AA%E0%B1%8D%E0%B0%B0%E0%B0%BE%E0%B0%9C%E0%B1%86%E0%B0%95%E0%B1%8D%E0%B0%9F%E0%B1%81/%E0%B0%A8%E0%B0%BE%E0%B0%A3%E0%B1%8D%E0%B0%AF%E0%B0%A4%E0%B0%BE%E0%B0%AD%E0%B0%BF%E0%B0%B5%E0%B1%83%E0%B0%A6%E0%B1%8D%E0%B0%A7%E0%B0%BF-%E0%B0%B5%E0%B0%BF%E0%B0%95%E0%B1%80%E0%B0%9F%E0%B1%8D%E0%B0%B0%E0%B1%86%E0%B0%82%E0%B0%A1%E0%B1%8D%E0%B0%B8%E0%B1%8D#.E0.B0.AE.E0.B0.BE.E0.B0.B0.E0.B1.8D.E0.B0.AA.E0.B1.81.E0.B0.B2_.E0.B0.97.E0.B0.A3.E0.B0.BE.E0.B0.82.E0.B0.95.E0.B0.BE.E0.B0.B2_.E0.B0.B5.E0.B1.81.E0.B0.A6.E0.B0.BE.E0.B0.B9.E0.B0.B0.E0.B0.A3.E0.B0.B2.E0.B1.81>,
> only old data for couple of pages is being listed, while there are valid
> entries for other pages in the revision history.
>
> How to troubleshoot further?
>
> Thanks
> Arjuna
>
>
>
>>
>> Merlijn
>>
>> _______________________________________________
>> 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: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20140125/2c7fb9ad/attachment.html>