Upload processing may reach a transaction deadlock when closing bugs
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Triaged
|
High
|
Unassigned |
Bug Description
Logging of the incident:
{{{
2009-07-28 11:45:11 DEBUG Created i386 build of torbutton 1.2.1-1ubuntu2 in ubuntu karmic RELEASE [1137540] in Primary Archive for Ubuntu (1755)
2009-07-28 11:45:11 DEBUG Closing bugs.
/srv/launchpad.
return self.getConjoin
2009-07-28 11:45:14 ERROR Exception while accepting: deadlock detected
DETAIL: Process 18239 waits for ShareLock on transaction 184906003; blocked by process 772.
Process 772 waits for ShareLock on transaction 184905870; blocked by process 18239.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."bug" x WHERE "id" OPERATOR(
-> http://
DETAIL: Process 18239 waits for ShareLock on transaction 184906003; blocked by process 772.
Process 772 waits for ShareLock on transaction 184905870; blocked by process 18239.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."bug" x WHERE "id" OPERATOR(
}}}
Changed in launchpad: | |
importance: | Medium → High |
The whole transaction was aborted and no email was sent.
We can't really avoid the deadlock (which was probably caused by concurrent changes to the bug) but we certainly could at least send the rejection-message.
In an ideal scenario we may also retry the transaction.