run oltp_write_only failed due to PessimisticLockNotFound

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
- run sysbench oltp_write_only
```
sysbench --db-driver=mysql --mysql-host=upstream-tidb.cdc-testbed-tps-1302043-1-45 --mysql-port=4000 --mysql-user=root --mysql-db=workload --tables=200 --table-size=10000000 --create_secondary=off --time=7200 --threads=200 oltp_write_only prepare
sysbench --db-driver=mysql --mysql-host=upstream-tidb.cdc-testbed-tps-1302043-1-45 --mysql-port=4000 --mysql-user=root --mysql-db=workload --tables=200 --table-size=10000000 --create_secondary=off --time=7200 --threads=200 oltp_write_only run
```

### 2. What did you expect to see? (Required)
run workload correctly

### 3. What did you see instead (Required)
```
stdout="sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)\n\nRunning the test with following options:\nNumber of threads: 200\nInitializing random number generator from current time\n\n\nInitializing worker threads...\n\nThreads started!\n\nFATAL: mysql_stmt_execute() returned error 1105 (tikv aborts txn: Error(Txn(Error(Mvcc(Error(PessimisticLockNotFound { start_ts: TimeStamp(436993815183360237), key: [116, 128, 0, 0, 0, 0, 0, 0, 210, 95, 114, 128, 0, 0, 0, 0, 76, 69, 91] })))))) for query 'COMMIT'\nFATAL
```

### 4. What is your TiDB version? (Required)
["Release Version"=v6.4.0-alpha] [Edition=Community] ["Git Commit Hash"=e415cfa5f4f257d8d8fab31627a377d5f818dc2a] ["Git Branch"=heads/refs/tags/v6.4.0-alpha] ["UTC Build Time"="2022-10-28 11:09:37"]