Hi, I'm receiving MySQL 5.5 deadlocks.
I enabled the innodb lock monitor using this command: CREATE TABLE innodb_lock_monitor(a int) ENGINE=INNODB; I got the following output: ------------------------ LATEST DETECTED DEADLOCK ------------------------ 151007 13:58:36 *** (1) TRANSACTION: TRANSACTION 13F6957A, ACTIVE 10 sec starting index read mysql tables in use 2, locked 2 LOCK WAIT 6 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 2 MySQL thread id 15115, OS thread handle 0x2b1b51a55700, query id 150823016 10.129.28.111 awsuser Updating update LANCAMENTO set ALTERADO_INTERFACE=1, DATA_CRIACAO='2015-08-28', DATA_FIN_MAT_DISTRIB=null, DATA_LCTO_DISTRIBUIDOR='2015-08-24', DATA_LCTO_PREVISTA='2015-08-24', DATA_REC_DISTRIB='2015-10-23', DATA_REC_PREVISTA='2015-10-23', DATA_STATUS='2015-10-07 11:01:43', ESTUDO_ID=null, EXPEDICAO_ID=641, JURAMENTADO=null, NUMERO_LANCAMENTO=1, NUMERO_REPROGRAMACOES=null, PERIODO_LANCAMENTO_PARCIAL_ID=null, PRODUTO_EDICAO_ID=464, REPARTE=2700, REPARTE_PROMOCIONAL=0, SEQUENCIA_MATRIZ=null, STATUS='EXPEDIDO', TIPO_LANCAMENTO='LANCAMENTO', USUARIO_ID=11 where ID=464 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 48034 page no 15 n bits 216 index `PRIMARY` of table `db_00757350`.`lancamento` trx id 13F6957A lock_mode X locks rec but not gap waiting Record lock, heap no 144 PHYSICAL RECORD: n_fields 24; compact format; info bits 0 0: len 8; hex 80000000000001d0; asc ;; 1: len 6; hex 000013f6933b; asc ;;; 2: len 7; hex 0b00002c6629e2; asc ,f) ;; 3: len 1; hex 81; asc ;; 4: len 3; hex 8fbf1c; asc ;; 5: len 3; hex 8fbf18; asc ;; 6: len 3; hex 8fbf18; asc ;; 7: len 3; hex 8fbf57; asc W;; 8: len 3; hex 8fbf57; asc W;; 9: SQL NULL; 10: len 8; hex 80001253c59ee3d4; asc S ;; 11: len 9; hex 80000000000a8c0000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: SQL NULL; 14: len 8; hex 455850454449444f; asc EXPEDIDO;; 15: len 10; hex 4c414e43414d454e544f; asc LANCAMENTO;; 16: len 8; hex 80000000000001d0; asc ;; 17: len 8; hex 8000000000000281; asc ;; 18: len 8; hex 800000000000000b; asc ;; 19: len 4; hex 80000001; asc ;; 20: SQL NULL; 21: SQL NULL; 22: SQL NULL; 23: SQL NULL; Somebody could help me to understand this result? Thanks!
