一直报锁 怎么查是哪个表锁住了

🪐 TiDB 技术问题
1

【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【遇到的问题】
【复现路径】做过哪些操作出现的问题
【问题现象及影响】
prewrite.rs:600] [“commit_ts is too large, fallback to normal 2PC”] [lock=“Lock { lock_type: Put, primary_key: 7480000000000028F55F6980000000000000010419AE3076660000000395FD153D69087000, start_ts: TimeStamp(436888237715488841), ttl: 3000, short_value: 8000040000000203040508001A0022002A004554432D55534454201080000000000000161AD2748000000000000000667630AE19000000857630AE19, for_update_ts: TimeStamp(0), txn_size: 1, min_commit_ts: TimeStamp(436888237715488842), use_async_commit: true, secondaries: , rollback_ts: }”] [max_commit_ts=436888238239776841] [min_commit_ts=436888239904391181] [start_ts=436888237715488841] [key=7480000000000028FFF55F7295FD153D69FF0870000000000000FA]

2022-10-24 15:26:15 (GMT+8)TiKV 172.31.177.79:20160[endpoint.rs:621] [error-response] [err=“Key is locked (will clean up) primary_lock: 748000000000001F175F69800000000000000103800000003C2D3528038000000000031192 lock_version: 436888227006906385 key: 748000000000001F175F69800000000000000103800000003C2D3528038000000000031192 lock_ttl: 70000 txn_size: 12 lock_for_update_ts: 436888230807994456 use_async_commit: true min_commit_ts: 436888235067834489 secondaries: 748000000000001F175F69800000000000000103800000003C2D352803800000000003157A secondaries: 748000000000001F175F69800000000000000103800000003C2D35280380000000001EAFB7 secondaries: 748000000000001F175F69800000000000000103800000003C2D35280380000000001ED6C7 secondaries: 748000000000001F175F6980000000000000030419AE3075D80000000380000000490B40F6 secondaries: 748000000000001F175F6980000000000000030419AE3075D80000000380000000490B40F8 secondaries: 748000000000001F175F6980000000000000030419AE30765B0000000380000000490B40F7 secondaries: 748000000000001F175F6980000000000000030419AE30765B0000000380000000490B40F9 secondaries: 748000000000001F175F6980000000000000030419AE3076680000000380000000490B40F6 secondaries: 748000000000001F175F6980000000000000030419AE3076680000000380000000490B40F7 secondaries: 748000000000001F175F6980000000000000030419AE3076680000000380000000490B40F8 secondaries: 748000000000001F175F6980000000000000030419AE3076680000000380000000490B40F9 secondaries: 748000000000001F175F7280000000490B40F6 secondaries: 748000000000001F175F7280000000490B40F7 secondaries: 748000000000001F175F7280000000490B40F8 secondaries: 748000000000001F175F7280000000490B40F9 secondaries: 74800000000000221C5F69800000000000000103800000003C2D35280395FD153EE9D91000 secondaries: 74800000000000221C5F69800000000000000103800000003C2D35280395FD1549B4D91000 secondaries: 74800000000000221C5F6980000000000000020395FD153EE15910000395FD153EE9D91000 secondaries: 74800000000000221C5F6980000000000000020395FD153EE15910000395FD1549B4D91000 secondaries: 74800000000000221C5F7295FD153EE9D91000 secondaries: 74800000000000221C5F7295FD1549B4D91000 secondaries: 7480000000000023495F69800000000000000103800000003C2D35280380000000001ED6C70395FD153EE1591000 secondaries: 7480000000000023495F6980000000000000020419AE3076680000000395FD153EE1591000 secondaries: 7480000000000023495F69800000000000000303800000003C2D3528016372656174655F6FFF7264657200000000FB0395FD153EE1591000 secondaries: 7480000000000023495F69800000000000000403800000003C2D352803800000003C2D3528016372656174655F6FFF7264657200000000FB0380000000001EAFB70380000000001ED6C70395FD153EE1591000 secondaries: 7480000000000023495F69800000000000000503800000003C2D35280380000000001EAFB70380000000001ED6C70395FD153EE1591000 secondaries: 7480000000000023495F69800000000000000603800000003C2D3528016372656174655F6FFF7264657200000000FB0380000000001EAFB70380000000001ED6C70395FD153EE1591000 secondaries: 7480000000000023495F698000000000000007016372656174655F6FFF7264657200000000FB0419AE3076680000000395FD153EE1591000 secondaries: 7480000000000023495F698000000000000008016372656174655F6FFF7264657200000000FB0395FD153EE1591000 secondaries: 7480000000000023495F698000000000000009016372656174655F6FFF7264657200000000FB03800000003C2D352803800000003C2D35280395FD153EE1591000 secondaries: 7480000000000023495F7295FD153EE1591000 secondaries: 7480000000000030365F69800000000000000104000000003C2D35280395FD1530A9191000 secondaries: 7480000000000030365F6980000000000000020419AE3076670000000395FD1530A9191000 secondaries: 7480000000000030365F6980000000000000030419AE3076590000000400000000000000010395FD1530A9191000 secondaries: 7480000000000030365F6980000000000000040400000000000000010395FD1530A9191000 secondaries: 7480000000000030365F6980000000000000050419AE3076590000000395FD1530A9191000 secondaries: 7480000000000030365F6980000000000000060400000000000000010400000000000000020400000000000000010395FD1530A9191000 secondaries: 7480000000000030365F69800000000000000704000000003C2D35280400000000000000010395FD1530A9191000 secondaries: 7480000000000030365F7295FD1530A9191000 secondaries: 7480000000000031995F6980000000000000010395FD153EDF99100004000000000000000A secondaries: 7480000000000031995F6980000000000000020395FD1530A9191000010E4A0EFB0E4A101FFF0FEA0E6D10020000FD04000000000000000A secondaries: 7480000000000031995F6980000000000000040400000000000000010380000000001C0120 secondaries: 7480000000000031995F69800000000000000504000000003C2D35280380000000001C0120 secondaries: 7480000000000031995F69800000000000000604000000000000000104000000003C2D35280380000000001C0120 secondaries: 7480000000000031995F7280000000001C0120”]

【附件】

请提供各个组件的 version 信息，如 cdc/tikv，可通过执行 cdc version/tikv-server --version 获取。

2

select tidb_decode_key(‘7480000000000028F55F6980000000000000010419AE3076660000000395FD153D69087000’); 获取table_id

3

自问自答
MySQL [information_schema]> select * from tables where TIDB_TABLE_ID=10485; 查出后
用tableid去查具体的表名然后扔给开发解决

4

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。