Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-419

Insert Query failed after failover and not able to get master connection

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.6
    • Fix Version/s: 2.1.0, 1.6.3
    • Component/s: Failover
    • Labels:
      None
    • Environment:
      AWS Aurora
      Spring JdbcTemplate and SimpleJdbcCall
      rewriteBatchedStatements=true
      Execute INSERT query using jdbcTemplate
      Execute Stored Procedure using SimpleJdbcCall

      Description

      Inserting records failed after failover and throws an exception as following;
      SQL state [HY000]; error code [1290]; (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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                diego dupin Diego Dupin
                Reporter:
                seanderson Seonmi Anderson
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: