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>

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 429773

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 429773

              People

              • Assignee:
                Unassigned
                Reporter:
                hakanküçükyılmaz Hakan Küçükyılmaz
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: