[Bug]: Using mo-sysbench tool to insert data report 'error 20101: internal error: no available CN server.'

Ariznawlll commented 11 months ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Branch Name

8.0.30-MatrixOne-v1.0.2

Commit ID

8.0.30-MatrixOne-v1.0.2

Other Environment Information

- Hardware parameters: 
实例id：d6e01a68-63bc-4b69-ad5f-c78f565e46ec （qa环境）
- OS type:
- Others:

Actual Behavior

版本：

mysql客户端连接方式：mysql -h freetier-01.cn-hangzhou.cluster.cn-qa.matrixone.tech -P 6001 -u d6e01a68_63bc_4b69_ad5f_c78f565e46ec:admin:accountadmin -p

使用mo-sysbench工具向数据库sysbench_db建表插入数据报错（不稳定出现）：

Expected Behavior

No response

Steps to Reproduce

129上：
cd /root/weilu/mo-sysbench

sysbench  --mysql-host=freetier-01.cn-hangzhou.cluster.cn-qa.matrixone.tech --mysql-port=6001 --mysql-user=d6e01a68_63bc_4b69_ad5f_c78f565e46ec:admin:accountadmin --mysql-password=Adm in123 oltp_point_select.lua --mysql-db=sysbench_db --tables=10 --table_size=1000000 --threads=1000 --time=30 --report-interval=10 --create_secondary=off  --auto_inc=off cleanup

sysbench  --mysql-host=freetier-01.cn-hangzhou.cluster.cn-qa.matrixone.tech --mysql-port=6001 --mysql-user=d6e01a68_63bc_4b69_ad5f_c78f565e46ec:admin:accountadmin --mysql-password=Adm in123 oltp_point_select.lua --mysql-db=sysbench_db --tables=10 --table_size=1000000 --threads=1000 --time=30 --report-interval=10 --create_secondary=off  --auto_inc=off prepare

Additional information

No response

aressu1985 commented 11 months ago

PR 已经进了1.1,1.1稳定性在观察几天

volgariver6 commented 11 months ago

pr merged.