[Labs-l] tewiki_p replication broken

Fri Jan 24 09:30:21 UTC 2014

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).

Merlijn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20140124/ebf464e1/attachment.html>