------------------------
LATEST DETECTED DEADLOCK
------------------------
2014-07-15 16:35:37 1f60
*** (1) TRANSACTION:
TRANSACTION 26960797, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 12 lock struct(s), heap size 2936, 7 row lock(s)
MySQL thread id 1793615, OS thread handle 0x820, query id 50654173 slmupazabx02.zres.ztech 10.155.188.34 CTTPZABXAD updating
UPDATE sessions SET lastaccess=1405434937 WHERE userid=200200000000001 AND sessionid='914f31382433da157c202f2b07d075cf'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 758 page no 3 n bits 80 index `PRIMARY` of table `dttp10zabx02j`.`sessions` trx id 26960797 lock_mode X locks rec but not gap waiting
Record lock, heap no 5 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 30; hex 393134663331333832343333646131353763323032663262303764303735; asc 914f31382433da157c202f2b07d075; (total 32 bytes);
1: len 6; hex 0000019b6384; asc     c ;;
2: len 7; hex 40000002581568; asc @   X h;;
3: len 8; hex 0000b614b1e25001; asc       P ;;
4: len 4; hex d3c53c38; asc   <8;;
5: len 4; hex 80000000; asc     ;;

*** (2) TRANSACTION:
TRANSACTION 26960799, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
12 lock struct(s), heap size 2936, 7 row lock(s)
MySQL thread id 1793617, OS thread handle 0x1f60, query id 50654175 slmupazabx02.zres.ztech 10.155.188.34 CTTPZABXAD updating
UPDATE sessions SET lastaccess=1405434937 WHERE userid=200200000000001 AND sessionid='914f31382433da157c202f2b07d075cf'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 758 page no 3 n bits 80 index `PRIMARY` of table `dttp10zabx02j`.`sessions` trx id 26960799 lock mode S locks rec but not gap
Record lock, heap no 5 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 30; hex 393134663331333832343333646131353763323032663262303764303735; asc 914f31382433da157c202f2b07d075; (total 32 bytes);
1: len 6; hex 0000019b6384; asc     c ;;
2: len 7; hex 40000002581568; asc @   X h;;
3: len 8; hex 0000b614b1e25001; asc       P ;;
4: len 4; hex d3c53c38; asc   <8;;
5: len 4; hex 80000000; asc     ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 758 page no 3 n bits 80 index `PRIMARY` of table `dttp10zabx02j`.`sessions` trx id 26960799 lock_mode X locks rec but not gap waiting
Record lock, heap no 5 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 30; hex 393134663331333832343333646131353763323032663262303764303735; asc 914f31382433da157c202f2b07d075; (total 32 bytes);
1: len 6; hex 0000019b6384; asc     c ;;
2: len 7; hex 40000002581568; asc @   X h;;
3: len 8; hex 0000b614b1e25001; asc       P ;;
4: len 4; hex d3c53c38; asc   <8;;
5: len 4; hex 80000000; asc     ;;

*** WE ROLL BACK TRANSACTION (2)