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

            Assignee:
            markus makela markus makela
            Reporter:
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: