StorageFull aws resource_error ai_generated true

StorageFull: Cannot create snapshot, your RDS instance has exceeded the maximum allocated storage for manual snapshots

ID: aws/rds-snapshot-storage-limit

Also available as: JSON · Markdown · 中文
85%Fix Rate
88%Confidence
1Evidence
2023-08-22First Seen

Version Compatibility

VersionStatusIntroducedDeprecatedNotes
RDS MySQL 8.0 active — — —
RDS PostgreSQL 15 active — — —
AWS CLI 2.14.0 active — — —

Root Cause

RDS manual snapshot storage has reached the account-level limit of 100% of allocated storage for the DB instance's region.

generic

中文

RDS手动快照存储已达到该数据库实例所在区域的账户级限制，即分配存储的100%。

Official Documentation

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html

Workarounds

  1. 90% success Delete old manual snapshots to free up storage: aws rds delete-db-snapshot --db-snapshot-identifier my-old-snapshot-2023 # List all snapshots first: aws rds describe-db-snapshots --db-instance-identifier my-db --snapshot-type manual 
    Delete old manual snapshots to free up storage:
aws rds delete-db-snapshot --db-snapshot-identifier my-old-snapshot-2023
# List all snapshots first:
aws rds describe-db-snapshots --db-instance-identifier my-db --snapshot-type manual
  2. 70% success Request a service quota increase for manual snapshot storage via AWS Support Center: https://console.aws.amazon.com/support/home#/case/create?issueType=service-limit-increase&limitType=service-code-rds 
    Request a service quota increase for manual snapshot storage via AWS Support Center:
https://console.aws.amazon.com/support/home#/case/create?issueType=service-limit-increase&limitType=service-code-rds
  3. 85% success Use automated snapshots instead of manual ones; automated snapshots have a separate, higher limit: aws rds modify-db-instance --db-instance-identifier my-db --backup-retention-period 7 
    Use automated snapshots instead of manual ones; automated snapshots have a separate, higher limit:
aws rds modify-db-instance --db-instance-identifier my-db --backup-retention-period 7

中文步骤

  1. 删除旧的手动快照以释放存储空间：
aws rds delete-db-snapshot --db-snapshot-identifier my-old-snapshot-2023
# 首先列出所有快照：
aws rds describe-db-snapshots --db-instance-identifier my-db --snapshot-type manual
  2. 通过AWS支持中心请求增加手动快照存储的服务配额：
https://console.aws.amazon.com/support/home#/case/create?issueType=service-limit-increase&limitType=service-code-rds
  3. 使用自动快照代替手动快照；自动快照有单独的更高限制：
aws rds modify-db-instance --db-instance-identifier my-db --backup-retention-period 7

Dead Ends

Common approaches that don't work:

  1. Increase the allocated storage for the RDS instance 80% fail

    The limit is based on a percentage of allocated storage, so increasing storage also raises the limit, but the error persists if you're still at 100%.

  2. Create a new RDS instance with larger storage and migrate data 90% fail

    This does not resolve the snapshot storage limit; the new instance will also hit the same limit if old snapshots are not deleted.

  3. Request a service limit increase for RDS snapshots 60% fail

    The snapshot storage limit is a hard default that can be increased, but many users don't request it and the increase takes time.