How do I resolve issues that occur when Amazon RDS DB instances run out of storage?
My Amazon Relational Database Service (Amazon RDS) DB instance is out of storage, and I can't stop, restart, or connect to the instance.
Resolution
Note: If you can't connect to your Amazon RDS DB instance and the instance isn't in the storage-full state, then see Can't connect to Amazon RDS DB instance.
An Amazon RDS DB instance that's in the storage-full state doesn't have enough available space to perform basic operations. For example, you can't connect to or restart the instance. The instance accepts only allocated storage modifications. Modifications for other values are rejected.
Resolve the storage-full state
To resolve this issue, complete the following steps:
- Check the DB instance status to confirm that the status is storage-full.
- Increase the allocated storage of your DB instance by at least 10%.
When the DB instance is in the modifying state, the instance is operational. However, you can't make other storage modifications for 6 hours or until the status changes to storage-optimization.
In most cases, a small increase to Allocated storage allows you to reconnect to the instance so that you can perform additional troubleshooting.
For more information about how to troubleshoot storage issues on RDS DB instances, see the following resources:
- Why did I receive a "No space left on device" or "DiskFull" error on Amazon RDS for PostgreSQL?
- How do I troubleshoot an Amazon RDS for MySQL or MariaDB instance that shows storage full?
- Why does my Amazon RDS for Oracle DB instance use more storage than expected?
- Why is my Amazon RDS for MySQL DB instance using more storage than expected?
- How do I optimize storage consumption in my Amazon RDS for SQL Server DB instance?
Prevent storage-full state
To avoid the storage-full state, take the following actions:
- Monitor the DB instance metrics to track its performance and health.
- Use the FreeStorageSpace metric in Amazon CloudWatch to monitor available storage space for a DB instance.
- If your workload is cyclical or unpredictable, then turn on storage autoscaling for your Amazon RDS DB instance.
- Create a CloudWatch alarm to monitor the free storage space and notify you when the storage space reaches a specified threshold value.
Related information
Monitoring Amazon RDS log files
Amazon RDS now has a progress indicator for the storage optimization process
- Language
- English
What can be done to PostgreSQL to reduce the log files
replied 2 years ago
I managed an issuewith storage full when I couldn't increase storage space despite everything being fine, it still throw error it couldn't increase storage space. What I did: I enabled 2FA for my account and created access tokens for the cli. Using AWS cli, I increased storage. It threw the same error, but in the web console it has upgraded my db storage space and I could operate it
replied a year ago
@trhg Thank you! Web console would not increase storage, failed with this error:
We're sorry, your request to modify DB instance instance has failed. The specified database instance is currently in storage-full state. Please allocate more storage by modifying the DB instance.
But it worked in the CLI.
replied 9 months ago
Relevant content
asked a year ago
asked 3 years ago
- AWS OFFICIALUpdated 7 months ago
