A maintenance script should be created for moving all orphaned revisions resulting from moves over redirects to the archive table. Because the same title (the target of the overwritten redirects) might have been moved over two different redirect titles, the script should sort the moves in chronological order, as well as the overwritten redirects, to get the ar_title for each orphaned revision. Orphaned revisions occur since T55687 (formerly Bugzilla 53687) was resolved and until T106119 was resolved. Alternatively, we could instead use generic titles for the revisions to be saved in the archive table.
Related Gerrit Patches:
|mediawiki/core : master||Allow archiving orphaned revisions instead of deleting them permanently|
|Stalled||None||T164891 Clean up orphaned revisions on Wikimedia wikis|
|Open||None||T154370 Create script for moving orphaned revisions to the archive table|
- Mentioned In
- T164891: Clean up orphaned revisions on Wikimedia wikis
- Mentioned Here
- T154372: Create script for retroactively generating old "delete_redir" log entries
T154373: Create script for converting deletion log entries to "delete_redir"
T55687: LinksDeletionUpdate skipped, causing revisions to disappear on undelete
T106119: Moving a page over the redirect leaves an abandoned row in the revision table
As part of the work the Analytics does on providing stats over (almost) all wikis, we can provide a list of orphan-revisions (no associated page_id, or no associated user_id/user_text even if rev_delete < 4). Please ping us if needed :)