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

LP:429773 - mysqlslap: specifying --engine and --create does not work with --engine=<storage_engine>:<option>

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      How to repeat:

      1) <option> is missing and does not work with replication
      mysqlslap \
      --delimiter=";" \
      --create="CREATE TABLE A (a int);INSERT INTO A Values (23)" \
      --query="SELECT * FROM A" \
      --concurrency=1 \
      --iterations=1 \
      --engine=memory:max_rows=200 \
      -vvvvv \
      --post-system="echo SHOW CREATE TABLE A | mysql -uroot mysqlslap"

      ...
      set storage_engine=`memory`;
      CREATE TABLE A (a int);
      INSERT INTO A Values (23);
      Generating primary key list
      connected!
      SELECT * FROM A;
      Table Create Table
      A CREATE TABLE `A` (\n `a` int(11) DEFAULT NULL\n) ENGINE=MEMORY DEFAULT CHARSET=latin1
      Generating stats
      Benchmark
      Running for engine memory
      Average number of seconds to run all queries: 0.060 seconds
      Minimum number of seconds to run all queries: 0.060 seconds
      Maximum number of seconds to run all queries: 0.060 seconds
      Number of clients running queries: 1
      Average number of queries per client: 1

      DROP SCHEMA IF EXISTS `mysqlslap`;

      2) Crashing
      mysqlslap \
      --delimiter=";" \
      --create="CREATE TABLE A (a int);INSERT INTO A Values (23)" \
      --query="SELECT * FROM A" \
      --concurrency=1 \
      --iterations=1 \
      --engine=memory:max_rows=200,innodb, myisam \
      -vvvvv \
      --post-system="echo SHOW CREATE TABLE A | mysql -uroot mysqlslap"

      ...
      Parsing engines to use.
      Segmentation fault

      Both bugs are connected to an unintialized buffer usage.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hakanküçükyılmaz Hakan Küçükyılmaz (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.