[23.03][arm]使用sysbench创建mysql表数量超过12时，报错

【环境信息】
软件信息：
1） OS版本及分支：openEuler-23.03
2）内核信息:6.1.19-7.0.0.17.oe2303.aarch64
3）发现问题的组件版本信息:sysbench-1.0.20-3.oe2303.aarch64
如果有特殊组网，请提供网络拓扑图
【问题复现步骤】
具体操作步骤

dnf install sysbench mysql-server
systemctl status mysqld
systemctl start mysqld
systemctl status mysqld
MYSQL_USER=root
MYSQL_PWD=openEuler12#$
mysql -u${MYSQL_USER} -e "alter user ${MYSQL_USER}@'localhost' identified by '${MYSQL_PWD}';"
mysql -u${MYSQL_USER} -p${MYSQL_PWD} -e "CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '${MYSQL_PWD}';"
mysql -u${MYSQL_USER} -p${MYSQL_PWD} -e "grant all privileges on *.* to ${MYSQL_USER}@'%' with grant option;"
mysql -u${MYSQL_USER} -p${MYSQL_PWD} -e "create database test1"
sysbench /usr/share/sysbench/oltp_common.lua --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root '--mysql-password=openEuler12#$' --mysql-db=test1 --db-driver=mysql --table_size=20000 --tables=20 --threads=1 --time=20 --report-interval=20  prepare

出现概率(必现)
【预期结果】
创建table数量超过12仍可以继续创建，无报错
【实际结果】
创建table数量超过12不可以继续创建，报错
FATAL: mysql_drv_query() returned error 1050 (Table 'sbtest2' already exists) for query 'CREATE TABLE sbtest2(
id INTEGER NOT NULL AUTO_INCREMENT,
k INTEGER DEFAULT '0' NOT NULL,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) /*! ENGINE = innodb */ '
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/oltp_common.lua:197: SQL error, errno = 1050, state = '42S01': Table 'sbtest2' already exists
【附件信息】
输入图片说明

Hi ga_beng_cui, welcome to the openEuler Community.
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here.
If you have any questions, please contact the SIG: dev-utils, and any of the maintainers: @ethan848 , @yanan-rock , @Monday , @jingxiaolu , @hexiaowen , @myeuler , @love_hangzhou , @forrest_ly , @fcwicky , @caodongxia

@ga_beng_cui 请在luajit-2.1.0-5版本环境下验收。

@ga_beng_cui 请尽快回归验收

计划round5回归

使用最新版本已回归，无此问题
输入图片说明

src-openEuler / sysbench

内容风险标识

评论 (5)

src-openEuler / sysbench .gitee-modal { width: 500px !important; }

内容风险标识