python runtime_error ai_generated true

sqlalchemy.orm.exc.DetachedInstanceError: 实例 <User at 0x...> 未绑定到任何会话

sqlalchemy.orm.exc.DetachedInstanceError: Instance <User at 0x...> is not bound to a Session

ID: python/sqlalchemy-detached-instance-error

其他格式: JSON · Markdown 中文 · English
80%修复率
88%置信度
0证据数
2024-04-10首次发现

版本兼容性

版本状态引入弃用备注
3.x active — — —

根因分析

尝试访问或修改一个已与会话分离的ORM实例，通常是在调用 session.close() 或 session.expunge_all() 之后。

English

Attempting to access or modify an ORM instance that has been detached from its session, usually after session.close() or session.expunge_all().

generic

解决方案

  1. 95% 成功率 Use session.merge() to reattach the instance 
    merged_user = session.merge(detached_user)
print(merged_user.name)
  2. 85% 成功率 Refresh the instance with session.refresh() after reattaching 
    session.add(detached_user)
session.refresh(detached_user)

无效尝试

常见但无效的做法:

  1. Calling session.add() on the detached instance 80% 失败

    The instance is not in a pending state; it needs to be merged first.

  2. Reopening the session and reusing the same instance 70% 失败

    The instance's state is stale; you need to merge or refresh it.