Page MenuHomePhabricator

Investigate purging expired watchlist items as a result of
Closed, ResolvedPublic

Description

This is a brainstorming ticket.

Statement of a problem

This is a spinoff from T223174: [Timebox - 8 hours] Investigation: Watchlist Expiry. We're considering various ways to clear the watchlist table from expired rows. One of the options is to detect that there are expired rows when viewing the watchlist and delete them.

Because DB writes on GET are no bueno, we need something else. I remember hearing that creating new jobs is also not allowed - it this really true? Any other ways?

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

I assume a mixture of opportunistic (limited row count) purging of rows during existing watchlist row changes along with WHERE clause filtering on SELECT to ignore expired rows would work (e.g. similar to blocks and page protections).