------------------------
LATEST DETECTED DEADLOCK
------------------------
110726 22:51:55
*** (1) TRANSACTION:
TRANSACTION F9B5F, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 15 lock struct(s), heap size 3112, 228 row lock(s), undo log entries 1
50
MySQL thread id 352, query id 109847 localhost 127.0.0.1 root update
INSERT INTO `inventoryequipment` VALUES (DEFAULT, 1699529, 7, 0, 0, 0, 0, 0, 0,
0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 1145 n bits 984 index `inventoryitemid` of table
 `polarisms`.`inventoryequipment` trx id F9B5F lock_mode X insert intention wait
ing
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** (2) TRANSACTION:
TRANSACTION F9B5E, ACTIVE 0 sec fetching rows, thread declared inside InnoDB 30
mysql tables in use 1, locked 1
88 lock struct(s), heap size 14776, 928 row lock(s), undo log entries 450
MySQL thread id 1994, query id 109878 localhost 127.0.0.1 root updating
DELETE FROM `inventoryitems` WHERE `type` = 3 AND `accountid` = 194
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 1145 n bits 984 index `inventoryitemid` of table
 `polarisms`.`inventoryequipment` trx id F9B5E lock mode S
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 1957 n bits 320 index `PRIMARY` of table `polari
sms`.`inventoryitems` trx id F9B5E lock_mode X locks rec but not gap waiting
Record lock, heap no 27 PHYSICAL RECORD: n_fields 15; compact format; info bits
32
 0: len 4; hex 0019ec15; asc     ;;
 1: len 6; hex 0000000f9b5f; asc      _;;
 2: len 7; hex 68000004db0814; asc h      ;;
 3: len 1; hex 01; asc  ;;
 4: len 4; hex 800076fd; asc   v ;;
 5: SQL NULL;
 6: len 4; hex 80102ca6; asc   , ;;
 7: len 4; hex 80000001; asc     ;;
 8: len 4; hex 80000004; asc     ;;
 9: len 4; hex 80000001; asc     ;;
 10: len 0; hex ; asc ;;
 11: len 4; hex 7fffffff; asc     ;;
 12: len 4; hex 80000000; asc     ;;
 13: len 8; hex 7fffffffffffffff; asc         ;;
 14: len 0; hex ; asc ;;

*** WE ROLL BACK TRANSACTION (1)
------------