v7.5.7集群抖动

🪐 TiDB 技术问题
4

由于业务逻辑，所有的DML操作都是显示事务。但出现执行耗时较长的DML时，提示有大量的锁。

img_v3_02qe_b20e7b9c-ece3-480e-9296-4dd75f40687g
img_v3_02qe_b20e7b9c-ece3-480e-9296-4dd75f40687g1216×678 111 KB

img_v3_02qe_a9818e73-0b45-45ff-8afc-e69011a668bg
img_v3_02qe_a9818e73-0b45-45ff-8afc-e69011a668bg1403×755 73.9 KB

tidb server节点日志

[2025/09/24 14:40:34.996 +08:00] [INFO] [prewrite.go:444] ["prewrite encounters lock"] [session=3971944250] [txnID=461031613395894546] [lock="key: 7480000000000000485F728000000097457EF7, primary: 7480000000000000485F698000000000000001013131303138323534FF3934303232363239FF3636000000000000F9, txnStartTS: 461031613395894545, lockForUpdateTS:461031613395894545, minCommitTs:461031613395894546, ttl: 20000, type: PessimisticLock, UseAsyncCommit: false, txnSize: 0"]
[2025/09/24 14:40:35.084 +08:00] [INFO] [prewrite.go:444] ["prewrite encounters lock"] [session=3971944250] [txnID=461031613395894546] [lock="key: 7480000000000000485F728000000097457EF7, primary: 7480000000000000485F698000000000000001013131303138323534FF3934303232363239FF3636000000000000F9, txnStartTS: 461031613395894545, lockForUpdateTS:461031613395894545, minCommitTs:461031613395894574, ttl: 20000, type: Put, UseAsyncCommit: true, txnSize: 1"]
[2025/09/24 14:40:35.278 +08:00] [INFO] [prewrite.go:444] ["prewrite encounters lock"] [session=3971944250] [txnID=461031613395894546] [lock="key: 7480000000000000485F728000000097457EF7, primary: 7480000000000000485F698000000000000001013131303138323534FF3934303232363239FF3636000000000000F9, txnStartTS: 461031613395894545, lockForUpdateTS:461031613395894545, minCommitTs:461031613395894574, ttl: 20000, type: Put, UseAsyncCommit: true, txnSize: 1"]
[2025/09/24 14:40:35.555 +08:00] [INFO] [prewrite.go:444] ["prewrite encounters lock"] [session=3971944250] [txnID=461031613395894546] [lock="key: 7480000000000000485F728000000097457EF7, primary: 7480000000000000485F698000000000000001013131303138323534FF3934303232363239FF3636000000000000F9, txnStartTS: 461031613395894545, lockForUpdateTS:461031613395894545, minCommitTs:461031613395894574, ttl: 20000, type: Put, UseAsyncCommit: true, txnSize: 1"]
[2025/09/24 14:40:36.265 +08:00] [INFO] [prewrite.go:444] ["prewrite encounters lock"] [session=3971944250] [txnID=461031613395894546] [lock="key: 7480000000000000485F728000000097457EF7, primary: 7480000000000000485F698000000000000001013131303138323534FF3934303232363239FF3636000000000000F9, txnStartTS: 461031613395894545, lockForUpdateTS:461031613395894545, minCommitTs:461031613395894574, ttl: 20000, type: Put, UseAsyncCommit: true, txnSize: 1"]
[2025/09/24 14:40:37.810 +08:00] [INFO] [prewrite.go:444] ["prewrite encounters lock"] [session=3971944250] [txnID=461031613395894546] [lock="key: 7480000000000000485F728000000097457EF7, primary: 7480000000000000485F698000000000000001013131303138323534FF3934303232363239FF3636000000000000F9, txnStartTS: 461031613395894545, lockForUpdateTS:461031613395894545, minCommitTs:461031613395894574, ttl: 20000, type: Put, UseAsyncCommit: true, txnSize: 1"]
1 个赞