TiUP Bench TPC-C Test Error: statement.go:54: invalid connection

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tiup bench tpcc测试报错：statement.go:54: invalid connection

| username: TiDBer_M9buM6Mw

Deploy TiDB 6.0 single node using tiup.

tiup bench tpcc -D tpcc --warehouses 3000 prepare --parts 10 --threads 15;

tiup bench tpcc -D tpcc --warehouses 3000 run --time 1200s --threads 1—runs ok, tpmc is 976.5;

tiup bench tpcc -D tpcc --warehouses 3000 run --time 1200s --threads 150—completed, tpmc is 30,000, CPU usage 47%, memory usage 75%, swap memory usage 100%. There is an error statement.go:54: invalid connection?

tiup bench tpcc -D tpcc --warehouses 3000 run --time 1200s --threads 300—completed, error:

[mysql] 2022/07/20 11:07:57 packets.go:447: busy buffer;

[mysql] 2022/07/20 11:07:57 statement.go:54: invalid connection

2
| username: songxuecheng | Original post link

Disable swap

3
| username: 长安是只喵 | Original post link

There is this check in the TiDB environment and system configuration check

image
image783×471 22.3 KB

4
| username: TiDBer_M9buM6Mw | Original post link

Swap memory is turned off, but it still doesn’t work. I saw someone raised an issue,

5
| username: 长安是只喵 | Original post link

Oh, then having issues makes it reliable.

6
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.