Deleting RDS DB Instance fails with "NoDeleteAutomatedBackups must be specified"

Products

• Operations Manager

Issue/Introduction

When deleting one RDS service instance which is provisioned through Tanzu Cloud Service Broker for AWS, it might fail with error "NoDeleteAutomatedBackups must be specified" as shown below.

deprovision failed: Error: deleting RDS DB Instance (csb-postgresql-####): operation error RDS: DeleteDBInstance, https response error StatusCode: 400, RequestID: ####, api error InvalidParameterCombination: Your RDS instance csb-postgresql-#### is associated with an AWS Backup resource with id arn:aws:backup:ap-southeast-2:####:recovery-point:####:db-####. NoDeleteAutomatedBackups must be specified. For more details, see the AWS Backup documentation. exit status 1

NoDeleteAutomatedBackups must be specified.

 

Environment

Tanzu Cloud Service Broker for AWS

Cause

As it's stated in the error message, "NoDeleteAutomatedBackups must be specified" is returned because there is some recovery-point resource still associated with the backup resource of the RDS instance to be deleted while the operation would also delete automated backups. 

There is a configuration parameter for the service plan called delete_automated_backups, which is to control wether to remove automated backups immediately after the database instance is deleted. This parameter will be set to true if not explicitly specified. 

Resolution

If you want to remove the automated backups along with the RDS instance, then delete the recovery-point resource (or other resource that might be reported in the error message) first. 

Or if you want to retain the automated backups, then update the service instance by setting delete_automated_backups to true with the following command.

cf update-service SERVICE-INSTANCE-NAME -c '{"delete_automated_backups": "false"}'

Confirm the service instance is successfully updated with command "cf service SERVICE-INSTANCE-NAME". Then attempt to delete the service instance again.

You can also set delete_automated_backups parameter at the plan level to let the new service instances created with this plan pick up the new setting automatically.

Refer to the Tanzu Cloud Service Broker for AWS document for more details.

Please also check out the AWS document for how to delete the retained automated backups manually.