Opened 9 years ago

Closed 9 years ago

#17624 closed Bug (duplicate)

Transaction committed on user abort

Reported by: George Lund Owned by: nobody
Component: Database layer (models, ORM) Version: 1.3
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


If the user aborts execution of some code (e.g. with Control+C), any ongoing transaction is committed, rather than rolled back. This is in Python 2.5, I suspect later versions could be different.

from __future__ import with_statement
from django.db import transaction
with transaction.commit_on_success():
 for x in xx:
  # long loop

If an "normal" exception is raised during the long loop, the transaction aborts correctly.

However, if the user presses Control+C (very possible during a management command), the half-finished transaction is committed.

The reason is that the Transaction's __exit__ method only passes on exc_value, but not exc_type.

At least in Python 2.5, exc_type can be set, whilst exc_value is still None.

(Pdb) exc_type
<type 'exceptions.KeyboardInterrupt'>
(Pdb) exc_value
(Pdb) exc_value is None

This is really confusing, and I'd certainly hope it got fixed in a later version of Python.

From a brief look at the code it looks like rather than pass on exc_value to the exiting function, we could just pass on a Boolean success flag, based on whether any of the three __exit__ parameters were set. I'll try and work up a patch today.

Attachments (1)

django-bug-17624.patch (1.5 KB) - added by George Lund 9 years ago.
patch to make Transaction recognise failure in more cases

Download all attachments as: .zip

Change History (3)

Changed 9 years ago by George Lund

Attachment: django-bug-17624.patch added

patch to make Transaction recognise failure in more cases

comment:1 Changed 9 years ago by George Lund

Has patch: set

So here's my patch. Reproducing this bug is difficult: about 50% of runs of my code, I found that exc_value was set - the rest of the time, the transaction was getting committed due to this bug.

This patch is no good if it is considered that Transaction is part of the public API, i.e. if anyone else might have defined their own decorators for some other kind of behaviour. Which seems unlikely to me, but clearly other ways of fixing this are possible.

comment:2 Changed 9 years ago by Claude Paroz

Resolution: duplicate
Status: newclosed

This is a duplicate of #16682

Note: See TracTickets for help on using tickets.
Back to Top