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)(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)(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.