Page MenuHomePhabricator
Create Task
Maniphest T102132

Entry in 'revision' table, but no entry in 'page' table (found in English Wikipedia -- rev_id: 611002002)
Closed, DuplicatePublic
Actions

Description

I've come across a revision in the 'revision' table that does not have a matching record in the 'page' table. It appears that this revision was created when renaming the page before it was deleted. It seems to me that this should be impossible within the constraints of MediaWiki's use of the database. If I'm right, this implies a bug.

See relevant queries here: http://quarry.wmflabs.org/query/3965

Related Objects

Event Timeline

Halfak created this task.Jun 11 2015, 3:53 PM
Halfak raised the priority of this task from to Needs Triage.
Halfak updated the task description. (Show Details)
Halfak added a project: MediaWiki-libs-Rdbms.
Halfak subscribed.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 11 2015, 3:53 PM
Aklapper triaged this task as Low priority.Jul 23 2015, 1:40 PM
Krinkle moved this task from Untriaged to Usage problem on the MediaWiki-libs-Rdbms board.Jul 29 2018, 12:03 AM
Krinkle subscribed.

Quite possibly caused by T41007. But unable to confirm at the moment.

Krinkle edited projects, added MediaWiki-Core-Revision-backend, Platform Engineering, Wikimedia-database-issue; removed MediaWiki-libs-Rdbms.Jul 18 2019, 8:04 PM
Krinkle moved this task from Untriaged to Bad data & Corruption on the Wikimedia-database-issue board.
Anomie closed this task as a duplicate of T106119: Moving a page over the redirect leaves an abandoned row in the revision table.Jul 19 2019, 1:24 PM
Anomie added a project: Platform Team Workboards (Clinic Duty Team).
Anomie subscribed.

There is a log entry attached to that rev_page: https://en.wikipedia.org/wiki/Special:Log?logid=56820743

The content of the revision is also available, it being

#REDIRECT [[Dare (La La La) / La La La (Brazil 2014)]]
{{R from move}}

So pretty likely it was an orphaned revision left behind from before T106119: Moving a page over the redirect leaves an abandoned row in the revision table was fixed.

Anomie moved this task from Inbox to Done on the Platform Team Workboards (Clinic Duty Team) board.Jul 19 2019, 1:25 PM
Wurgl mentioned this in T241168: Entry in 'revision' table, but no entry in 'page' table.Dec 19 2019, 7:50 PM
Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:43 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL