Error Launching CloudFormation Stack for Keycloak on Aurora MySQL - Incompatible Version

[bogdan-romaniv]

Description
When attempting to deploy Keycloak using the "Deploy Keycloak based on Aurora MySQL-Compatible from a new VPC" option in the CloudFormation stack, I encounter an error related to an incompatible version of Aurora MySQL.

Error Details
The error message displayed is as follows:

Resource handler returned message: "Cannot find version 5.7.mysql_aurora.2.09.1 for aurora-mysql (Service: Rds, Status Code: 400, Request ID: 0670f6cd-4e6e-400f-bb14-5f3b9babaf9b)" (RequestToken: 2480a588-7a66-d6c3-5f35-40cee750a705, HandlerErrorCode: InvalidRequest)

Proposed Solution and Testing
After encountering this issue, I updated the stack version to "5.7.mysql_aurora.2.12.0", and upon testing, I found that everything works correctly with this version. Therefore, I suggest updating the CloudFormation template to use this version.

Here are the versions available according to the AWS CLI command:
aws rds describe-db-engine-versions --engine aurora-mysql --query "DBEngineVersions[].EngineVersion"
[
"5.7.mysql_aurora.2.07.9",
"5.7.mysql_aurora.2.07.10",
"5.7.mysql_aurora.2.11.1",
"5.7.mysql_aurora.2.11.2",
"5.7.mysql_aurora.2.11.3",
"5.7.mysql_aurora.2.11.3",
"5.7.mysql_aurora.2.11.4",
"5.7.mysql_aurora.2.12.0",
"8.0.mysql_aurora.3.01.0",
"8.0.mysql_aurora.3.01.1",
"8.0.mysql_aurora.3.02.0",
"8.0.mysql_aurora.3.02.1",
"8.0.mysql_aurora.3.02.2",
"8.0.mysql_aurora.3.02.3",
"8.0.mysql_aurora.3.03.0",
"8.0.mysql_aurora.3.03.1",
"8.0.mysql_aurora.3.03.2",
"8.0.mysql_aurora.3.04.0",
"8.0.mysql_aurora.3.04.1",
"8.0.mysql_aurora.3.05.0"
]

Additional Information
Reviewing the revision file reveals the following:

Release 2.1.6
Upgrade Keycloak to version 22.0.4
Upgrade aws-cdk to version 2.100.0
Upgrade cdk-keycloak to version 2.9.0

However, the deployed version of Keycloak seems to be "jboss/keycloak:16.1.1", not the official keycloak image and also not the version 22.0.4 of keycloak

Request
I would appreciate guidance on resolving this version compatibility issue or an update to the CloudFormation template to support the latest compatible versions of Aurora MySQL and Keycloak.

[wchaws]

@bogdan-romaniv Hi, can you test out the following template URLs? I think the problem should have been resolved in the v2.2.0 release, which was posted a month ago, but I didn't update the official website's latest template URL to v2.2.0 at that time. Now, It's updated. Please try it again.

https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-aurora-serverless-from-existing-vpc.template
https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-aurora-serverless-from-new-vpc.template
https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-from-existing-vpc.template
https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-from-new-vpc.template