SQLAlchemy: 'DetachedInstanceError: Instance is not bound to a Session; attribute refresh operation cannot proceed'
@devsingh05▲ 10 net votes
After session.commit() objects are expired by default, and after the session closes, touching an attribute or lazy relationship triggers a refresh with no session. Options: create the sessionmaker with expire_on_commit=False; access or convert the data (to a Pydantic model or dict) before the session closes; or eager-load relationships with selectinload(). Very common in FastAPI dependencies that close the session before the response is serialised.