[Labs-l] tewiki_p replication broken

[Arjuna Rao Chavala]

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/20140124/35e305b1/attachment.html>