RuntimeError: A durable atomic block cannot be nested within another atomic block.

[simevo]

Describe the bug

with postgres DB and psycopg 3 driver, occurs randomly when creating entity or vendor etc.:

Request Method: POST
Request URL:    http://localhost:8000/ledger/customer/simevo-pqr0mwbu/create/
Django Version: 4.2.8
Exception Type: RuntimeError
Exception Value:    
A durable atomic block cannot be nested within another atomic block.
Exception Location: /usr/local/lib/python3.11/site-packages/django/db/transaction.py, line 190, in __enter__
Raised during:  django_ledger.views.customer.CustomerModelCreateView
Python Executable:  /usr/local/bin/python3
Python Version: 3.11.6
Python Path:    
['/app',
 '/usr/local/lib/python311.zip',
 '/usr/local/lib/python3.11',
 '/usr/local/lib/python3.11/lib-dynload',
 '/usr/local/lib/python3.11/site-packages']
Server time:    Tue, 05 Dec 2023 13:23:52 +0000

To Reproduce

• start up django-ledger with postgres DB for example with: https://github.com/simevo/django-ledger-starter/tree/dockerize
• log in
• "New Entity", fill Entity Name and Address Line 1 hit "Create"
• if it does not happen, try creating a vendor immediately thereafter

Expected behavior it should create the entity

Screenshots

[simevo]

I think I figured out what is going on here, nothing wrong with your code.

In here I set (as we normally do) ATOMIC_REQUESTS = true as per https://docs.djangoproject.com/en/4.2/topics/db/transactions/#tying-transactions-to-http-requests.

Turns out you already wrap all changes to the DB with transaction.atomic(durable=True): so the two approaches clash together.

I removed the setting:

--- a/django_ledger_starter/settings.py
+++ b/django_ledger_starter/settings.py
@@ -88,7 +88,6 @@ DATABASES = {
         "USER": env("DATABASE_USER"),
         "PASSWORD": env("DATABASE_PASSWORD"),
         "TEST": {"NAME": env("DATABASE_NAME")},
-        "ATOMIC_REQUESTS": True,
     }
 }
 if "DATABASE_HOST" in env:

and the problem goes away. I'll now update https://github.com/arrobalytics/django-ledger-starter/pull/1