# MySQL server has gone away: error 1114 (HY000) The table is full - Storage autoscaling failed to increase capacity

- **ID:** `aws/rds-storage-full-autoscaling-failure`
- **Domain:** aws
- **Category:** resource_error
- **Error Code:** `1114`
- **Verification:** ai_generated
- **Fix Rate:** 82%

## Root Cause

RDS instance storage is full and automatic storage scaling failed due to reaching the maximum storage limit, insufficient IAM permissions for the autoscaling policy, or a storage type that does not support autoscaling (e.g., magnetic).

## Version Compatibility

| Version | Status | Introduced | Deprecated |
|---------|--------|------------|------------|
| MySQL 8.0.35 | active | — | — |
| RDS 2024-09-01 | active | — | — |
| AWS CLI 2.18.0 | active | — | — |

## Workarounds

1. **Increase storage manually via the AWS CLI: `aws rds modify-db-instance --db-instance-identifier mydb --allocated-storage 200 --apply-immediately`** (95% success)
   ```
   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`** (85% success)
   ```
   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).** (70% success)
   ```
   Run OPTIMIZE TABLE on the affected table to reclaim space: `OPTIMIZE TABLE mytable;` (note: this locks the table and may take time).
   ```

## Dead Ends

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