RDS stuck in Deleting status

Question

As title says, my MySQL RDS (Multi AZ, 8.0.35) is stuck in the Deleting status. Prior to deleting the database I stopped it and checked the box to create a snapshot. I then proceeded to delete the database and unchecked the boxes to create a final snapshot.

Now, under database page in console it shows "Deleting", under CPU "-" and under maintenance column is empty.  I am fairly sure it didn't finish snapshoting in the first place as under Snapshots it shows "Creating" and 1% as progress.

And idea how should I proceed?

Marko · Answer

Unfortunately AWS CLI doesn't help, snapshot can't be deleted as it is not in the available or failed state:

```
An error occurred (InvalidDBSnapshotState) when calling the DeleteDBSnapshot operation: Cannot delete the snapshot because it is not currently in the available or failed state.
```

And db can't be deleted as well as it is in the process of deleting...

```
An error occurred (InvalidDBInstanceState) when calling the DeleteDBInstance operation: Instance ***-20240218 is already being deleted.
```

Manish Bhasin · Answer

Hi ,

The RDS will action on delete  once the snapshot is completed

Marko · Answer

Unfortunately, it is not happening. In this case, it is stuck on Creating snapshot at 1% and RDS is in status Deleting. All this for longer than a day now.

RDS stuck in Deleting status

Relevant content