LATEST DETECTED DEADLOCK
2018-06-03 05:02:31 7fb11947f700
(1) TRANSACTION:
TRANSACTION 2525598058, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 68859, OS thread handle 0x7fb1181ee700, query id 2012827323 192.168.150.165 lts updating
UPDATE lts_wjq_job_group_comb SET is_running = 1 ,task_tracker_identity = ''TT_192.168.150.189_2522_15-25-01.386_1'' ,gmt_modified = 1527973351102 WHERE job_id = ''7002FD25C4334BB7AC9B6751B3F388D0'' AND is_running = 0 AND trigger_time = 1527973350000 AND gmt_modified = 1527973346248
(1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1749 page no 4 n bits 80 index idx_job_id of table lts-dev.lts_wjq_job_group_comb trx id 2525598058 lock_mode X waiting
Record lock, heap no 9
(2) TRANSACTION:
TRANSACTION 2525598057, ACTIVE 0 sec starting index read, thread declared inside InnoDB 1
mysql tables in use 1, locked 1
3 lock struct(s), heap size 360, 2 row lock(s)
MySQL thread id 68271, OS thread handle 0x7fb11947f700, query id 2012827320 192.168.150.165 lts updating
UPDATE lts_wjq_job_group_comb SET is_running = 1 ,task_tracker_identity = ''TT_192.168.110.172_15654_14-50-55.546_1'' ,gmt_modified = 1527973351102 WHERE job_id = ''7002FD25C4334BB7AC9B6751B3F388D0'' AND is_running = 0 AND trigger_time = 1527973350000 AND gmt_modified = 1527973346248
(2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1749 page no 4 n bits 80 index idx_job_id of table lts-dev.lts_wjq_job_group_comb trx id 2525598057 lock_mode X locks rec but not gap
Record lock, heap no 9
(2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1749 page no 4 n bits 80 index idx_job_id of table lts-dev.lts_wjq_job_group_comb trx id 2525598057 lock_mode X waiting
Record lock, heap no 9
WE ROLL BACK TRANSACTION (1)
chenws1012
commented
5 years ago
Mysql Inodb 状态日志如下
LATEST DETECTED DEADLOCK 2018-06-03 05:02:31 7fb11947f700 (1) TRANSACTION: TRANSACTION 2525598058, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 68859, OS thread handle 0x7fb1181ee700, query id 2012827323 192.168.150.165 lts updating UPDATE
lts_wjq_job_group_combSETis_running= 1 ,task_tracker_identity= ''TT_192.168.150.189_2522_15-25-01.386_1'' ,gmt_modified= 1527973351102 WHERE job_id = ''7002FD25C4334BB7AC9B6751B3F388D0'' AND is_running = 0 AND trigger_time = 1527973350000 AND gmt_modified = 1527973346248 (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1749 page no 4 n bits 80 indexidx_job_idof tablelts-dev.lts_wjq_job_group_combtrx id 2525598058 lock_mode X waiting Record lock, heap no 9 (2) TRANSACTION: TRANSACTION 2525598057, ACTIVE 0 sec starting index read, thread declared inside InnoDB 1 mysql tables in use 1, locked 1 3 lock struct(s), heap size 360, 2 row lock(s) MySQL thread id 68271, OS thread handle 0x7fb11947f700, query id 2012827320 192.168.150.165 lts updating UPDATElts_wjq_job_group_combSETis_running= 1 ,task_tracker_identity= ''TT_192.168.110.172_15654_14-50-55.546_1'' ,gmt_modified= 1527973351102 WHERE job_id = ''7002FD25C4334BB7AC9B6751B3F388D0'' AND is_running = 0 AND trigger_time = 1527973350000 AND gmt_modified = 1527973346248 (2) HOLDS THE LOCK(S): RECORD LOCKS space id 1749 page no 4 n bits 80 indexidx_job_idof tablelts-dev.lts_wjq_job_group_combtrx id 2525598057 lock_mode X locks rec but not gap Record lock, heap no 9 (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1749 page no 4 n bits 80 indexidx_job_idof tablelts-dev.lts_wjq_job_group_combtrx id 2525598057 lock_mode X waiting Record lock, heap no 9 WE ROLL BACK TRANSACTION (1)