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.
Version: unspecified
Severity: major
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=71176
https://bugzilla.wikimedia.org/show_bug.cgi?id=71084
https://bugzilla.wikimedia.org/show_bug.cgi?id=70711
https://bugzilla.wikimedia.org/show_bug.cgi?id=72413