Page MenuHomePhabricator

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

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

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: Wikimedia-Rdbms.
Halfak added a subscriber: Halfak.
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 added a subscriber: Krinkle.

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

Anomie added a subscriber: Anomie.

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.