Delete import-queue entries for obsolete distroseries

Bug #430154 reported by Jeroen T. Vermeulen on 2009-09-15
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
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  Edit
Everyone can see this information.

Other bug subscribers