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 <[email protected]>wrote: > 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
