Pessimistic lock not found when adding index

[tangenta]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

It happens occasionally on realtikvtest/addindextest of check_dev_2.

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_check2/detail/ghpr_check2/14284/pipeline/231/

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

No error.

3. What did you see instead (Required)

[2023/02/16 00:56:54.698 +08:00] [WARN] [session.go:1019] ["commit failed"] ["finished txn"="Txn{state=invalid}"] [error="tikv aborts txn: Error(Txn(Error(Mvcc(Error(PessimisticLockNotFound { start_ts: TimeStamp(439479229396549638), key: [116, 128, 0, 0, 0, 0, 0, 0, 162, 95, 105, 255, 255, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 3] })))))"] [errorVerbose="tikv aborts txn: Error(Txn(Error(Mvcc(Error(PessimisticLockNotFound { start_ts: TimeStamp(439479229396549638), key: [116, 128, 0, 0, 0, 0, 0, 0, 162, 95, 105, 255, 255, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 3] })))))\ngithub.jparrowsec.cn/tikv/client-go/v2/error.ExtractKeyErr\n\texternal/com_github_tikv_client_go_v2/error/error.go:301\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/txnlock.ExtractLockFromKeyErr\n\texternal/com_github_tikv_client_go_v2/txnkv/txnlock/lock.go:27\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.actionPrewrite.handleSingleBatch\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/prewrite.go:387\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).doActionOnBatches\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/2pc.go:1037\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).doActionOnGroupMutations\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/2pc.go:1018\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).doActionOnMutations\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/2pc.go:788\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).prewriteMutations\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/prewrite.go:439\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).execute\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/2pc.go:1482\ngithub.jparrowsec.cn/tikv/client-go/v2/txnkv/transaction.(*KVTxn).Commit\n\texternal/com_github_tikv_client_go_v2/txnkv/transaction/txn.go:496\ngithub.jparrowsec.cn/pingcap/tidb/store/driver/txn.(*tikvTxn).Commit\n\tstore/driver/txn/txn_driver.go:95\ngithub.jparrowsec.cn/pingcap/tidb/session.(*LazyTxn).Commit\n\tsession/txn.go:425\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).commitTxnWithTemporaryData\n\tsession/session.go:843\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).doCommit\n\tsession/session.go:729\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).retry\n\tsession/session.go:1300\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).doCommitWithRetry\n\tsession/session.go:1001\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).CommitTxn\n\tsession/session.go:1104\ngithub.jparrowsec.cn/pingcap/tidb/session.autoCommitAfterStmt\n\tsession/tidb.go:295\ngithub.jparrowsec.cn/pingcap/tidb/session.finishStmt\n\tsession/tidb.go:257\ngithub.jparrowsec.cn/pingcap/tidb/session.runStmt\n\tsession/session.go:2380\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).ExecuteStmt\n\tsession/session.go:2218\ngithub.jparrowsec.cn/pingcap/tidb/testkit.(*TestKit).ExecWithContext\n\ttestkit/testkit.go:323\ngithub.jparrowsec.cn/pingcap/tidb/testkit.(*TestKit).Exec\n\ttestkit/testkit.go:296\ngithub.jparrowsec.cn/pingcap/tidb/tests/realtikvtest/addindextest.updateWorker\n\ttests/realtikvtest/addindextest/workload.go:211\ngithub.jparrowsec.cn/pingcap/tidb/tests/realtikvtest/addindextest.(*worker).run\n\ttests/realtikvtest/addindextest/workload.go:104\nruntime.goexit\n\tGOROOT/src/runtime/asm_amd64.s:1594\ngithub.jparrowsec.cn/pingcap/errors.AddStack\n\texternal/com_github_pingcap_errors/errors.go:174\ngithub.jparrowsec.cn/pingcap/errors.Trace\n\texternal/com_github_pingcap_errors/juju_adaptor.go:15\ngithub.jparrowsec.cn/pingcap/tidb/store/driver/error.ToTiDBErr\n\tstore/driver/error/error.go:166\ngithub.jparrowsec.cn/pingcap/tidb/store/driver/txn.extractKeyErr\n\tstore/driver/txn/error.go:162\ngithub.jparrowsec.cn/pingcap/tidb/store/driver/txn.(*tikvTxn).extractKeyErr\n\tstore/driver/txn/txn_driver.go:310\ngithub.jparrowsec.cn/pingcap/tidb/store/driver/txn.(*tikvTxn).Commit\n\tstore/driver/txn/txn_driver.go:96\ngithub.jparrowsec.cn/pingcap/tidb/session.(*LazyTxn).Commit\n\tsession/txn.go:425\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).commitTxnWithTemporaryData\n\tsession/session.go:843\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).doCommit\n\tsession/session.go:729\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).retry\n\tsession/session.go:1300\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).doCommitWithRetry\n\tsession/session.go:1001\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).CommitTxn\n\tsession/session.go:1104\ngithub.jparrowsec.cn/pingcap/tidb/session.autoCommitAfterStmt\n\tsession/tidb.go:295\ngithub.jparrowsec.cn/pingcap/tidb/session.finishStmt\n\tsession/tidb.go:257\ngithub.jparrowsec.cn/pingcap/tidb/session.runStmt\n\tsession/session.go:2380\ngithub.jparrowsec.cn/pingcap/tidb/session.(*session).ExecuteStmt\n\tsession/session.go:2218\ngithub.jparrowsec.cn/pingcap/tidb/testkit.(*TestKit).ExecWithContext\n\ttestkit/testkit.go:323\ngithub.jparrowsec.cn/pingcap/tidb/testkit.(*TestKit).Exec\n\ttestkit/testkit.go:296\ngithub.jparrowsec.cn/pingcap/tidb/tests/realtikvtest/addindextest.updateWorker\n\ttests/realtikvtest/addindextest/workload.go:211\ngithub.jparrowsec.cn/pingcap/tidb/tests/realtikvtest/addindextest.(*worker).run\n\ttests/realtikvtest/addindextest/workload.go:104\nruntime.goexit\n\tGOROOT/src/runtime/asm_amd64.s:1594"]

4. What is your TiDB version? (Required)

d0919b9