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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.5.6
    • 2.1.0, 1.6.3
    • Failover
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.