January 4, 2013

一个线上死锁问题分析

死锁日志如下: TRANSACTION 48AA4BB9, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 6 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 2 MySQL thread id 1409173, OS thread handle 0x5659f940, query id 1084083936 10.246.138.197 bop_libra update insert into deadlock_test (deadlock_config_id, block_id, type, gmt_create, gmt_modified) values (31643, 92354, 1, […]