How Do You Delete an Aurora Database when You Get an Error about It Not Being Started?

Problem scenario
You are trying to delete an Aurora database but you get this error: "This database is not started." What do you do?

Possible Solution #1 (with the web console)
1. Log into the web console.
2. Go to "Amazon RDS".
3. Go to "Databases"
4. Click on the Aurora cluster of the database you want to delete or its parent.
5. Go to Actions -> Start
6. If it is grayed out, it may be stopping. It can take several minutes to fully stop.
7. Then go to Actions -> Delete. Respond to the next prompt.

Possible Solution #2 (with the AWS CLI)
From the AWS CLI, run these two commands (but replace "foobar" with the database name that you want to delete):

aws rds start-db-instance --db-instance-identifier foobar
# You may have to wait 10 minutes or more for the database to start
aws rds delete-db-instance --db-instance-identifier foobar

Leave a comment

Your email address will not be published. Required fields are marked *