【TiDB 版本】
v4.0.12
【问题描述】
tidb在做高可用测试的时候,开启一个sysbench压测,时长为1小时,运行5分钟后,一个机房的2台tikv服务器shutdown,同机房的1台pd服务器也shutdown,另一个机房的3台tikv正常运行,tidbserver也正常运行,2个pd server也正常运行,大约正常运行25分钟之后,sysbench异常退出,再重新启动sysbench,运行25分钟之后又异常退出,报错信息如下:
FATAL: mysql_drv_query() returned error 8022 (Error: KV error safe to retry Txn(Mvcc(TxnLockNotFound { start_ts: TimeStamp(425092821393866893), commit_ts: TimeStamp(425092830909693953), key: [116, 128, 0, 0, 0, 0, 0, 0, 77, 95, 114, 128, 0, 0, 0, 0, 85, 84, 112] })) {tableID=77, handle=5592176} [try again later]) for query ‘COMMIT’
FATAL: thread_run' function failed: /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua:110: db_query() failed [ 1520s ] thds: 199 tps: 54.80 qps: 800.00 (r/w/o: 530.80/188.20/81.00) lat (ms,95%): 25911.33 err/s: 0.20 reconn/s: 0.00 [ 1525s ] thds: 199 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00 FATAL: mysql_drv_query() returned error 1105 (tikv aborts txn: Txn(Mvcc(PessimisticLockNotFound { start_ts: TimeStamp(425092821393866857), key: [116, 128, 0, 0, 0, 0, 0, 0, 80, 95, 114, 128, 0, 0, 0, 0, 80, 146, 109] }))) for query 'COMMIT' FATAL:thread_run’ function failed: /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua:110: db_query() failed
Error in my_thread_global_end(): 2 threads didn’t exit
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。
墨值悬赏

评论
