1

I just switched from AWS RDS MySQL Writer instance to a Reader instance.

Now, I am getting below exception:

2025-03-28 05:33:56.412 trace_id= span_id= trace_flags= INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2025-03-28 05:33:57.003 trace_id= span_id= trace_flags= ERROR 1 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization. java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=prodxxxx-aurora-cluster.cluster-ro-xxxx.us-east-1.rds.amazonaws.com)(port=3306)(type=master) : (conn=18624923) could not load system variables 2025-03-28 05:33:57.005 trace_id= span_id= trace_flags= WARN 1 --- [ main] o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata : Could not connect to address=(host=prodxxxx-aurora-cluster.cluster-ro-xxxx.us-east-1.rds.amazonaws.com)(port=3306)(type=master) : (conn=18624923) could not load system variables

I verified that all configurations are correct.

Is there any fix specific to below error:

could not load system variables

Please help me fix the issue.

Improve this question
4
  • Is the instance mysql or amazon aurora with mysql compatibility? Because the two are not the same Commented Mar 28 at 11:59
  • Are you redacting your endpoint name with "xxxx"? Or are you literally trying to connect to "prodxxxx-aurora-cluster.cluster-ro-xxxx.us-east-1.rds.amazonaws.com" (with the xxxx). Commented Mar 28 at 15:45
  • I am using Aurora MySQL compatible engine. Commented Apr 2 at 5:29
  • I have redacted the endpoint with xxxx. Commented Apr 2 at 5:30
Load 1 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.