Page MenuHomePhabricator

Orphaned revisions with rev_page pointing to nonexistent page
Open, Needs TriagePublic

Description

In dewiki, there are 32,701 records in the revision table without a corresponding record in the page table. Most of them, but not all, are caused by renaming the page.

Similarly, in enwiki, there are 248,916 records. See this query for the detailed data of a few.

These might be related to T102132 or a relative.

Event Timeline

Additionally there are 141649 records in the table 'flaggedpages' pointing to non-existing pages: https://quarry.wmflabs.org/query/42871

nshahquinn-wmf renamed this task from Entry in 'revision' table, but no entry in 'page' table to Orphaned revisions with rev_page pointing to nonexistent page.Dec 3 2024, 11:54 AM
nshahquinn-wmf updated the task description. (Show Details)