RDS restore from S3 for MySQL with xtrabackup - stuck creating

Question

Hello,
I have an xtrabackup of a MySQL 5.7 server in s3 (approx 250gb uncompressed).  I've created an RDS instance using Restore from S3 and it's currently stuck in "Creating" status for at least 6+ hours.  The mysql error log doesn't give me any clues other than it seems to work and one of the last lines says it's ready for connections.  The last event on the other hand says DB Instance Shutdown.  Any ideas on why it keeps shutting down or why it's stuck in creating?  Is there any other way to get insights on what's happening with the RDS instance?

Answer

Hello,
I'm Seungwon, the support engineer answering you with RDS issue.
 
I regret to inform you that I am unable to provide an exact root cause analysis for your inquiry. 
Because, I can’t accesses your resources.
So, I can only offer responses based on general possibilities. 
Your understanding in this matter is greatly appreciated.

First of all you need to check below limitations.

[+] Restoring a backup into a MySQL DB instance - Limitations and recommendations for importing backup files from Amazon S3 to Amazon RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html#MySQL.Procedural.Importing.Limitations

In some cases, if there is an existing user in the previous database backup with the same name as the M'aster user of the current RDS instance being created, it can possible to failures.

I hope that you found this information useful and the services mentioned above are suitable for your requirements and specific use-cases.

If further precise analysis and root cause identification are required, I recommend considering enrollment in an AWS Support Plan.

This will ensure that an appropriate engineer is assigned to your case, enabling you to obtain the desired resolution.

[+] AWS Support Plan - https://aws.amazon.com/premiumsupport/plans/?nc1=h_ls

RDS restore from S3 for MySQL with xtrabackup - stuck creating

Relevant content