Unable to turn on backups on the RDS instance.

Question

The following error occurred while turning on backups on a RDS instance.
"We're sorry, your request to modify the instance XXXmysqlrdsXXXX has failed.
Backup retention cannot be set to non-zero while there are instances doing a point in time restore from DB Instance XXXmysqlrdsXXXX. Please try after they are complete."
No instances were restored from the DB instance that time and also 'create read replica' option is disabled for that instance.

Answer

Hi Guru,

I am afraid that without looking into the details of your instance and error message that you receiving, we will not able to help further on this.
Unfortunately its not a generic error message and we need to drill down deep in this.

Do you have any AWS Support plan with us?

Answer

Hi Guru,

May I ask what is the version of RDS MySQL are you using?

"Create Read Replica" is disabled as you are currently having backup retention period as 0. For read replicas to work we need to have non-zero backup retention period. Please refer to the below link[1].

Did you try changing the backup retention any other time? If yes then did you get the same error message again?

If yes, then I would recommend create a Technical Support case for AWS Support[2] so that we could look into the details on this issue.

References:-

[1] Working with MySQL read replicas - Configuring read replicas with MySQL - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#USER_MySQL.Replication.ReadReplicas.Configuration

[2] Creating support cases and case management - https://docs.aws.amazon.com/awssupport/latest/user/case-management.html

Unable to turn on backups on the RDS instance.

Relevant content