By using AWS re:Post, you agree to the AWS re:Post Terms of Use

RDS Data Api for Aurora Serverless V2 MySQL

0

Excited to see this: https://aws.amazon.com/about-aws/whats-new/2024/09/amazon-aurora-mysql-rds-data-api/, however....

I have enabled the Data API for my Aurora Serverless V2 cluster. When I try to use the query editor, I keep seeing the same error:

{"message":null,"code":"InternalServerErrorException","time":"2024-10-21T20:31:22.393Z","requestId":"ID","statusCode":500,"retryable":true}

There's nothing in the database Error or General logs to reference. The username and password are correct - I can connect to the database through my bastion EC2 instance using the same credentials. I opened up the database security group to let all IP4 & 6 traffic in. What am I missing?

Thanks

asked 2 months ago165 views
1 Answer
0

I understand your frustration with the error you're encountering while trying to use the RDS Data API for your Aurora MySQL Serverless v2 cluster. Let's go through some potential issues and solutions:

  1. Ensure you're using Aurora MySQL version 3.07 or higher, as the redesigned Data API supports these versions.

  2. Double-check that the Data API is properly enabled for your cluster. You can verify this in the RDS console under the "Connectivity & security" tab for your cluster.

  3. Verify that your IAM user or role has the necessary permissions to use the Data API. This includes permissions for the RDS Data API actions and access to the secrets in AWS Secrets Manager that store your database credentials.

  4. Check if you're using tag-based authorization. If so, ensure that your cluster has the appropriate tags and that your IAM policy allows access based on these tags.

  5. The error you're seeing (InternalServerErrorException) suggests a problem on the AWS side. This could be a temporary issue. Try your request again after a short wait.

  6. Ensure that your VPC security group settings allow outbound traffic to the Data API endpoint.

  7. If you're using a VPC endpoint for RDS, make sure it's correctly configured.

  8. Try using the AWS CLI or SDK to make a Data API call instead of the query editor to see if you get a more detailed error message.

If none of these steps resolve the issue, I recommend contacting AWS Support for further assistance. They can look into the specific details of your account and cluster configuration to identify the root cause of the problem.

Remember, the redesigned Data API for Aurora MySQL is a relatively new feature, so there might be some teething issues that AWS is still working on resolving.
Sources
Amazon Aurora MySQL now supports RDS Data API - AWS
Using RDS Data API - Amazon Aurora
Amazon RDS Data API supports tag-based authorization

profile picture
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions