-
-
Save explorer14/a94740432b0e23ef177266ce4048caee to your computer and use it in GitHub Desktop.
This file contains 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
===================================== | |
2021-07-23 21:27:55 0x7f0fec4a3700 INNODB MONITOR OUTPUT | |
===================================== | |
... | |
------------------------ | |
LATEST DETECTED DEADLOCK | |
------------------------ | |
2021-07-23 21:26:29 0x7f0fd3558700 | |
*** (1) TRANSACTION: | |
TRANSACTION 2631, ACTIVE 0 sec starting index read | |
mysql tables in use 1, locked 1 | |
LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s) | |
MySQL thread id 15, OS thread handle 139706363459328, query id 3531 172.20.0.1 root updating | |
update TrxDb.Products set stock = 495 where Id = 1000 and Version = 1 | |
*** (1) HOLDS THE LOCK(S): | |
RECORD LOCKS space id 2 page no 4 n bits 72 index PRIMARY of table `TrxDb`.`Products` trx id 2631 lock mode S locks rec but not gap | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 | |
... | |
*** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
RECORD LOCKS space id 2 page no 4 n bits 72 index PRIMARY of table `TrxDb`.`Products` trx id 2631 lock_mode X locks rec but not gap waiting | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 | |
... | |
*** (2) TRANSACTION: | |
TRANSACTION 2632, ACTIVE 0 sec starting index read | |
mysql tables in use 1, locked 1 | |
LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s) | |
MySQL thread id 9, OS thread handle 139706363754240, query id 3533 172.20.0.1 root updating | |
update TrxDb.Products set stock = 357 where Id = 1000 and Version = 1 | |
*** (2) HOLDS THE LOCK(S): | |
RECORD LOCKS space id 2 page no 4 n bits 72 index PRIMARY of table `TrxDb`.`Products` trx id 2632 lock mode S locks rec but not gap | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 | |
... | |
*** (2) WAITING FOR THIS LOCK TO BE GRANTED: | |
RECORD LOCKS space id 2 page no 4 n bits 72 index PRIMARY of table `TrxDb`.`Products` trx id 2632 lock_mode X locks rec but not gap waiting | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 | |
... | |
*** WE ROLL BACK TRANSACTION (2) | |
... | |
---------------------------- | |
END OF INNODB MONITOR OUTPUT | |
============================ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment