Page MenuHomePhabricator

Need a mechanism / process to purge invalid / stale entries from the Linter database
Open, NormalPublic

Description

T165070, T162920, and T163549 are all examples where the underlying linter data are invalid and should be removed from the database. Separately, T148609 saw a revert of Linter on large wikis. Any existing linter data for those wikis will likely be stale / invalid when the linter is re-enabled on those wikis.

So, we need some mechanism of isolating those entries and clearing them from the db. Maybe this is simply someone running a database query to delete relevant entries. The filter is different in each case. It is not clear what a good solution is. But, filing this task to brainstorm some solutions / strategies.

One obvious harmless query would be to purge all entries for titles where the revision id for the linter data is no longer the most recent id for the title.

Event Timeline

ssastry created this task.May 16 2017, 9:36 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 16 2017, 9:36 PM
ssastry triaged this task as High priority.Aug 6 2017, 3:09 PM
ssastry added a subscriber: Legoktm.Apr 6 2018, 9:35 PM

This came up again in https://www.mediawiki.org/wiki/Topic:Uabwjm0wagfw9l4c and @Legoktm said we can write a maintenance script for this.

ssastry assigned this task to Legoktm.Apr 6 2018, 9:35 PM
ssastry lowered the priority of this task from High to Normal.
Legoktm removed Legoktm as the assignee of this task.May 19 2019, 8:08 AM

Not currently working on this.