# MySQL 服务器已断开连接：错误 1114 (HY000) 表已满 - 存储自动扩展未能增加容量

- **ID:** `aws/rds-storage-full-autoscaling-failure`
- **领域:** aws
- **类别:** resource_error
- **错误码:** `1114`
- **验证级别:** ai_generated
- **修复率:** 82%

## 根因

RDS 实例存储已满，由于达到最大存储限制、自动扩展策略的 IAM 权限不足或存储类型不支持自动扩展（例如，磁性存储），自动存储扩展失败。

## 版本兼容性

| 版本 | 状态 | 引入 | 弃用 |
|------|------|------|------|
| MySQL 8.0.35 | active | — | — |
| RDS 2024-09-01 | active | — | — |
| AWS CLI 2.18.0 | active | — | — |

## 解决方案

1. ```
   Increase storage manually via the AWS CLI: `aws rds modify-db-instance --db-instance-identifier mydb --allocated-storage 200 --apply-immediately`
   ```
2. ```
   Enable storage autoscaling with a higher maximum limit: `aws rds modify-db-instance --db-instance-identifier mydb --max-allocated-storage 1000`
   ```
3. ```
   Run OPTIMIZE TABLE on the affected table to reclaim space: `OPTIMIZE TABLE mytable;` (note: this locks the table and may take time).
   ```

## 无效尝试

- **** — InnoDB does not release disk space to the OS after deletes; the table remains full until OPTIMIZE is run. (75% 失败率)
- **** — Storage is still full; the error will reappear immediately after restart. (90% 失败率)
- **** — If storage fills again, autoscaling will fail if not re-enabled or if the new limit is still too low. (60% 失败率)