Status: Closed (View Workflow)
Affects Version/s: 1.5.6
Spring JdbcTemplate and SimpleJdbcCall
Execute INSERT query using jdbcTemplate
Execute Stored Procedure using SimpleJdbcCall
Inserting records failed after failover and throws an exception as following;
SQL state [HY000]; error code ; (conn:6) The MySQL server is running with the --read-only option so it cannot execute this statement
Any exception starting with '08xxx' or '25Sxxx' handled and reset connection. Error code '1290' is treated general SQL exception and eventually application instance should be restarted to fix it.
In AuroraProtocol, it passes MustBeMasterConnection before executing query but it seems not used to validate the master connection.
Please help me if I missed any parameters in connection configuration.