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

sysbench failed to initialize w/ MaxScale read/write splitter

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.2.1
    • Fix Version/s: 2.2.2
    • Component/s: readwritesplit
    • Labels:
      None
    • Environment:
      CentOS 7.4.1708 / RHEL 7.4
      MariaDB 10.2.12


      Description

      When sysbench "run" executed on MaxScale host via readwritesplit port,

      sysbench failed with following error :

      sysbench 1.0.9 (using system LuaJIT 2.0.4)

      Running the test with following options:
      Number of threads: 1
      Initializing random number generator from current time

      Initializing worker threads...

      FATAL: Worker threads failed to initialize within 30 seconds!

      /var/og/maxscale/maxscale.log:

      2018-02-07 17:50:36 error : (7) [readwritesplit] Failed to execute session command in [192.168.100.12]:3306. Error was: HY000 This command is not supported in the prepared statement protocol yet
      2018-02-07 17:50:36 error : (7) [readwritesplit] Failed to execute session command in [192.168.100.11]:3306. Error was: HY000 This command is not supported in the prepared statement protocol yet

      Query Log All Filter output:

      Date,User@Host,Query
      2018-02-07 17:50:36,maxuser@::ffff:127.0.0.1,SELECT c FROM sbtest1 WHERE id=?
      2018-02-07 17:50:36,maxuser@::ffff:127.0.0.1,SELECT c FROM sbtest2 WHERE id=?
      2018-02-07 17:50:36,maxuser@::ffff:127.0.0.1,BEGIN
      2018-02-07 17:50:36,maxuser@::ffff:127.0.0.1,COMMIT

      MaxScale 2.1.13 worked with sysbench 1.0.9 w/o 2.2 specific automatic failover settings.

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            goto.satoru GOTO Satoru (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: