{"body":"*** (2) TRANSACTION:\nTRANSACTION 61878500, ACTIVE 1 sec starting index read\nmysql tables in use 1, locked 1\nLOCK WAIT 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1\nMariaDB thread id 5817008, OS thread handle 140173607261760, query id 261727512 infra03_maxsale 172.17.221.9 neutron Updating\nUPDATE ports SET status='DOWN' WHERE ports.id = 'b4f5bf40-cc72-4488-b65b-519058d0a3d8'\n*** WAITING FOR THIS LOCK TO BE GRANTED:\nRECORD 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\nRecord lock, heap no 38 PHYSICAL RECORD: n_fields 14; compact format; info bits 0\n 0: len 30; hex 62346635626634302d636337322d343438382d623635622d353139303538; asc b4f5bf40-cc72-4488-b65b-519058; (total 36 bytes);\n 1: len 6; hex 000003b030d7; asc     0 ;;\n 2: len 7; hex 6e00000cd415a1; asc n      ;;\n 3: len 30; hex 383862633938343136626535343235326235643732386434376163326161; asc 88bc98416be54252b5d728d47ac2aa; (total 32 bytes);\n 4: len 0; hex ; asc ;;\n 5: len 30; hex 66373936386339332d313935632d343335382d616134642d663964326162; asc f7968c93-195c-4358-aa4d-f9d2ab; (total 36 bytes);\n 6: len 17; hex 66613a31363a33653a32653a31633a3166; asc fa:16:3e:2e:1c:1f;;\n 7: len 1; hex 81; asc  ;;\n 8: len 6; hex 414354495645; asc ACTIVE;;\n 9: len 30; hex 39356465316233652d663361392d343333312d613435302d393337316430; asc 95de1b3e-f3a9-4331-a450-9371d0; (total 36 bytes);\n 10: len 12; hex 636f6d707574653a6e6f7661; asc compute:nova;;\n 11: SQL NULL;\n 12: len 8; hex 80000000000396be; asc         ;;\n 13: len 9; hex 696d6d656469617465; asc immediate;;\n\n*** CONFLICTING WITH:\nRECORD 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\nRecord lock, heap no 38 PHYSICAL RECORD: n_fields 14; compact format; info bits 0\n 0: len 30; hex 62346635626634302d636337322d343438382d623635622d353139303538; asc b4f5bf40-cc72-4488-b65b-519058; (total 36 bytes);\n 1: len 6; hex 000003b030d7; asc     0 ;;\n 2: len 7; hex 6e00000cd415a1; asc n      ;;\n 3: len 30; hex 383862633938343136626535343235326235643732386434376163326161; asc 88bc98416be54252b5d728d47ac2aa; (total 32 bytes);\n 4: len 0; hex ; asc ;;\n 5: len 30; hex 66373936386339332d313935632d343335382d616134642d663964326162; asc f7968c93-195c-4358-aa4d-f9d2ab; (total 36 bytes);\n 6: len 17; hex 66613a31363a33653a32653a31633a3166; asc fa:16:3e:2e:1c:1f;;\n 7: len 1; hex 81; asc  ;;\n 8: len 6; hex 414354495645; asc ACTIVE;;\n 9: len 30; hex 39356465316233652d663361392d343333312d613435302d393337316430; asc 95de1b3e-f3a9-4331-a450-9371d0; (total 36 bytes);\n 10: len 12; hex 636f6d707574653a6e6f7661; asc compute:nova;;\n 11: SQL NULL;\n 12: len 8; hex 80000000000396be; asc         ;;\n 13: len 9; hex 696d6d656469617465; asc immediate;;\n\n*** WE ROLL BACK TRANSACTION (2)\n------------","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/o4HQQaEK","modified":1696922032,"id":"o4HQQaEK","size":2883,"lines":44,"own_paste":false,"theme":"","date":1696922032}