function failed: ./tpcc_common.lua:526: db_bulk_insert_next() failed about sysbench-tpcc

[seungwonlee0603]

did you resolve this?

[sunneepark]

@ingardm

I’m experiencing the same issue

My solution is changing command options ‘—time’ value
like from --time=300 to --time=1000

This error happens “db connection closed" still waiting many queries.

So, we could deal with enough total execution time through command option ‘time’ or

being sufficient for the data transfer to complete queries through server system variables. This is reference about server system variables.
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html

Also,
FATAL: thread_run' function failed: ./tpcc_run.lua:115: attempt to perform arithmetic on local 'd_next_o_id' (a nil value) ALERT: attempt to fetch row from an empty result set FATAL:

happens when data is not loaded properly. because It says “empty set”. There are no records that match SELECT clause.

So, definitely finish the previous step “prepare data and table” without any error message. Then, it will be fine :)

[seungwonlee0603]

yeah, if anyone is having this issue, make sure your command options are as same as the prepare stage, and set the time big enough.

[littlexsparkee]

@seungwonlee0603
Why is the time parameter relevant to receiving an error or not? Maybe I'm missing something but I'd expect any length of time to work

[vadimtk]

I just faced this error myself.
The reason was long running transactions, it should be fixed by setting con:query("SET autocommit=1") when loading data