061110  2:58:16
*** (1) TRANSACTION:
TRANSACTION 0 123303990, ACTIVE 0 sec, process no 22832, OS thread id 1143720288 fetching rows
mysql tables in use 3, locked 3
LOCK WAIT 403 lock struct(s), heap size 63472
MySQL thread id 9577, query id 23848592 localhost dbforum Sorting result
INSERT INTO rank_TT_2p_est_tmp (rank,playerID)
				 SELECT NULL, playerID FROM game_rank as g INNER JOIN forum_users as u ON u.id=g.playerID
				 WHERE g.game='TT_2p' AND g.lastgame >= DATE_SUB('2006-11-10', INTERVAL 15 DAY) AND u.freelogin!='Y'
				  AND nbgames>=20 
				 ORDER BY g.rankscore DESC
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1458 page no 976 n bits 272 index `PRIMARY` of table `www_dow/game_rank` trx id 0 123303990 lock mode S locks rec but not gap waiting
Record lock, heap no 14 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 4; hex 0002752a; asc   u*;; 1: len 1; hex 0e; asc  ;; 2: len 6; hex 00000759783c; asc    Yx<;; 3: len 7; hex 00000026020d7a; asc    &  z;; 4: len 4; hex 80000006; asc     ;; 5: len 8; hex 00000080fddc9840; asc        @;; 6: len 4; hex 4553dcb8; asc ES  ;; 7: len 4; hex 80000032; asc    2;;

*** (2) TRANSACTION:
TRANSACTION 0 123303996, ACTIVE 0 sec, process no 22832, OS thread id 1145071968 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1216, undo log entries 1
MySQL thread id 608184, query id 23848596 server4.gs.internal 192.168.168.11 dbgames Updating
UPDATE game_rank SET nbgames=nbgames+1,rankscore=1591.24755859375 WHERE playerID=161066 AND game='TT_2p'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1458 page no 976 n bits 272 index `PRIMARY` of table `www_dow/game_rank` trx id 0 123303996 lock_mode X locks rec but not gap
Record lock, heap no 14 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 4; hex 0002752a; asc   u*;; 1: len 1; hex 0e; asc  ;; 2: len 6; hex 00000759783c; asc    Yx<;; 3: len 7; hex 00000026020d7a; asc    &  z;; 4: len 4; hex 80000006; asc     ;; 5: len 8; hex 00000080fddc9840; asc        @;; 6: len 4; hex 4553dcb8; asc ES  ;; 7: len 4; hex 80000032; asc    2;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1458 page no 527 n bits 1192 index `idx` of table `www_dow/game_rank` trx id 0 123303996 lock_mode X locks rec but not gap waiting
Record lock, heap no 296 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: len 1; hex 0e; asc  ;; 1: len 4; hex 45528946; asc ER F;; 2: len 4; hex 0002752a; asc   u*;;

*** WE ROLL BACK TRANSACTION (1)