------------------------ LATEST DETECTED DEADLOCK ------------------------ 2024-10-04 15:00:07 23102774413056 *** (1) TRANSACTION: TRANSACTION 709167727, ACTIVE 5 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 997 lock struct(s), heap size 123000, 10350 row lock(s), undo log entries 6406 MySQL thread id 26931599, OS thread handle 23111714981632, query id 866732305 10.100.0.152 zabbix update insert into event_suppress (event_suppressid,eventid,maintenanceid,suppress_until) values (6807941,5350,30,1728055800),(6807942,223305,163,1728055800),(6807943,223655,163,1728055800),(6807944,224035,163,1728055800),(6807945,224150,163,1728055800),(6807946,224385,163,1728055800),(6807947,228150,163,1728055800),(6807948,228695,163,1728055800),(6807949,232110,163,1728055800),(6807950,233610,163,1728055800),(6807951,233755,163,1728055800),(6807952,239990,163,1728055800),(6807953,240165,163,1728055800),(6807954,240255,163,1728055800),(6807955,240535,163,1728055800),(6807956,244000,163,1728055800),(6807957,244180,163,1728055800),(6807958,245850,163,1728055800),(6807959,246755,163,1728055800),(6807960,247585,163,1728055800),(6807961,247675,163,1728055800),(6807962,247850,163,1728055800),(6807963,248050,163,1728055800),(6807964,248140,163,1728055800),(6807965,249205,163,1728055800),(6807966,249325,163,1728055800) *** (1) HOLDS THE LOCK(S): RECORD LOCKS space id 366 page no 1251 n bits 600 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 709167727 lock_mode X locks gap before rec Record lock, heap no 20 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 00000000000619db; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e64e; asc g N;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a03; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e650; asc g P;; Record lock, heap no 39 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a71; asc q;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e656; asc g V;; Record lock, heap no 46 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061aa8; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e65b; asc g [;; Record lock, heap no 218 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a35; asc 5;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e653; asc g S;; Record lock, heap no 446 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061aa3; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e65a; asc g Z;; Record lock, heap no 469 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 00000000000619e0; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e64f; asc g O;; Record lock, heap no 510 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a0d; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e651; asc g Q;; Record lock, heap no 511 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a30; asc 0;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e652; asc g R;; Record lock, heap no 512 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a4e; asc N;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e654; asc g T;; Record lock, heap no 513 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a5d; asc ];; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e655; asc g U;; Record lock, heap no 514 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a76; asc v;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e657; asc g W;; Record lock, heap no 515 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a8f; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e658; asc g X;; Record lock, heap no 516 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000061a9e; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e659; asc g Y;; *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 366 page no 1270 n bits 384 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 709167727 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) TRANSACTION: TRANSACTION 709167753, ACTIVE 3 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 643 lock struct(s), heap size 90232, 8887 row lock(s), undo log entries 5012 MySQL thread id 28894036, OS thread handle 23111614052096, query id 866739519 10.100.0.152 zabbix update insert into event_suppress (event_suppressid,eventid,maintenanceid,suppress_until) values (6812841,1781,11,1728061200),(6812842,214521,163,1728055800),(6812843,220626,163,1728055800),(6812844,220661,163,1728055800),(6812845,221186,163,1728055800),(6812846,223441,163,1728055800),(6812847,224256,163,1728055800),(6812848,227821,163,1728055800),(6812849,227956,163,1728055800),(6812850,232201,163,1728055800),(6812851,232836,163,1728055800),(6812852,234081,163,1728055800),(6812853,234801,163,1728055800),(6812854,235296,163,1728055800),(6812855,239941,163,1728055800),(6812856,240166,163,1728055800),(6812857,240536,163,1728055800),(6812858,240911,163,1728055800),(6812859,245846,163,1728055800),(6812860,247081,163,1728055800),(6812861,247281,163,1728055800),(6812862,247586,163,1728055800),(6812863,247841,163,1728055800),(6812864,247846,163,1728055800),(6812865,249196,163,1728055800),(6812866,249206,163,1728055800) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 366 page no 1270 n bits 336 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 709167753 lock_mode X Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 366 page no 1251 n bits 600 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 709167753 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 469 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 00000000000619e0; asc ;; 1: len 8; hex 00000000000000a3; asc ;; 2: len 8; hex 000000000067e64f; asc g O;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 713018756 Purge done for trx's n:o < 713018733 undo n:o < 0 state: running but idle History list length 4754 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 304586602640456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602629328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602588240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602639600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602638744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602589096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602586528, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602649872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602649016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602648160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602647304, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602646448, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602644736, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602643880, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602642168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602641312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602637888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602637032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602636176, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602635320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602634464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602633608, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602632752, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602631896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602631040, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602630184, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602628472, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602627616, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602625904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602625048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602624192, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602623336, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602622480, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602621624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602620768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602619912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602619056, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602618200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602617344, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602616488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602615632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602614776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602613920, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602613064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602612208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602611352, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602610496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602609640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602608784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602607928, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602607072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602606216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602605360, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602604504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602603648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602602792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602601936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602601080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602600224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602599368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602598512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602597656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602596800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602595944, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602595088, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602594232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602593376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602592520, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602591664, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602590808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602589952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602587384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602585672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602584816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602583960, not started 0 lock struct(s), heap size 1128, 0 row lock(s)