(the first transaction)
RECORD LOCKS space id 0 page no`mytable` trx id 4 2719072253 lock mode S locksrec but not gapwaiting
*** (2) TRANSACTION:
TRANSACTION`mytable` trx id 4 2719072205 lo
.RECORD LOCKS space id 0 page no 436366 n bits 88 index`order` trx id 0 2799914 lock mode S locksrec but not gapwaiting
Record lock, heap no 14 PHYSICAL RECORD`order` trx id 0 2799913 lock_mode<
`id` = 530RECORD LOCKS space id 148 page no 15 n bits 96`some_table` trx id 14425003 lock_modeXlocksrec but not gapwaiting
Record lock, heap no 14 PHYSICAL`some_table` trx id 144
<fields to update>
RECORD LOCKS space id 2151 page no 709`order` trx id 413412 lock_modeXlocksrec but not gapwaiting
Record lock, heap no 3 PHYSICAL RECORD`order` trx id 41
`test/iz` trx id 0 42313619 lock_modeXlocksrec but not gapwaiting
Record lock, heap no 5 PHYSICALspace id 0 page no 16403 n bits 72 index `PRIMARY` of table `test/iz` trx id 0 42313620 lock_modeXlocks <em
LATEST DETECTED DEADLOCK2019-04-18 15:54:09 0x7f85cff7e700
UPDATE table1 SET status =1 WHERE c_Id = 24671 and d_Id =1247910
*** (1) WAITING`table1` trx id 70678199277 lock_modeXwaiting
我认为死锁与事务2的SELECT子查询有关,但我不理解以下几点:*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 27319884 page no 45175n bits 4 index `PRIMARY` of table `order` trx id 28039013420 lock_
`job_charge` trx table locks 2 total table locks 2 trx id 201694975 lock_modeXlocksrec but not gapwaiting lock hold time 1 wait time before grant 0 TRANSACTION 201691925`job_charge` trx table <e