aws-samples / aws-refarch-wordpress

This reference architecture provides best practices and a set of YAML CloudFormation templates for deploying WordPress on AWS.
MIT No Attribution
1.08k stars 609 forks source link

Error creating stack - DatabaseCluster failed with incorrect MySql Aurora version #93

Open guytz72 opened 1 year ago

guytz72 commented 1 year ago

I tried to create this stack with the provided templates but it was failing. I set it not to destroy objects on failure, and it has created most of the stack but is failing the below.:

Resource handler returned message: "Cannot find version 5.7.mysql_aurora.2.10.1 for aurora-mysql (Service: Rds, Status Code: 400, Request ID: 68c7c078-160a-451e-869d-15b003da2427)" (RequestToken: c6e7286f-dcf2-f077-45f6-14a14b3bb5e8, HandlerErrorCode: InvalidRequest)

Not sure where I can set a different version of the database, but if I check in the console I can't see that version.

vc95 commented 1 year ago

Hello,

I faced same issue, the rds cloudformation template stored in their S3 Bucket (used in master template) is not up to date with code on this repo .

You can try to put this repo rds template on one of your bucket and edit the master template to change the rds.TemplateURL param with your S3 URL.

But to fix that error I just changed the one stored on AWS S3:

  1. Download the rds cloudformation template used in master template
  2. Edit all the lines containing the engine version with the most recent you can get here
    - EngineVersion: 5.7.mysql_aurora.2.10.1
    + EngineVersion: 5.7.mysql_aurora.2.11.2
  3. Upload edited file to one of your bucket or whatever to have a public URL.
  4. Download the master cloudformation template
  5. Change the RDS template URL with your URL
  6. Upload your edited master template to cloudformation template