1 2015-08-30 13:30:53 7f7b33410700 2 *** (1) TRANSACTION: 3 TRANSACTION 20966501047, ACTIVE 0 sec starting index read 4 mysql tables in use 1, locked 1 5 LOCK WAIT 3 lock struct(s), heap size 1184, 1 ...

For example, at t1, A holds the lock, and B waits for the lock. At t2, the network between A and MySQL is abnormal. MySQL actively releases the lock imposed by A.And B adds the lock. At this time, A ...