python runtime_error ai_generated true

sqlalchemy.exc.InvalidRequestError：此会话处于'已回滚'状态。不允许任何操作。

sqlalchemy.exc.InvalidRequestError: This session is in 'rolled back' state. No operations are allowed.

ID: python/sqlalchemy-session-rollback-error

其他格式: JSON · Markdown 中文 · English
80%修复率
85%置信度
0证据数
2025-07-08首次发现

版本兼容性

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

根因分析

在回滚后尝试使用会话而未开始新事务。

English

Attempting to use a session after a rollback without beginning a new transaction.

generic

解决方案

  1. 95% 成功率 Begin a new transaction after rollback. 
    session.rollback()
session.begin()  # Start new transaction
  2. 90% 成功率 Use session.begin() context manager to auto-handle rollback. 
    with session.begin():
    session.add(obj)
# Automatically commits or rolls back

无效尝试

常见但无效的做法:

  1. Calling session.commit() after rollback. 90% 失败

    Session is in invalid state; must begin new transaction.

  2. Ignoring rollback and continuing. 80% 失败

    Session remains in aborted state; all operations fail.