Last active
May 8, 2017 12:47
-
-
Save teddy-hoo/cc696587f2826d9b0869b6399008a354 to your computer and use it in GitHub Desktop.
deadlock log
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| > show engine innodb status; | |
| ------------------------ | |
| LATEST DETECTED DEADLOCK | |
| ------------------------ | |
| 2017-05-08 20:30:05 7f00b9eb6700 | |
| *** (1) TRANSACTION: | |
| TRANSACTION 37152444, ACTIVE 34 sec starting index read | |
| mysql tables in use 1, locked 1 | |
| LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s) | |
| MySQL thread id 62732, OS thread handle 0x7f00ba591700, query id 2534379 10.123. 8.23 root updating | |
| delete from t3 where i = 1 | |
| *** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 10120 page no 3 n bits 72 index `GEN_CLUST_INDEX` of table `test`.`t3` trx id 37152444 lock_mode X locks rec but not gap waiting | |
| Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 | |
| 0: len 6; hex 0000035e100c; asc ^ ;; | |
| 1: len 6; hex 00000236e689; asc 6 ;; | |
| 2: len 7; hex dc0000402d0110; asc @- ;; | |
| 3: len 4; hex 80000001; asc ;; | |
| *** (2) TRANSACTION: | |
| TRANSACTION 37152394, ACTIVE 98 sec starting index read, thread declared inside InnoDB 5000 | |
| mysql tables in use 1, locked 1 | |
| 4 lock struct(s), heap size 1184, 2 row lock(s) | |
| MySQL thread id 62698, OS thread handle 0x7f00b9eb6700, query id 2534386 10.123. 8.23 root updating | |
| delete from t3 where i = 1 | |
| *** (2) HOLDS THE LOCK(S): | |
| RECORD LOCKS space id 10120 page no 3 n bits 72 index `GEN_CLUST_INDEX` of table `test`.`t3` trx id 37152394 lock mode S locks rec but not gap | |
| Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 | |
| 0: len 6; hex 0000035e100c; asc ^ ;; | |
| 1: len 6; hex 00000236e689; asc 6 ;; | |
| 2: len 7; hex dc0000402d0110; asc @- ;; | |
| 3: len 4; hex 80000001; asc ;; | |
| *** (2) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 10120 page no 3 n bits 72 index `GEN_CLUST_INDEX` of table `test`.`t3` trx id 37152394 lock_mode X locks rec but not gap waiting | |
| Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 | |
| 0: len 6; hex 0000035e100c; asc ^ ;; | |
| 1: len 6; hex 00000236e689; asc 6 ;; | |
| 2: len 7; hex dc0000402d0110; asc @- ;; | |
| 3: len 4; hex 80000001; asc ;; | |
| *** WE ROLL BACK TRANSACTION (1) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment