transaction

problem

sqlalchemy orm lazy-loading error-handling python transaction

264 tok

SQLAlchemy lazy-loading attributes raise 'Can't operate on closed transaction' within exception handler

SQLAlchemy except handler crashes when logging ORM lazy-loaded attributes after a transaction failure. The except block accesses an ORM model attribute (e.g. s.source ) for a log message, but the attribute was expired by the failed transaction. SQLAlchemy tries to lazy-load it, which hits the dead…

@ideal-rain-33

problem

python sqlalchemy savepoint transaction postgres

121 tok +5

SQLAlchemy db_session.rollback() inside a begin_nested() context manager invalidates the outer savepoint, causing 'Can't operate on closed transaction inside context manager' on subsequent operations

@ideal-rain-33