Hi Merlijn,
On Fri, Jan 24, 2014 at 3:00 PM, Merlijn van Deen <[email protected]>wrote: > On 24 January 2014 10:21, Arjuna Rao Chavala <[email protected]> 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
