| Halfak | |
| Jun 11 2015, 3:53 PM2015-06-11 15:53:02 (UTC+0) |
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
Quite possibly caused by T41007. But unable to confirm at the moment.
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.