MYSQL innodb_deadlock_detect

------------------------
LATEST DETECTED DEADLOCK
------------------------
2014-05-27 18:29:00 7f958ae39700
*** (1) TRANSACTION:
TRANSACTION 603580589, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 376, 2 row lock(s)
MySQL thread id 174548012, OS thread handle 0x7f9553d75700, query id 871733995 192.168.30.5 golo update
INSERT INTO `trip_record_tmp_b`(`uid`,`s_lat`,`s_lon`,`e_lat`,`e_lon`,`serial_no`,`sdate`,`edate`,`data`,`travel_id`,`issynchro`) VALUES('84bc2f352552a5241a600f661432bc2e','','','','','967790023150','2014-05-27 17:55:27','2014-05-27 18:15:59','null','3caae5f2-4c0f-461f-a7be-3fe9070732d6','1')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 15172 page no 237737 n bits 80 index `PRIMARY` of table `db_application`.`trip_record_tmp_b` trx id 603580589 lock_mode X locks rec but not gap waiting
Record lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32
 0: len 30; hex 383462633266333532353532613532343161363030663636313433326263; asc 84bc2f352552a5241a600f661432bc; (total 32 bytes);
 1: len 6; hex 000023f9e8a7; asc   #   ;;
 2: len 7; hex 46000028081c52; asc F  (  R;;
 3: len 4; hex 6e756c6c; asc null;;
 4: len 30; hex 33636161653566322d346330662d343631662d613762652d336665393037; asc 3caae5f2-4c0f-461f-a7be-3fe907; (total 36 bytes);
 5: len 0; hex ; asc ;;
 6: len 0; hex ; asc ;;
 7: len 0; hex ; asc ;;
 8: len 0; hex ; asc ;;
 9: len 5; hex 9992f71ddb; asc      ;;
 10: len 5; hex 9992f723fb; asc    # ;;
 11: len 12; hex 393637373930303233313530; asc 967790023150;;
 12: len 4; hex 00000001; asc     ;;

*** (2) TRANSACTION:
TRANSACTION 603580587, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 376, 2 row lock(s)
MySQL thread id 174940322, OS thread handle 0x7f958ae39700, query id 871733992 192.168.30.5 golo update
INSERT INTO `trip_record_tmp_b`(`uid`,`s_lat`,`s_lon`,`e_lat`,`e_lon`,`serial_no`,`sdate`,`edate`,`data`,`travel_id`,`issynchro`) VALUES('84bc2f352552a5241a600f661432bc2e','22.563603','113.89169','22.584672','113.86702','967790023150','2014-05-27 17:55:27','2014-05-27 18:15:59','[{\"Latitude\":\"22.563603\",\"Longitude\":\"113.89169\"},{\"Latitude\":\"22.563213\",\"Longitude\":\"113.89181\"},{\"Latitude\":\"22.563020\",\"Longitude\":\"113.89158\"},{\"Latitude\":\"22.563082\",\"Longitude\":\"113.89128\"},{\"Latitude\":\"22.563298\",\"Longitude\":\"113.89098\"},{\"Latitude\":\"22.563590\",\"Longitude\":\"113.89104\"},{\"Latitude\":\"22.563842\",\"Longitude\":\"113.89083\"},{\"Latitude\":\"22.564328\",\"Longitude\":\"113.89016\"},{\"Latitude\":\"22.564692\",\"Longitude\":\"113.88978\"},{\"Latitude\":\"22.565124\",\"Longitude\":\"113.88929\"},{\"Latitude\":\"22.565547\",\"Longitude\":\"113.88887\"},{\"Latitude
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 15172 page no 237737 n bits 80 index `PRIMARY` of table `db_application`.`trip_record_tmp_b` trx id 603580587 lock mode S locks rec but not gap
Record lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32
 0: len 30; hex 383462633266333532353532613532343161363030663636313433326263; asc 84bc2f352552a5241a600f661432bc; (total 32 bytes);
 1: len 6; hex 000023f9e8a7; asc   #   ;;
 2: len 7; hex 46000028081c52; asc F  (  R;;
 3: len 4; hex 6e756c6c; asc null;;
 4: len 30; hex 33636161653566322d346330662d343631662d613762652d336665393037; asc 3caae5f2-4c0f-461f-a7be-3fe907; (total 36 bytes);
 5: len 0; hex ; asc ;;
 6: len 0; hex ; asc ;;
 7: len 0; hex ; asc ;;
 8: len 0; hex ; asc ;;
 9: len 5; hex 9992f71ddb; asc      ;;
 10: len 5; hex 9992f723fb; asc    # ;;
 11: len 12; hex 393637373930303233313530; asc 967790023150;;
 12: len 4; hex 00000001; asc     ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 15172 page no 237737 n bits 80 index `PRIMARY` of table `db_application`.`trip_record_tmp_b` trx id 603580587 lock_mode X locks rec but not gap waiting
Record lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32
 0: len 30; hex 383462633266333532353532613532343161363030663636313433326263; asc 84bc2f352552a5241a600f661432bc; (total 32 bytes);
 1: len 6; hex 000023f9e8a7; asc   #   ;;
 2: len 7; hex 46000028081c52; asc F  (  R;;
 3: len 4; hex 6e756c6c; asc null;;
 4: len 30; hex 33636161653566322d346330662d343631662d613762652d336665393037; asc 3caae5f2-4c0f-461f-a7be-3fe907; (total 36 bytes);
 5: len 0; hex ; asc ;;
 6: len 0; hex ; asc ;;
 7: len 0; hex ; asc ;;
 8: len 0; hex ; asc ;;
 9: len 5; hex 9992f71ddb; asc      ;;
 10: len 5; hex 9992f723fb; asc    # ;;
 11: len 12; hex 393637373930303233313530; asc 967790023150;;
 12: len 4; hex 00000001; asc     ;;

*** WE ROLL BACK TRANSACTION (2)