Delete import-queue entries for obsolete distroseries

Bug #430154 reported by Jeroen T. Vermeulen
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Medium
Jeroen T. Vermeulen

Bug Description

Arne points out that Dapper and Gutsy right now make up about ⅓ of the import queue—and of those entries, the only ones that will ever be needed again are for Dapper Server.

So we could clean up the queue considerably by deleting entries for obsolete series in batches. For instance, we could run this once an hour:

DELETE FROM TranslationImportQueueEntry
WHERE id IN (
    SELECT Entry.id
    FROM TranslationImportQueueEntry Entry
    JOIN DistroSeries ON DistroSeries.id = Entry.distroseries
    WHERE DistroSeries.releasestatus = 6
    LIMIT 100
)

Takes almost no time to execute, doesn't stress replication much, but would clear out the Gutsy queue within two weeks.

Related branches

Changed in rosetta:
assignee: nobody → Jeroen T. Vermeulen (jtv)
importance: Undecided → Medium
milestone: none → 3.1.10
status: New → In Progress
Changed in rosetta:
status: In Progress → Fix Committed
Changed in rosetta:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.