Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save ralonsoh/fcfb3c826c57ab4bd2f4c96397d93223 to your computer and use it in GitHub Desktop.
Save ralonsoh/fcfb3c826c57ab4bd2f4c96397d93223 to your computer and use it in GitHub Desktop.
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