OpenMLDB icon indicating copy to clipboard operation
OpenMLDB copied to clipboard

Fail to run sysbench for OpenM(ysq)LDB

Open tobegit3hub opened this issue 1 year ago • 1 comments

Bug Description

Here is the error from sysbench.

Screenshot 2024-03-23 at 09 48 15

And we get the log from OpenM(ysq)LDB.

Screenshot 2024-03-23 at 09 48 38

Expected Behavior

If we can run sysbench normally, we may get the result like this.

Screenshot 2024-03-23 at 09 40 57

tobegit3hub avatar Mar 23 '24 01:03 tobegit3hub

We can connect open mysql db when executing the preparing command.

sysbench --threads=2 --time=10 --report-interval=1 oltp_common.lua --mysql-host=127.0.0.1 --mysql-port=3307 --mysql-user=root --mysql-password=root --mysql-db=test --tables=4 --table-size=100 prepare

It is expected to be failed since we do not support these create table statements.

Screenshot 2024-03-23 at 09 59 28

Here is the code of initializing work threads in https://github.com/akopytov/sysbench/blob/2ca9e3f81fa7f89203fbff44388736dd6720819c/src/sb_thread.c#L158 .

tobegit3hub avatar Mar 23 '24 02:03 tobegit3hub