Delete import-queue entries for obsolete distroseries
Bug #430154 reported by
Jeroen T. Vermeulen
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 TranslationImpo
WHERE id IN (
SELECT Entry.id
FROM TranslationImpo
JOIN DistroSeries ON DistroSeries.id = Entry.distroseries
WHERE DistroSeries.
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
lp:~jtv/launchpad/bug-146855
Merged
into
lp:launchpad
- Aaron Bentley (community): Approve
-
Diff: 867 lines8 files modifiedcronscripts/rosetta-approve-imports.py (+5/-21)
database/schema/security.cfg (+17/-3)
lib/lp/translations/doc/poimport.txt (+19/-12)
lib/lp/translations/interfaces/translationimportqueue.py (+20/-13)
lib/lp/translations/model/translationimportqueue.py (+86/-38)
lib/lp/translations/scripts/import_queue_gardener.py (+50/-0)
lib/lp/translations/scripts/po_import.py (+4/-55)
lib/lp/translations/tests/test_autoapproval.py (+153/-1)
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.