sysbench read write with tidb_fast_ddl = on failed with dead lock

[dbsid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

run sysbench read write with tidb_fast_ddl = on for pr #35984

python3 main.py gen-benchbot-case --email "xxx --token 'xxx' --testbed_size "2xl" \
--bench_type sysbench --bench_sub_types "oltp_read_write" \
--duration=40m --threads 50,100 \
--versions nightly \
--tikv_configs "{raftstore: {store-io-pool-size: 1}, raft-engine: {enable: true}}" \
--tidb_configs '{lightning-sort-path: "/tiup/deploy"}' \
--command_delay=10m \
--commands "alter table sbtest1 add index c_idx(c)" \
--tidb_globals "set global tidb_ddl_reorg_worker_cnt=8;set global tidb_fast_ddl = off;set global tidb_ddl_reorg_batch_size=10240" \
--tidb_globals "set global tidb_ddl_reorg_worker_cnt=8;set global tidb_fast_ddl = on;set global tidb_ddl_reorg_batch_size=10240" \
--staging False \
--tidb_urls "http://fileserver.pingcap.net/download/builds/pingcap/tidb-check/pr/a67ec87a718fbd17ca0428a105d202eab41d007e/centos7/tidb-server.tar.gz"

2. What did you expect to see? (Required)

no dead lock

3. What did you see instead (Required)

[ 1800s ] thds: 200 tps: 4531.13 qps: 90586.15 (r/w/o: 63399.25/18125.13/9061.77) lat (ms,95%): 69.29 err/s: 0.00 reconn/s: 0.00
FATAL: mysql_stmt_execute() returned error 1213 (Deadlock found when trying to get lock; try restarting transaction) for query 'UPDATE sbtest27 SET c=? WHERE id=?'
FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:479: SQL error, errno = 1213, state = '40001': Deadlock found when trying to get lock; try restarting transaction

4. What is your TiDB version? (Required)

#35984