Page MenuHomePhabricator

deleteArchivedRevisions.php does not remove rows in `content` and `text` tables
Open, Needs TriagePublic

Description

Hello,

I tried to use deleteArchivedRevisions.php

To test how it worked, I created new page, make several revisions. Then I deleted the page.

Then I run php deleteArchivedRevisions.php --delete

The table archive became empty.
But the tables content and text were not modified. This is actual behavior.

Expected behavior: rows in tables content and text which corresponds to deleted page should be removed.

I tried other different scenarios, but I was not able to get content and text tables trimmed.

It looks like the file deleteArchivedRevisions.php (https://github.com/wikimedia/mediawiki/blob/master/maintenance/deleteArchivedRevisions.php) is outdated after introducing "Multi-Content Revisions/Content Meta-Data" described at https://www.mediawiki.org/wiki/Multi-Content_Revisions/Content_Meta-Data.

I also asked question at https://www.mediawiki.org/w/index.php?title=Topic:Vuex8d5m1kc441wo&topic_showPostId=w180el4we20epl79#flow-post-w180el4we20epl79

Event Timeline

The maintenance script is calling Maintenance::purgeRedundantText which deletes from text if the text is unused.

But no scripts deletes from slots and content

Reedy renamed this task from Bug: deleteArchivedRevisions.php does not remove rows in `content` and `text` tables to deleteArchivedRevisions.php does not remove rows in `content` and `text` tables.Jan 13 2022, 1:32 PM