Django Tests fail with InternalError: no such savepoint. DB: Postgres, passes on mysql

Question

Interestingly it also works on the shell.

   [MY code which calls Model.objects.get_or_create(...)]
  File "/usr/lib/python2.5/site-packages/django/db/models/manager.py", line 123, in get_or_create
    return self.get_query_set().get_or_create(**kwargs)
  File "/usr/lib/python2.5/site-packages/django/db/models/query.py", line 308, in get_or_create
    transaction.savepoint_rollback(sid)
  File "/usr/lib/python2.5/site-packages/django/db/transaction.py", line 199, in savepoint_rollback
    connection._savepoint_rollback(sid)
  File "/usr/lib/python2.5/site-packages/django/db/backends/__init__.py", line 67, in _savepoint_rollback
    self.cursor().execute(self.ops.savepoint_rollback_sql(sid))
InternalError: no such savepoint

Jiaaro · Accepted Answer · 2012-03-29 20:50:13Z

3

If you want to test code that uses transactions, you'll need to subclass TransactionTestCase instead of TestCase

for example:

from django.test import TransactionTestCase

class MyTests(TransactionTestCase):
    ...

It probably passes in MySql because you're using MyISAM tables which don't support transactions

answered Mar 29, 2012 at 20:50

Jiaaro

77.4k43 gold badges177 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django Tests fail with InternalError: no such savepoint. DB: Postgres, passes on mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related