<div dir="ltr"><div>Hi,<br><span></span><span class=""><span class=""><br>Thanks to help by anomie on</span></span><span></span> #wikimedia-labs IRC, I traced the problem to missing underscores in page titles in place of blanks in the original titles.<br>
<br></div>Cheers<br>Arjuna<br><div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jan 24, 2014 at 3:07 PM, Arjuna Rao Chavala <span dir="ltr"><<a href="mailto:arjunaraoc@gmail.com" target="_blank">arjunaraoc@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Merlijn,<br><div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Fri, Jan 24, 2014 at 3:00 PM, Merlijn van Deen <span dir="ltr"><<a href="mailto:valhallasw@arctus.nl" target="_blank">valhallasw@arctus.nl</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div>On 24 January 2014 10:21, Arjuna Rao Chavala <span dir="ltr"><<a href="mailto:arjunaraoc@gmail.com" target="_blank">arjunaraoc@gmail.com</a>></span> wrote:<br>



<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div><div><div>While doing few database queries, I noticed that the data does not cover the recent edits.<br>



</div></div></div></div></blockquote><div><br></div></div><div>It does cover them. The correct way to check for replag is checking for the latest change:</div><div><div>MariaDB [tewiki_p]> select rev_timestamp from revision order by rev_id desc limit 1;</div>



<div>+----------------+</div><div>| rev_timestamp  |</div><div>+----------------+</div><div>| 20140124092716 |</div><div>+----------------+</div></div><div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">



<div dir="ltr"><div><div><span>Revision count query (SELECT count(*) FROM revision;) gives 9,76,399,while special:stats shows 10,10,990. just a while ago.<br></span></div></div></div></blockquote></div><div>This could be on purpose (e.g. hidden revisions, or revisions of deleted pages).</div>

</div></div></div></blockquote><div><br></div></div></div><div>Thanks for the tip. As per your report, which I verified, there does not seem to be replication lag.<br><br></div><div>But for <a href="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" target="_blank">my queries </a>, only old data for couple of pages is being listed, while there are valid entries for other pages in the revision history.<br>

<br></div><div>How to troubleshoot further?<br><br></div><div>Thanks<br>Arjuna<br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">

<div class="gmail_extra"><div class="gmail_quote"><span><font color="#888888">

<div><br></div><div>Merlijn</div></font></span></div></div></div>
<br>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org" target="_blank">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br></div></div></div>
</blockquote></div><br></div>