Last modified: 2014-10-24 08:33:31 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T74226, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 72226 - Missing page revisions on enwiki
Missing page revisions on enwiki
Status: ASSIGNED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized major
: ---
Assigned To: Sean Pringle
:
Depends on:
Blocks: labs-replication
  Show dependency treegraph
 
Reported: 2014-10-19 05:39 UTC by Ben Kurtovic
Modified: 2014-10-24 08:33 UTC (History)
7 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Ben Kurtovic 2014-10-19 05:39:13 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.
Comment 1 Sean Pringle 2014-10-23 06:27:18 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links