Description:
transaction 1,dead lock log incomplete;
------------------------
2017-08-09 09:10:53 7f9d6c781700
*** (1) TRANSACTION:
TRANSACTION 37474688446, ACTIVE 0 sec starting index read
mysql tables in use 3, locked 3
LOCK WAIT 4 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 1
MySQL thread id 672884, ....
update a
set last_updated = now(),root_id = id
where order_no = 'eee'
and last_updated = '2017-08-09 09:10:53'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 454569 page no 5589 n bits 744 index `idx_last_updated` of table `xxx`.`a` trx id 37474688446 lock_mode X waiting
*** (2) TRANSACTION:
TRANSACTION 37474688445, ACTIVE 0 sec starting index read, thread declared inside InnoDB 4999
mysql tables in use 3, locked 3
5 lock struct(s), heap size 1184, 4 row lock(s), undo log entries 1
MySQL thread id 702876, ...
update a
set last_updated = now(),root_id = id
where order_no = 'dhe170809091008307001'
and last_updated = '2017-08-09 09:10:53'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 454569 page no 5589 n bits 744 index `idx_last_updated` of table `xxx`.`a` trx id 37474688445 lock_mode X locks rec but not gap
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 454569 page no 5589 n bits 744 index `idx_last_updated` of table `xxx`.`a` trx id 37474688445 lock_mode X waiting
*** WE ROLL BACK TRANSACTION (1)
------------
How to repeat:
Any deadlock occurred...
Suggested fix:
refer to AliSql.
