# sqlalchemy.exc.InvalidRequestError：一个或多个映射器初始化失败——无法继续初始化其他映射器。原始异常为：检测到循环依赖。

- **ID:** `python/sqlalchemy-circular-dependency`
- **领域:** python
- **类别:** config_error
- **验证级别:** ai_generated
- **修复率:** 80%

## 根因

模型之间存在循环关系，未正确使用 back_populates 或 lazy='dynamic'。

## 版本兼容性

| 版本 | 状态 | 引入 | 弃用 |
|------|------|------|------|
| 3.x | active | — | — |

## 解决方案

1. **Use back_populates correctly.** (95% 成功率)
   ```
   class Parent(Base):
    children = relationship('Child', back_populates='parent')
class Child(Base):
    parent_id = Column(ForeignKey('parents.id'))
    parent = relationship('Parent', back_populates='children')
   ```
2. **Use lazy='dynamic' on one side.** (90% 成功率)
   ```
   children = relationship('Child', back_populates='parent', lazy='dynamic')
   ```

## 无效尝试

- **Removing one relationship entirely.** — Loses necessary data access patterns. (50% 失败率)
- **Setting both relationships to lazy='noload'.** — Prevents loading but may break application logic. (70% 失败率)