poimport (export)_uses a single long transaction, gets reaped

Bug #504821 reported by Michael Vogt on 2010-01-08
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself

Bug Description

when trying to get a export of the ddtp-ubuntu-universe component I got the following mail:

Hello Michael Vogt,

Launchpad encountered problems exporting the files you requested.
The Launchpad Translations team has been notified of this problem.
Please reply to this email for further assistance.

If you want to retry your request, you can do so at


This blocks a updated of the apt-ddtp translations for lucid.


summary: - ddtp-ubuntu-universe export in lucid faied
+ ddtp-ubuntu-universe export in lucid failed

It seems admins killed the run.

Btw, Michael, is there any reason why you are not making use of the bzr export which should be working well now?

Ok, this happens because transaction killer kills all transaction that are older than 4h. Since poimport is a read-only operation on the DB, adding several transaction.commits() (after each potemplate export, eg.) should solve the problem.

Changed in rosetta:
status: New → Triaged
importance: Undecided → High
Stuart Bishop (stub) wrote :

If it is read-only, it should probably be running in autocommit mode.

For performance wins, pull the translations from the slave database while you are there.

Robert Collins (lifeless) wrote :

This probably oopses now, with the combined work we've done, so raising to critical (though we don't have an actual oops to line up against today)

summary: - ddtp-ubuntu-universe export in lucid failed
+ poimport (export)_uses a single long transaction, gets reaped
tags: added: oops
Changed in launchpad:
importance: High → Critical
Steve Kowalik (stevenk) wrote :

cronscripts/rosetta-export-queue.py is making use of the slave database policy and hasn't been getting reaped recently.

Changed in launchpad:
status: Triaged → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers