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

sysbench failed to initialize w/ MaxScale read/write splitter

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 2.2.1
    • 2.2.2
    • readwritesplit
    • None
    • 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

            markus makela markus makela
            goto.satoru GOTO Satoru (Inactive)
            Votes:
            0 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.