Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2816

Better handling for master's response (0xff) to COM_STMT_PREPARE

    XMLWordPrintable

Details

    Description

      When prepared statements are routed to both master and slave by readwritesplit router, in some cases we may get warnings like this:

      2019-12-18 14:07:33 warning: (62418270) Slave server 'db2': response (0x00) differs from master's response (0xff) to COM_STMT_PREPARE: `SELECT ... FROM ... WHERE (`t1`.`c1` = ?) AND ...)`. Closing slave connection due to inconsistent session state.
      

      I suspect it may be cause by the need to re-prepare the query on master when/if ALTER was executed there.

      In any case, better logging for the reasons of response 0xff from master would help.

      Attachments

        Activity

          People

            markus makela markus makela
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.