Last modified: 2014-10-24 08:33:31 UTC
I noticed the top revisions for at least several pages on enwiki do not exist in the revision table, after my bot started freaking out. For example: MariaDB [enwiki_p]> SELECT page_title, page_namespace, page_latest FROM page WHERE page_id = 43895206; +------------------------------+----------------+-------------+ | page_title | page_namespace | page_latest | +------------------------------+----------------+-------------+ | Anthony_Randolph_(economist) | 118 | 626463325 | +------------------------------+----------------+-------------+ 1 row in set (0.00 sec) MariaDB [enwiki_p]> SELECT * FROM revision WHERE rev_id = 626463325; Empty set (0.00 sec) Looking further, it seems that there are nearly 12,000 pages with this problem: MariaDB [enwiki_p]> SELECT COUNT(*) FROM page LEFT OUTER JOIN revision ON page_latest = rev_id WHERE rev_id IS NULL; +----------+ | COUNT(*) | +----------+ | 11831 | +----------+ 1 row in set (5 min 52.01 sec) This is not a replication lag issue; the lag is zero. I am not clear if this is related to bug 71084 or bug 70711.
Sync in progress. Cause is not yet confirmed, with https://mariadb.atlassian.net/browse/MDEV-6551 a possibility. Very interested to hear if anyone observes this with recent (<1week) data.