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
死锁发生后立即来自"innodb status“报告的文本:------------------------*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1898595 page no 25610 n bits`payments` trx id 153838477815 lock_modeX
INTO shipping .....RECORD LOCKS space id 0 page no 436366`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_mod
, query id 59842286726 172.31.7.116 lc update(LineItemGUID, GuestCheckID, PrimaryIdentifier`lineitem` trx id 3087948068 lock_modeXlocksgapbeforerecinsertintentionwaiting
Record loc
`queue_messages` trx table locks 1 total table locks 4 trx id 3923289 lock mode S waiting lock hold`queue_messages` trx table locks 2 total table locks 4 trx id 3923243 lock_modeXlocksrec but notgap lock h
我不知道如何解决这个问题,因为这个查询是为了处理当2+不同的玩家(或相同的2+时间)执行Insert查询时可能出现的竞争条件。SELECT seat_number FROM app_tables_players WHERE game_id = a.id) ORDER BY a.id ASC LIMIT 1
RECORD LOCKS space id 75 page no 51 n bits 1120 index seat_number_game_id`
, query id 4713227035 localhost root update*** (1) WAITING FOR`tblFoo` trx id 32A3E743A lock_modeXlocksgapbeforerecinsertintentionwaiting
Record lock, h
TABLE_A" trx table locks 1 total table locks 1 trx id 233958942 lock_modeXlocksrec but not gap lockTABLE_A" trx table locks 1 total table locks 1 trx id 233958942 lock_modeXlocks</
, query id 56392293629 localhost user update(`column_1`, `column_2`,`myTable` trx id 55665288601 lock mode S locksrec but not gapwaitingTRANSACTION, query id 56392293627 localhost user update
IN
我有一个交易(RC):delete from foo where name = "abc";---------------------------------------------------------------------
Step 3 | insert我想,事务A运行"delete“语句时,它已经获得了记录"abc”的X</e