PHP Decode

\n=====================================\n2024-08-17 11:49:12 70369878689168 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 19 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 16927985 srv_active, 0 srv_shutdown, 18659 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 2204281\nOS WAIT ARRAY INFO: signal count 3404974\nRW-shared spins 0, rounds 0, OS waits 0\nRW-excl spins 0, rounds 0, OS waits 0\nRW-sx spins 0, rounds 0, OS waits 0\nSpin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx\n------------------------\nLATEST FOREIGN KEY ERROR\n------------------------\n2024-08-07 17:21:19 70372935640464 Transaction:\nTRANSACTION 25499038, ACTIVE 0 sec updating or deleting\nmysql tables in use 1, locked 1\n13 lock struct(s), heap size 1128, 218 row lock(s), undo log entries 3\nMySQL thread id 3996216, OS thread handle 70372935640464, query id 380489087 172.31.74.193 admin updating\n-- select * from exames_materiais where material_id in ( select id from materiais where nome = 'Secreo Nasal' ) \n-- update exames_materiais set material_id = 175 where material_id in ( select id from materiais where nome = 'Secreo Nasal' ) \ndelete from materiais where nome = 'Secreo Nasal'  and id <> 175 LIMIT 101\nForeign key constraint fails for table `klis_labfq`.`unidade_apoio_codigos`:\n,\n  CONSTRAINT `unidade_apoio_codigos_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materiais` (`id`)\nTrying to delete in parent table, in index PRIMARY tuple:\nDATA TUPLE: 11 fields;\n 0: len 8; hex 00000000000000dc; asc         ;;\n 1: len 6; hex 00000185159e; asc       ;;\n 2: len 7; hex 02000001b93115; asc      1 ;;\n 3: len 16; hex 5365637265c3a7c3a36f204e6173616c; asc Secre    o Nasal;;\n 4: len 8; hex 0000000000000001; asc         ;;\n 5: len 4; hex 66040f70; asc f  p;;\n 6: len 4; hex 66040f70; asc f  p;;\n 7: SQL NULL;\n 8: len 1; hex 81; asc  ;;\n 9: len 5; hex 532e4e4153; asc S.NAS;;\n 10: SQL NULL;\n\nBut in child table `klis_labfq`.`unidade_apoio_codigos`, in index IFK_unidade_apoio_codigos_material_id, there is a record:\nPHYSICAL RECORD: n_fields 2; compact format; info bits 0\n 0: len 8; hex 00000000000000dc; asc         ;;\n 1: len 8; hex 0000000000000a2d; asc        -;;\n\n------------------------\nLATEST DETECTED DEADLOCK\n------------------------\n2024-08-16 18:21:17 70372290532752\n*** (1) TRANSACTION:\nTRANSACTION 27645390, ACTIVE 0 sec starting index read\nmysql tables in use 1, locked 1\nLOCK WAIT 11 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 1\nMySQL thread id 4402681, OS thread handle 70372321142160, query id 411488975 172.31.74.193 admin updating\nupdate `amostras` set `status_rastro_id` = 9, `amostras`.`updated_at` = '2024-08-16 15:21:17' where `id` = 348178\n\n*** (1) HOLDS THE LOCK(S):\nRECORD LOCKS space id 1977 page no 22169 n bits 96 index PRIMARY of table `klis_linus`.`amostras` trx id 27645390 lock mode S locks rec but not gap\nRecord lock, heap no 26 PHYSICAL RECORD: n_fields 33; compact format; info bits 0\n 0: len 8; hex 0000000000055012; asc       P ;;\n 1: len 6; hex 000001a5d5cc; asc       ;;\n 2: len 7; hex 0200000189294f; asc      )O;;\n 3: len 12; hex 373030303030333438313738; asc 700000348178;;\n 4: len 19; hex 53616e67756520746f74616c20284544544129; asc Sangue total (EDTA);;\n 5: len 5; hex 3632353338; asc 62538;;\n 6: len 5; hex 99b420f11f; asc      ;;\n 7: len 5; hex 4c4155524f; asc LAURO;;\n 8: len 8; hex 00000000000034ee; asc       4 ;;\n 9: len 8; hex 0000000000000001; asc         ;;\n 10: len 4; hex 66bf6a7f; asc f j ;;\n 11: len 4; hex 66bf6e6d; asc f nm;;\n 12: SQL NULL;\n 13: len 8; hex 0000000000004bcc; asc       K ;;\n 14: SQL NULL;\n 15: len 8; hex 0000000000000009; asc         ;;\n 16: SQL NULL;\n 17: SQL NULL;\n 18: SQL NULL;\n 19: SQL NULL;\n 20: SQL NULL;\n 21: len 30; hex 4e0a52312c300a4431300a413231302c302c302c322c312c312c4e2c224c; asc N R1,0 D10 A210,0,0,2,1,1,N,\"L; (total 444 bytes);\n 22: SQL NULL;\n 23: SQL NULL;\n 24: SQL NULL;\n 25: SQL NULL;\n 26: SQL NULL;\n 27: SQL NULL;\n 28: SQL NULL;\n 29: len 24; hex 3133307c73616e67756520746f74616c202865647461297c; asc 130|sangue total (edta)|;;\n 30: SQL NULL;\n 31: len 9; hex 454d414e55454c4c45; asc EMANUELLE;;\n 32: SQL NULL;\n\n\n*** (1) WAITING FOR THIS LOCK TO BE GRANTED:\nRECORD LOCKS space id 1977 page no 22169 n bits 96 index PRIMARY of table `klis_linus`.`amostras` trx id 27645390 lock_mode X locks rec but not gap waiting\nRecord lock, heap no 26 PHYSICAL RECORD: n_fields 33; compact format; info bits 0\n 0: len 8; hex 0000000000055012; asc       P ;;\n 1: len 6; hex 000001a5d5cc; asc       ;;\n 2: len 7; hex 0200000189294f; asc      )O;;\n 3: len 12; hex 373030303030333438313738; asc 700000348178;;\n 4: len 19; hex 53616e67756520746f74616c20284544544129; asc Sangue total (EDTA);;\n 5: len 5; hex 3632353338; asc 62538;;\n 6: len 5; hex 99b420f11f; asc      ;;\n 7: len 5; hex 4c4155524f; asc LAURO;;\n 8: len 8; hex 00000000000034ee; asc       4 ;;\n 9: len 8; hex 0000000000000001; asc         ;;\n 10: len 4; hex 66bf6a7f; asc f j ;;\n 11: len 4; hex 66bf6e6d; asc f nm;;\n 12: SQL NULL;\n 13: len 8; hex 0000000000004bcc; asc       K ;;\n 14: SQL NULL;\n 15: len 8; hex 0000000000000009; asc         ;;\n 16: SQL NULL;\n 17: SQL NULL;\n 18: SQL NULL;\n 19: SQL NULL;\n 20: SQL NULL;\n 21: len 30; hex 4e0a52312c300a4431300a413231302c302c302c322c312c312c4e2c224c; asc N R1,0 D10 A210,0,0,2,1,1,N,\"L; (total 444 bytes);\n 22: SQL NULL;\n 23: SQL NULL;\n 24: SQL NULL;\n 25: SQL NULL;\n 26: SQL NULL;\n 27: SQL NULL;\n 28: SQL NULL;\n 29: len 24; hex 3133307c73616e67756520746f74616c202865647461297c; asc 130|sangue total (edta)|;;\n 30: SQL NULL;\n 31: len 9; hex 454d414e55454c4c45; asc EMANUELLE;;\n 32: SQL NULL;\n\n\n*** (2) TRANSACTION:\nTRANSACTION 27645389, ACTIVE 0 sec starting index read\nmysql tables in use 1, locked 1\nLOCK WAIT 11 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 1\nMySQL thread id 4402685, OS thread handle 70369697093008, query id 411488978 172.31.74.193 admin updating\nupdate `amostras` set `status_rastro_id` = 9, `amostras`.`updated_at` = '2024-08-16 15:21:17' where `id` = 348178\n\n*** (2) HOLDS THE LOCK(S):\nRECORD LOCKS space id 1977 page no 22169 n bits 96 index PRIMARY of table `klis_linus`.`amostras` trx id 27645389 lock mode S locks rec but not gap\nRecord lock, heap no 26 PHYSICAL RECORD: n_fields 33; compact format; info bits 0\n 0: len 8; hex 0000000000055012; asc       P ;;\n 1: len 6; hex 000001a5d5cc; asc       ;;\n 2: len 7; hex 0200000189294f; asc      )O;;\n 3: len 12; hex 373030303030333438313738; asc 700000348178;;\n 4: len 19; hex 53616e67756520746f74616c20284544544129; asc Sangue total (EDTA);;\n 5: len 5; hex 3632353338; asc 62538;;\n 6: len 5; hex 99b420f11f; asc      ;;\n 7: len 5; hex 4c4155524f; asc LAURO;;\n 8: len 8; hex 00000000000034ee; asc       4 ;;\n 9: len 8; hex 0000000000000001; asc         ;;\n 10: len 4; hex 66bf6a7f; asc f j ;;\n 11: len 4; hex 66bf6e6d; asc f nm;;\n 12: SQL NULL;\n 13: len 8; hex 0000000000004bcc; asc       K ;;\n 14: SQL NULL;\n 15: len 8; hex 0000000000000009; asc         ;;\n 16: SQL NULL;\n 17: SQL NULL;\n 18: SQL NULL;\n 19: SQL NULL;\n 20: SQL NULL;\n 21: len 30; hex 4e0a52312c300a4431300a413231302c302c302c322c312c312c4e2c224c; asc N R1,0 D10 A210,0,0,2,1,1,N,\"L; (total 444 bytes);\n 22: SQL NULL;\n 23: SQL NULL;\n 24: SQL NULL;\n 25: SQL NULL;\n 26: SQL NULL;\n 27: SQL NULL;\n 28: SQL NULL;\n 29: len 24; hex 3133307c73616e67756520746f74616c202865647461297c; asc 130|sangue total (edta)|;;\n 30: SQL NULL;\n 31: len 9; hex 454d414e55454c4c45; asc EMANUELLE;;\n 32: SQL NULL;\n\n\n*** (2) WAITING FOR THIS LOCK TO BE GRANTED:\nRECORD LOCKS space id 1977 page no 22169 n bits 96 index PRIMARY of table `klis_linus`.`amostras` trx id 27645389 lock_mode X locks rec but not gap waiting\nRecord lock, heap no 26 PHYSICAL RECORD: n_fields 33; compact format; info bits 0\n 0: len 8; hex 0000000000055012; asc       P ;;\n 1: len 6; hex 000001a5d5cc; asc       ;;\n 2: len 7; hex 0200000189294f; asc      )O;;\n 3: len 12; hex 373030303030333438313738; asc 700000348178;;\n 4: len 19; hex 53616e67756520746f74616c20284544544129; asc Sangue total (EDTA);;\n 5: len 5; hex 3632353338; asc 62538;;\n 6: len 5; hex 99b420f11f; asc      ;;\n 7: len 5; hex 4c4155524f; asc LAURO;;\n 8: len 8; hex 00000000000034ee; asc       4 ;;\n 9: len 8; hex 0000000000000001; asc         ;;\n 10: len 4; hex 66bf6a7f; asc f j ;;\n 11: len 4; hex 66bf6e6d; asc f nm;;\n 12: SQL NULL;\n 13: len 8; hex 0000000000004bcc; asc       K ;;\n 14: SQL NULL;\n 15: len 8; hex 0000000000000009; asc         ;;\n 16: SQL NULL;\n 17: SQL NULL;\n 18: SQL NULL;\n 19: SQL NULL;\n 20: SQL NULL;\n 21: len 30; hex 4e0a52312c300a4431300a413231302c302c302c322c312c312c4e2c224c; asc N R1,0 D10 A210,0,0,2,1,1,N,\"L; (total 444 bytes);\n 22: SQL NULL;\n 23: SQL NULL;\n 24: SQL NULL;\n 25: SQL NULL;\n 26: SQL NULL;\n 27: SQL NULL;\n 28: SQL NULL;\n 29: len 24; hex 3133307c73616e67756520746f74616c202865647461297c; asc 130|sangue total (edta)|;;\n 30: SQL NULL;\n 31: len 9; hex 454d414e55454c4c45; asc EMANUELLE;;\n 32: SQL NULL;\n\n*** WE ROLL BACK TRANSACTION (2)\n------------\nTRANSACTIONS\n------------\nTrx id counter 27778289\nPurge done for trx's n:o < 27778288 undo n:o < 0 state: running but idle\nHistory list length 5\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 351844689781952, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n---TRANSACTION 351844689779528, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n---TRANSACTION 351844689781144, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n---TRANSACTION 351844689778720, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n---TRANSACTION 351844689777912, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for completed aio requests ((null))\nI/O thread 1 state: waiting for completed aio requests (insert buffer thread)\nI/O thread 2 state: waiting for completed aio requests (read thread)\nI/O thread 3 state: waiting for completed aio requests (read thread)\nI/O thread 4 state: waiting for completed aio requests (read thread)\nI/O thread 5 state: waiting for completed aio requests (read thread)\nI/O thread 6 state: waiting for completed aio requests (write thread)\nI/O thread 7 state: waiting for completed aio requests (write thread)\nI/O thread 8 state: waiting for completed aio requests (write thread)\nPending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,\n ibuf aio reads:\nPending flushes (fsync) log: 0; buffer pool: 0\n6123723 OS file reads, 105229388 OS file writes, 62280026 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 0.20 writes/s, 0.15 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 20, seg size 22, 124240 merges\nmerged operations:\n insert 1282443, delete mark 17602, delete 5215\ndiscarded operations:\n insert 0, delete mark 0, delete 0\nHash table size 553253, node heap has 1565 buffer(s)\nHash table size 553253, node heap has 991 buffer(s)\nHash table size 553253, node heap has 259 buffer(s)\nHash table size 553253, node heap has 578 buffer(s)\nHash table size 553253, node heap has 191 buffer(s)\nHash table size 553253, node heap has 303 buffer(s)\nHash table size 553253, node heap has 1228 buffer(s)\nHash table size 553253, node heap has 87 buffer(s)\n20034.37 hash searches/s, 21646.54 non-hash searches/s\n---\nLOG\n---\nLog sequence number          55098022016\nLog buffer assigned up to    55098022016\nLog buffer completed up to   55098022016\nLog written up to            55098022016\nLog flushed up to            55098022016\nAdded dirty pages up to      55098022016\nPages flushed up to          55097254306\nLast checkpoint at           55097254306\nLog minimum file id is       795\nLog maximum file id is       824\n83598175 log i/o's done, 0.20 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 27526473\nBuffer pool size   131059\nFree buffers       8197\nDatabase pages     117660\nOld database pages 43268\nModified db pages  286\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 78109799, not young 104480395\n3.93 youngs/s, 0.00 non-youngs/s\nPages read 6123310, created 2398814, written 11503449\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 117660, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   16382\nFree buffers       1024\nDatabase pages     14699\nOld database pages 5405\nModified db pages  78\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1107482, not young 12666769\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 767432, created 295616, written 1447627\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14699, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   16382\nFree buffers       1026\nDatabase pages     14725\nOld database pages 5415\nModified db pages  16\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1110219, not young 14533932\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 787371, created 296180, written 1436247\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14725, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   16382\nFree buffers       1024\nDatabase pages     14729\nOld database pages 5417\nModified db pages  16\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1187545, not young 12003255\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 777074, created 296088, written 1368483\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14729, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   16383\nFree buffers       1024\nDatabase pages     14698\nOld database pages 5405\nModified db pages  49\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1228022, not young 13541672\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 779718, created 301052, written 1405156\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14698, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   16382\nFree buffers       1024\nDatabase pages     14715\nOld database pages 5411\nModified db pages  34\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1124064, not young 13203787\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 744462, created 302447, written 1423503\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14715, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   16383\nFree buffers       1025\nDatabase pages     14666\nOld database pages 5393\nModified db pages  14\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1590207, not young 14745391\n0.10 youngs/s, 0.00 non-youngs/s\nPages read 758745, created 301158, written 1409207\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14666, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   16383\nFree buffers       1025\nDatabase pages     14714\nOld database pages 5411\nModified db pages  21\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 69671914, not young 12309656\n3.83 youngs/s, 0.00 non-youngs/s\nPages read 770702, created 303268, written 1544972\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14714, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   16382\nFree buffers       1025\nDatabase pages     14714\nOld database pages 5411\nModified db pages  58\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1090346, not young 11475933\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 737806, created 303005, written 1468254\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 14714, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n1 read views open inside InnoDB\nProcess ID=819, Main thread ID=70372307244432 , state=sleeping\nNumber of rows inserted 656031130, updated 15265490, deleted 22353, read 294625227401\n35.31 inserts/s, 0.00 updates/s, 0.00 deletes/s, 32753.80 reads/s\nNumber of system rows inserted 467854, updated 1168853, deleted 263813, read 14648791\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.42 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n