# Pastebin o4HQQaEK
*** (2) TRANSACTION:
TRANSACTION 61878500, ACTIVE 1 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1
MariaDB thread id 5817008, OS thread handle 140173607261760, query id 261727512 infra03_maxsale 172.17.221.9 neutron Updating
UPDATE ports SET status='DOWN' WHERE ports.id = 'b4f5bf40-cc72-4488-b65b-519058d0a3d8'
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 584 page no 289 n bits 40 index PRIMARY of table `neutron`.`ports` trx id 61878500 lock_mode X locks rec but not gap waiting
Record lock, heap no 38 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
 0: len 30; hex 62346635626634302d636337322d343438382d623635622d353139303538; asc b4f5bf40-cc72-4488-b65b-519058; (total 36 bytes);
 1: len 6; hex 000003b030d7; asc     0 ;;
 2: len 7; hex 6e00000cd415a1; asc n      ;;
 3: len 30; hex 383862633938343136626535343235326235643732386434376163326161; asc 88bc98416be54252b5d728d47ac2aa; (total 32 bytes);
 4: len 0; hex ; asc ;;
 5: len 30; hex 66373936386339332d313935632d343335382d616134642d663964326162; asc f7968c93-195c-4358-aa4d-f9d2ab; (total 36 bytes);
 6: len 17; hex 66613a31363a33653a32653a31633a3166; asc fa:16:3e:2e:1c:1f;;
 7: len 1; hex 81; asc  ;;
 8: len 6; hex 414354495645; asc ACTIVE;;
 9: len 30; hex 39356465316233652d663361392d343333312d613435302d393337316430; asc 95de1b3e-f3a9-4331-a450-9371d0; (total 36 bytes);
 10: len 12; hex 636f6d707574653a6e6f7661; asc compute:nova;;
 11: SQL NULL;
 12: len 8; hex 80000000000396be; asc         ;;
 13: len 9; hex 696d6d656469617465; asc immediate;;

*** CONFLICTING WITH:
RECORD LOCKS space id 584 page no 289 n bits 40 index PRIMARY of table `neutron`.`ports` trx id 61878493 lock mode S locks rec but not gap
Record lock, heap no 38 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
 0: len 30; hex 62346635626634302d636337322d343438382d623635622d353139303538; asc b4f5bf40-cc72-4488-b65b-519058; (total 36 bytes);
 1: len 6; hex 000003b030d7; asc     0 ;;
 2: len 7; hex 6e00000cd415a1; asc n      ;;
 3: len 30; hex 383862633938343136626535343235326235643732386434376163326161; asc 88bc98416be54252b5d728d47ac2aa; (total 32 bytes);
 4: len 0; hex ; asc ;;
 5: len 30; hex 66373936386339332d313935632d343335382d616134642d663964326162; asc f7968c93-195c-4358-aa4d-f9d2ab; (total 36 bytes);
 6: len 17; hex 66613a31363a33653a32653a31633a3166; asc fa:16:3e:2e:1c:1f;;
 7: len 1; hex 81; asc  ;;
 8: len 6; hex 414354495645; asc ACTIVE;;
 9: len 30; hex 39356465316233652d663361392d343333312d613435302d393337316430; asc 95de1b3e-f3a9-4331-a450-9371d0; (total 36 bytes);
 10: len 12; hex 636f6d707574653a6e6f7661; asc compute:nova;;
 11: SQL NULL;
 12: len 8; hex 80000000000396be; asc         ;;
 13: len 9; hex 696d6d656469617465; asc immediate;;

*** WE ROLL BACK TRANSACTION (2)
------------