Created
January 16, 2022 18:37
-
-
Save ralonsoh/fcfb3c826c57ab4bd2f4c96397d93223 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
LATEST DETECTED DEADLOCK | |
------------------------ | |
2021-04-30 12:51:53 0x7fd592423700 | |
*** (1) TRANSACTION: | |
TRANSACTION 67406136842, ACTIVE 1 sec starting index read | |
mysql tables in use 1, locked 1 | |
LOCK WAIT 9 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 2 | |
MySQL thread id 206114, OS thread handle 140555916941056, query id 183334694 172.16.21.72 neutron Updating | |
UPDATE quotausages SET dirty=1 WHERE quotausages.project_id = '16d7ab88b78a43c48bb05b772bfb59c7' AND quotausages.resource = 'port' | |
*** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
RECORD LOCKS space id 320 page no 34 n bits 232 index PRIMARY of table `ovs_neutron`.`quotausages` trx id 67406136842 lock_mode X locks rec but not gap waiting | |
Record lock, heap no 11 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 | |
0: len 30; hex 313664376162383862373861343363343862623035623737326266623539; asc 16d7ab88b78a43c48bb05b772bfb59; (total 32 bytes); | |
1: len 4; hex 706f7274; asc port;; | |
2: len 6; hex 000fb1b7e637; asc 7;; | |
3: len 7; hex 1f0000801a2062; asc b;; | |
4: len 1; hex 80; asc ;; | |
5: len 4; hex 800004c1; asc ;; | |
6: len 4; hex 80000000; asc ;; | |
*** (2) TRANSACTION: | |
TRANSACTION 67406129110, ACTIVE 51 sec inserting | |
mysql tables in use 1, locked 1 | |
5 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 | |
MySQL thread id 208150, OS thread handle 140555258574592, query id 183339728 172.16.21.72 neutron Update | |
INSERT INTO resourcedeltas (resource, reservation_id, amount) VALUES ('port', '7aab84b9-96e2-4108-bac3-c6e27517f711', 1) | |
*** (2) HOLDS THE LOCK(S): | |
RECORD LOCKS space id 320 page no 34 n bits 232 index PRIMARY of table `ovs_neutron`.`quotausages` trx id 67406129110 lock_mode X locks rec but not gap | |
Record lock, heap no 11 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 | |
0: len 30; hex 313664376162383862373861343363343862623035623737326266623539; asc 16d7ab88b78a43c48bb05b772bfb59; (total 32 bytes); | |
1: len 4; hex 706f7274; asc port;; | |
2: len 6; hex 000fb1b7e637; asc 7;; | |
3: len 7; hex 1f0000801a2062; asc b;; | |
4: len 1; hex 80; asc ;; | |
5: len 4; hex 800004c1; asc ;; | |
6: len 4; hex 80000000; asc ;; | |
*** (2) WAITING FOR THIS LOCK TO BE GRANTED: | |
RECORD LOCKS space id 340 page no 4 n bits 336 index reservation_id of table `ovs_neutron`.`resourcedeltas` trx id 67406129110 lock_mode X locks gap before rec insert intention waiting | |
Record lock, heap no 146 PHYSICAL RECORD: n_fields 2; compact format; info bits 32 | |
0: len 30; hex 37643138393736632d653734652d346438632d626136372d643137646336; asc 7d18976c-e74e-4d8c-ba67-d17dc6; (total 36 bytes); | |
1: len 4; hex 706f7274; asc port;; | |
*** WE ROLL BACK TRANSACTION (2) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment