Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11977

Sysbench with old cnf can produce error on sql thread

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.2(EOL)
    • 10.2.2
    • Replication
    • None
    • OSX last git clone

    Description

      replication-manager have a sybench wrapper test that drop table inside test and run following command , log is reversed; last command is head

      2017-02-02 13:27:53 [Cluster01] BENCHMARK : sysbench 0.4.12: multi-threaded system evaluation benchmark

      No DB drivers specified, using mysql
      Running the test with following options:
      Number of threads: 4

      Doing OLTP test.
      Running mixed OLTP test
      Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
      Using "BEGIN" for starting transactions
      Using auto_inc on the id column
      Threads started!
      Time limit exceeded, exiting...
      (last message repeated 3 times)
      Done.

      OLTP test statistics:
      queries performed:
      read: 33404
      write: 11925
      other: 4770
      total: 50099
      transactions: 2384 (39.72 per sec.)
      deadlocks: 2 (0.03 per sec.)
      read/write requests: 45329 (755.15 per sec.)
      other operations: 4770 (79.47 per sec.)

      Test execution summary:
      total time: 60.0261s
      total number of events: 2384
      total time taken by event execution: 240.0176
      per-request statistics:
      min: 37.33ms
      avg: 100.68ms
      max: 204.63ms
      approx. 95 percentile: 138.46ms

      Threads fairness:
      events (avg/stddev): 596.0000/1.58
      execution time (avg/stddev): 60.0044/0.01

      2017-02-02 13:26:53 [Cluster01] BENCHMARK : /usr/local/bin/sysbench -test=oltp --oltp-table-size=10000 --mysql-db=test --mysql-user=skysql --mysql-password=skyvodka --mysql-host=127.0.0.1 --mysql-port=3301 --max-time=60-oltp-test-mode=complex --max-requests=0 --num-threads=4 run
      2017-02-02 13:26:53 [Cluster01] BENCHMARK : sysbench 0.4.12: multi-threaded system evaluation benchmark

      No DB drivers specified, using mysql
      Creating table 'sbtest'...
      Creating 10000 records in table 'sbtest'...
      2017-02-02 13:26:51 [Cluster01] BENCHMARK : /usr/local/bin/sysbench --test=oltp --oltp-table-size=10000 --mysql-db=test --mysql-user=skysql --mysql-password=skyvodka --mysql-host=127.0.0.1 --mysql-port=3301 --max-time=60 --oltp-test-mode=complex --max-requests=0 --num-threads=4 prepare
      2017-02-02 13:26:51 [Cluster01] BENCHMARK : sysbench 0.4.12: multi-threaded system evaluation benchmark

      sysbench 0.4.12

      Master Conf is:
      http://pastebin.com/eYb6LuL1

      Slave Conf is
      http://pastebin.com/7MLDMiG0

      Replication stopped on

      Column 2 of table 'test.sbtest' cannot be converted from type 'char(40)' to type 'char(120)'

      extract of relay log
      http://pastebin.com/dDwhTyeH

      both DDL are the same on master and slave

      CREATE TABLE `sbtest` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `k` int(10) unsigned NOT NULL DEFAULT '0',
      `c` char(120) NOT NULL DEFAULT '',
      `pad` char(60) NOT NULL DEFAULT '',
      PRIMARY KEY (`id`),
      KEY `k` (`k`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8

      Attachments

        Activity

          People

            Unassigned Unassigned
            stephane@skysql.com VAROQUI Stephane
            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.