*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2026-05-29 15:08:06 0x7fd7d935d700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 60 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 11 srv_active, 0 srv_shutdown, 937464 srv_idle srv_master_thread log flush and writes: 937444 ---------- SEMAPHORES ---------- ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2026-05-29 04:31:54 0x7fd7d8ead700 *** (1) TRANSACTION: TRANSACTION 312873663, ACTIVE 13 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 180 lock struct(s), heap size 24696, 3 row lock(s), undo log entries 1 MariaDB thread id 394032, OS thread handle 140565033965312, query id 405807531 streams2p2-prd.mask.www.xxx.yyy.zz 10.134.197.202 STREAMS202 Updating UPDATE str_master SET stage = 'SC',dt_stage = CURRENT_TIMESTAMP(6) WHERE deleted = 0 AND id = 1396337 *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 47232 page no 73306 n bits 1552 index idx_str_master_id_consent of table `STREAMS202`.`str_master` trx id 312873663 lock_mode X locks rec but not gap waiting Record lock, heap no 1034 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 00154e71; asc Nq;; 1: SQL NULL; *** CONFLICTING WITH: RECORD LOCKS space id 47232 page no 73306 n bits 1552 index idx_str_master_id_consent of table `STREAMS202`.`str_master` trx id 312873676 lock_mode X locks rec but not gap Record lock, heap no 1034 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 00154e71; asc Nq;; 1: SQL NULL; *** (2) TRANSACTION: TRANSACTION 312873676, ACTIVE 3 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MariaDB thread id 394027, OS thread handle 140565033658112, query id 405807501 streams2p2-prd.mask.www.xxx.yyy.zz 10.134.197.202 STREAMS202 Updating update str_master set indexed_time = '2026-05-29 04:31:52.336916', indexed = 1, skip_indexed = 0 where id = 1396337 and deleted = 0 *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 47232 page no 48575 n bits 56 index PRIMARY of table `STREAMS202`.`str_master` trx id 312873676 lock_mode X locks rec but not gap waiting Record lock, heap no 12 PHYSICAL RECORD: n_fields 117; compact format; info bits 0 0: len 4; hex 00154e71; asc Nq;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 10; hex 32303236303736343736; asc 2026076476;; 4: len 4; hex 00000112; asc ;; 5: len 26; hex 534d4e2d30303130303039362d32303236303532322d30303038; asc SMN-00100096-20260522-0008;; 6: len 8; hex 99b9ed0e79029c78; asc y x;; 7: SQL NULL; 8: len 4; hex 80000000; asc ;; 9: len 4; hex 80000000; asc ;; 10: len 8; hex 99b9ed0e79027ff1; asc y ;; 11: len 5; hex 3030303030; asc 00000;; 12: SQL NULL; 13: len 8; hex 99b9fa441c09f136; asc D 6;; 14: len 2; hex 454d; asc EM;; 15: len 8; hex 99b9fa474001634b; asc G@ cK;; 16: len 2; hex 4c42; asc LB;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: SQL NULL; 22: len 1; hex 43; asc C;; 23: SQL NULL; 24: SQL NULL; 25: len 1; hex 4e; asc N;; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: SQL NULL; 30: SQL NULL; 31: SQL NULL; 32: SQL NULL; 33: SQL NULL; 34: SQL NULL; 35: SQL NULL; 36: SQL NULL; 37: SQL NULL; 38: SQL NULL; 39: SQL NULL; 40: SQL NULL; 41: SQL NULL; 42: SQL NULL; 43: len 8; hex 99b9ed0e790a6c2d; asc y l-;; 44: len 1; hex 59; asc Y;; 45: SQL NULL; 46: SQL NULL; 47: SQL NULL; 48: SQL NULL; 49: SQL NULL; 50: SQL NULL; 51: SQL NULL; 52: SQL NULL; 53: SQL NULL; 54: SQL NULL; 55: SQL NULL; 56: SQL NULL; 57: SQL NULL; 58: len 1; hex 4d; asc M;; 59: len 8; hex 99b9ed0e79027ff2; asc y ;; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: SQL NULL; 67: len 8; hex 99b9ed0e79027ff2; asc y ;; 68: len 8; hex 99b9ed0e79027ff2; asc y ;; 69: len 8; hex 99b9ed0e79027ff2; asc y ;; 70: len 8; hex 99b9ed0e79027ff2; asc y ;; 71: len 1; hex 43; asc C;; 72: SQL NULL; 73: SQL NULL; 74: SQL NULL; 75: SQL NULL; 76: SQL NULL; 77: SQL NULL; 78: SQL NULL; 79: SQL NULL; 80: SQL NULL; 81: SQL NULL; 82: SQL NULL; 83: SQL NULL; 84: SQL NULL; 85: SQL NULL; 86: len 1; hex 4e; asc N;; 87: SQL NULL; 88: len 8; hex 99b9ed0e79027ff2; asc y ;; 89: SQL NULL; 90: SQL NULL; 91: SQL NULL; 92: SQL NULL; 93: len 1; hex 80; asc ;; 94: len 1; hex 80; asc ;; 95: SQL NULL; 96: len 1; hex 80; asc ;; 97: len 8; hex 99b9fa44c0029170; asc D p;; 98: len 4; hex 8000000a; asc ;; 99: SQL NULL; 100: SQL NULL; 101: SQL NULL; 102: SQL NULL; 103: SQL NULL; 104: len 8; hex 99b9ed0e79029c78; asc y x;; 105: len 3; hex 373734; asc 774;; 106: len 8; hex 99b9fa474001634b; asc G@ cK;; 107: len 6; hex 53595354454d; asc SYSTEM;; 108: len 1; hex 80; asc ;; 109: SQL NULL; 110: SQL NULL; 111: len 1; hex 80; asc ;; 112: SQL NULL; 113: len 1; hex 80; asc ;; 114: len 1; hex 80; asc ;; 115: len 1; hex 80; asc ;; 116: SQL NULL; *** CONFLICTING WITH: RECORD LOCKS space id 47232 page no 48575 n bits 48 index PRIMARY of table `STREAMS202`.`str_master` trx id 312873663 lock mode S locks rec but not gap Record lock, heap no 12 PHYSICAL RECORD: n_fields 117; compact format; info bits 0 0: len 4; hex 00154e71; asc Nq;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 10; hex 32303236303736343736; asc 2026076476;; 4: len 4; hex 00000112; asc ;; 5: len 26; hex 534d4e2d30303130303039362d32303236303532322d30303038; asc SMN-00100096-20260522-0008;; 6: len 8; hex 99b9ed0e79029c78; asc y x;; 7: SQL NULL; 8: len 4; hex 80000000; asc ;; 9: len 4; hex 80000000; asc ;; 10: len 8; hex 99b9ed0e79027ff1; asc y ;; 11: len 5; hex 3030303030; asc 00000;; 12: SQL NULL; 13: len 8; hex 99b9fa441c09f136; asc D 6;; 14: len 2; hex 454d; asc EM;; 15: len 8; hex 99b9fa474001634b; asc G@ cK;; 16: len 2; hex 4c42; asc LB;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: SQL NULL; 22: len 1; hex 43; asc C;; 23: SQL NULL; 24: SQL NULL; 25: len 1; hex 4e; asc N;; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: SQL NULL; 30: SQL NULL; 31: SQL NULL; 32: SQL NULL; 33: SQL NULL; 34: SQL NULL; 35: SQL NULL; 36: SQL NULL; 37: SQL NULL; 38: SQL NULL; 39: SQL NULL; 40: SQL NULL; 41: SQL NULL; 42: SQL NULL; 43: len 8; hex 99b9ed0e790a6c2d; asc y l-;; 44: len 1; hex 59; asc Y;; 45: SQL NULL; 46: SQL NULL; 47: SQL NULL; 48: SQL NULL; 49: SQL NULL; 50: SQL NULL; 51: SQL NULL; 52: SQL NULL; 53: SQL NULL; 54: SQL NULL; 55: SQL NULL; 56: SQL NULL; 57: SQL NULL; 58: len 1; hex 4d; asc M;; 59: len 8; hex 99b9ed0e79027ff2; asc y ;; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: SQL NULL; 64: SQL NULL; 65: SQL NULL; 66: SQL NULL; 67: len 8; hex 99b9ed0e79027ff2; asc y ;; 68: len 8; hex 99b9ed0e79027ff2; asc y ;; 69: len 8; hex 99b9ed0e79027ff2; asc y ;; 70: len 8; hex 99b9ed0e79027ff2; asc y ;; 71: len 1; hex 43; asc C;; 72: SQL NULL; 73: SQL NULL; 74: SQL NULL; 75: SQL NULL; 76: SQL NULL; 77: SQL NULL; 78: SQL NULL; 79: SQL NULL; 80: SQL NULL; 81: SQL NULL; 82: SQL NULL; 83: SQL NULL; 84: SQL NULL; 85: SQL NULL; 86: len 1; hex 4e; asc N;; 87: SQL NULL; 88: len 8; hex 99b9ed0e79027ff2; asc y ;; 89: SQL NULL; 90: SQL NULL; 91: SQL NULL; 92: SQL NULL; 93: len 1; hex 80; asc ;; 94: len 1; hex 80; asc ;; 95: SQL NULL; 96: len 1; hex 80; asc ;; 97: len 8; hex 99b9fa44c0029170; asc D p;; 98: len 4; hex 8000000a; asc ;; 99: SQL NULL; 100: SQL NULL; 101: SQL NULL; 102: SQL NULL; 103: SQL NULL; 104: len 8; hex 99b9ed0e79029c78; asc y x;; 105: len 3; hex 373734; asc 774;; 106: len 8; hex 99b9fa474001634b; asc G@ cK;; 107: len 6; hex 53595354454d; asc SYSTEM;; 108: len 1; hex 80; asc ;; 109: SQL NULL; 110: SQL NULL; 111: len 1; hex 80; asc ;; 112: SQL NULL; 113: len 1; hex 80; asc ;; 114: len 1; hex 80; asc ;; 115: len 1; hex 80; asc ;; 116: SQL NULL; *** WE ROLL BACK TRANSACTION (0) ------------ TRANSACTIONS ------------ Trx id counter 315962844 Purge done for trx's n:o < 315962833 undo n:o < 4 state: running History list length 47 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7fd7c0eeec30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f08430), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f07330), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f06230), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f02f30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0efeb30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0eeca30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f0d930), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f0c830), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0efb830), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 315962843, ACTIVE 0 sec mysql tables in use 2, locked 0 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 410041, OS thread handle 140565033965312, query id 422534152 streams2p2-prd.mask.www.xxx.yyy.zz 10.134.197.202 STREAMS202 Sending data select distinct eafixSource.ent_number from ent_addr_fix eafixSource inner join ent_addr_fix eafixTarget on eafixTarget.deleted = 0 and eafixTarget.ent_number = 'AD0202132885' where eafixSource.deleted = 0 and eafixSource.pending_review != 1 and eafixSource.ent_number != 'AD0202132885' and eafixSource.security_level <= 5 and eafixSource.`status` = 'I' and ( ( eafixTarget.addr_type != 'O' and (UPPER(eafixTarget.addr_location) = UPPER(eafixSource.add Trx read view will not see trx with id >= 315962844, sees < 315962843 ---TRANSACTION (0x7fd7c0f0b730), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f09530), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ef0e30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ef4130), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f04030), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f11d30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ef8530), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f05130), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0eefd30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f01e30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0efc930), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ef3030), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0efda30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0f00d30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ef7430), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0eea830), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ef1f30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0eedb30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0eeb930), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee9730), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee8630), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee7530), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee6430), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee5330), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee4230), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fd7c0ee3130), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 2927303 OS file reads, 34226389 OS file writes, 27013913 OS fsyncs 0.30 reads/s, 15473 avg bytes/read, 3.03 writes/s, 3.03 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 434, free list len 149425, seg size 149860, 77834 merges merged operations: insert 118191, delete mark 128574, delete 16247 discarded operations: insert 170, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 3651520884903 Log flushed up to 3651520884809 Pages flushed up to 3650901477104 Last checkpoint at 3650901477104 0 pending log flushes, 0 pending chkp writes 26782784 log i/o's done, 3.03 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 96670318592 Dictionary memory allocated 575446216 Buffer pool size 5829840 Free buffers 2058586 Database pages 3771254 Old database pages 1392103 Modified db pages 172536 Percent of dirty pages(LRU & free pages): 2.960 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 4237272, not young 199372931 1.62 youngs/s, 4.00 non-youngs/s Pages read 2922106, created 1183594, written 7393595 0.30 reads/s, 0.20 creates/s, 0.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 3771254, unzip_LRU len: 0 I/O sum[52]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 23257884, updated 22522357, deleted 18230732, read 566125791500 3.80 inserts/s, 12.02 updates/s, 0.00 deletes/s, 953664.99 reads/s Number of system rows inserted 108, updated 0, deleted 108, read 223 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================