SHOW ENGINE INNODB STATUS命令 截取一些主要输出;
*** (1) TRANSACTION:
TRANSACTION 1467353, ACTIVE 328 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3
MySQL thread id 30375, OS thread handle 140085838833408, query id 4166322 10.220.10.65 root updating
update ACT_RU_EXECUTION
SET REV_ = 2
where ID_ = '483f5cb3-e2b2-11eb-9b7a-525400be79bd'
and REV_ = 1
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 264 page no 24 n bits 128 index PRIMARY of table work_flow.ACT_RU_EXECUTION trx id 1467353 lock_mode X locks rec but not gap waiting
*** (2) TRANSACTION:
TRANSACTION 1467345, ACTIVE 421 sec fetching rows
mysql tables in use 1, locked 1
22 lock struct(s), heap size 1136, 27 row lock(s), undo log entries 28
MySQL thread id 30341, OS thread handle 140085846402816, query id 4172114 localhost 127.0.0.1 root updating
delete from ACT_RU_VARIABLE where EXECUTION_ID_ = '483f5cb3-e2b2-11eb-9b7a-525400be79bd'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 264 page no 24 n bits 128 index PRIMARY of table work_flow.ACT_RU_EXECUTION trx id 1467345 lock_mode X locks rec but not gap
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 271 page no 110 n bits 272 index ACT_FK_VAR_EXE of table work_flow.ACT_RU_VARIABLE trx id 1467345 lock_mode X waiting
Record lock, heap no 115 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 34383366356362332d653262322d313165622d396237612d353235343030; asc 483f5cb3-e2b2-11eb-9b7a-525400; (total 36 bytes);
1: len 30; hex 66663361396635632d653262322d313165622d393866322d323466643532; asc ff3a9f5c-e2b2-11eb-98f2-24fd52; (total 36 bytes);
*** WE ROLL BACK TRANSACTION (1)
不知道你这个问题是否已经解决, 如果还没有解决的话: