Page MenuHomePhabricator

Create script for moving orphaned revisions to the archive table
Open, LowPublic

Description

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.

Details

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 31 2016, 5:55 PM
GeoffreyT2000 triaged this task as Low priority.Mar 29 2017, 2:26 AM

This one is the hardest to implement. Let's worry about T154372 and T154373 first, which are easier.

Change 463171 had a related patch set uploaded (by GeoffreyT2000; owner: GeoffreyT2000):
[mediawiki/core@master] Allow archiving orphaned revisions instead of deleting them permanently

https://gerrit.wikimedia.org/r/463171

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 :)

Change 463171 had a related patch set uploaded (by GeoffreyT2000; owner: GeoffreyT2000):
[mediawiki/core@master] Allow archiving orphaned revisions instead of deleting them permanently

https://gerrit.wikimedia.org/r/463171