Help improve AWS Support Official channel in re:Post and share your experience - complete a quick three-question survey to earn a re:Post badge!
Why is my Aurora cluster endpoint stuck in the Creating status after the AWS Backup restore job completes?
When I use AWS Backup to restore an Amazon Aurora cluster endpoint, the cluster gets stuck in the Creating status.
Resolution
Note: If you receive errors when you run AWS Command Line Interface (AWS CLI) commands, then see Troubleshooting errors for the AWS CLI. Also, make sure that you're using the most recent AWS CLI version.
After you use AWS Backup to restore an Aurora cluster, the restore job shows the Completed status. However, the Amazon Relational Database Service (Amazon RDS) console shows the Creating status until you manually attach the Amazon RDS instances to the restored cluster. Because you store the data in the cluster, the backup restoration restores only the cluster, not the instances.
Note: If you use the AWS Management Console to restore a DB cluster from a snapshot, then you also create the primary DB instance.
Aurora creates the endpoints only after you manually create the RDS instances in the restored cluster.
To manually attach the new instances to the Aurora cluster, run the following create-db-instance AWS CLI command:
aws rds create-db-instance --db-instance-identifier INSTANCE-NAME --db-cluster-identifier CLUSTER-NAME --engine ENGINE-NAME --db-instance-class SIZE-TYPE --region REGION-NAME
Note: In the preceding command, replace INSTANCE-NAME with the name of your instance and CLUSTER-NAME with the name of your restored cluster. Also, replace ENGINE-NAME with the cluster's engine name, SIZE-TYPE with your cluster's instance class, and REGION-NAME with the AWS Region that your cluster is in.
After you create the instance, the endpoints in the cluster are in the Available status.
This article actually saved my day. I had been sitting and waiting on the Aurora cluster restoring from backup for one hour, but endpoints were in the "Creating" mode for too long. I hoped that mighty AWS Backup and RDS would restore it automatically for me, especially that I selected instances type when performed the "restore" action. It's a shame that AWS Backup doesn't create instances automatically in AWS RDS when restoring the cluster.
Your documentation says this is done for us. Please stop wasting my time with this.
Thank you for your comment. We'll review and update the Knowledge Center article as needed.
Relevant content
- asked 3 years ago
- AWS OFFICIALUpdated 8 months ago
