Percona-Lab / sysbench-tpcc

Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL
Apache License 2.0
292 stars 104 forks source link

tpcc.lua script is not terminating when it hit "Unknown storage engine" error #5

Open rameshvs02 opened 6 years ago

rameshvs02 commented 6 years ago

tpcc.lua script is not terminating when it hit Unknown storage engine error. It also open blank sessions in mysql server

[vagrant@pgsql ~]$ /usr/share/sysbench/tpcc.lua --mysql-user=root --mysql-db=test --time=30 --threads=64 --report-interval=1 --tables=2 --scale=10 --use_fk=0 --mysql_storage_engine=rocksdb --db-driver=mysql prepare
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)

Initializing worker threads...

Creating tables: 2

Creating tables: 1

FATAL: mysql_drv_query() returned error 1286 (Unknown storage engine 'rocksdb') for query '     CREATE TABLE IF NOT EXISTS warehouse1 (
        w_id smallint not null,
        w_name varchar(10),
        w_street_1 varchar(20),
        w_street_2 varchar(20),
        w_city varchar(20),
        w_state char(2),
        w_zip char(9),
        w_tax decimal(4,2),
        w_ytd decimal(12,2),
        primary key (w_id)
        ) /*! ENGINE = rocksdb */ '
FATAL: mysql_drv_query() returned error 1286 (Unknown storage engine 'rocksdb') for query '     CREATE TABLE IF NOT EXISTS warehouse2 (
        w_id smallint not null,
        w_name varchar(10),
        w_street_1 varchar(20),
        w_street_2 varchar(20),
        w_city varchar(20),
        w_state char(2),
        w_zip char(9),
        w_tax decimal(4,2),
        w_ytd decimal(12,2),
        primary key (w_id)
        ) /*! ENGINE = rocksdb */ '
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/tpcc_common.lua:140: SQL error, errno = 1286, state = '42000': Unknown storage engine 'rocksdb'

^C^C^C^C

^C

MySQL processlist.

mysql> show full processlist;
+-----+------+-----------+------+---------+------+----------+-----------------------+-----------+---------------+
| Id  | User | Host      | db   | Command | Time | State    | Info                  | Rows_sent | Rows_examined |
+-----+------+-----------+------+---------+------+----------+-----------------------+-----------+---------------+
| 204 | root | localhost | test | Sleep   |    1 |          | NULL                  |         0 |             0 |
| 206 | root | localhost | test | Sleep   |    1 |          | NULL                  |         0 |             0 |
[..]
| 267 | root | localhost | test | Sleep   |    1 |          | NULL                  |         0 |             0 |
| 268 | root | localhost | NULL | Query   |    0 | starting | show full processlist |         0 |             0 |
+-----+------+-----------+------+---------+------+----------+-----------------------+-----------+---------------+
63 rows in set (0.00 sec)

mysql>