sysbench-tpcc
sysbench-tpcc copied to clipboard
tpcc.lua script is not terminating when it hit "Unknown storage engine" error
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>