Getting FATAL: `thread_init' function failed: /usr/share/sysbench/oltp_common.lua:275: SQL API error

[ryazdani-sita]

Hi,
I am trying to run sysbench on MariaDB 10.6 that is on Ubuntu 20.04, to test oltp_read_write and this is what I get:

sysbench oltp_read_write --time=10 --db-driver=mysql --mysql-user=root --mysql-db=sbtest --threads=16 --report-interval=1 --rate=1000 run
sysbench 1.0.18 (using system LuaJIT 2.1.0-beta3)

Running the test with following options:
Number of threads: 16
Target transaction rate: 1000/sec
Report intermediate results every 1 second(s)
Initializing random number generator from current time

Initializing worker threads...

FATAL: mysql_stmt_prepare() failed
FATAL: MySQL error: 1064 "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1"
FATAL: `thread_init' function failed: /usr/share/sysbench/oltp_common.lua:275: SQL API error
FATAL: mysql_stmt_prepare() failed
....
....

We had the same test done 2 years ago on lower versions of MariaDB with no issues and was wondering is this is a incompatibility issue.

Any help is greatly appreciated.

Best regards,
Roya