------------------------ LATEST DETECTED DEADLOCK ------------------------ 2024-10-11 15:00:07 23102774413056 *** (1) TRANSACTION: TRANSACTION 725710626, ACTIVE 2 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 951 lock struct(s), heap size 123000, 4661 row lock(s), undo log entries 3581 MySQL thread id 26931601, OS thread handle 23111714981632, query id 965040718 10.100.0.152 zabbix update insert into event_suppress (event_suppressid,eventid,maintenanceid,suppress_until) values (7137665,91682,385,1728660600),(7137666,214532,386,1728660600),(7137667,220752,386,1728660600),(7137668,221212,386,1728660600),(7137669,228057,386,1728660600),(7137670,228437,386,1728660600),(7137671,231777,386,1728660600),(7137672,232347,386,1728660600),(7137673,233137,386,1728660600),(7137674,233857,386,1728660600),(7137675,234287,386,1728660600),(7137676,239047,386,1728660600),(7137677,239382,386,1728660600),(7137678,239987,386,1728660600),(7137679,240327,386,1728660600),(7137680,240392,386,1728660600),(7137681,240537,386,1728660600),(7137682,240912,386,1728660600),(7137683,243997,386,1728660600),(7137684,244177,386,1728660600),(7137685,245462,386,1728660600),(7137686,245847,386,1728660600),(7137687,246637,386,1728660600),(7137688,247082,386,1728660600),(7137689,248047,386,1728660600),(7137690,248357,386,172866060 *** (1) HOLDS THE LOCK(S): RECORD LOCKS space id 366 page no 1225 n bits 328 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 725710626 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;; *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 366 page no 1274 n bits 344 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 725710626 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 260 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000070984; asc ;; 1: len 8; hex 0000000000000183; asc ;; 2: len 8; hex 00000000006cdfeb; asc l ;; *** (2) TRANSACTION: TRANSACTION 725710624, ACTIVE 2 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 1046 lock struct(s), heap size 139384, 6341 row lock(s), undo log entries 5207 MySQL thread id 29403176, OS thread handle 23111658063616, query id 965040348 10.100.0.152 zabbix update insert into event_suppress (event_suppressid,eventid,maintenanceid,suppress_until) values (7132578,4048,385,1728660600),(7132579,214523,386,1728660600),(7132580,223533,386,1728660600),(7132581,224683,386,1728660600),(7132582,225008,386,1728660600),(7132583,229168,386,1728660600),(7132584,232688,386,1728660600),(7132585,232973,386,1728660600),(7132586,233998,386,1728660600),(7132587,234383,386,1728660600),(7132588,239463,386,1728660600),(7132589,239848,386,1728660600),(7132590,239923,386,1728660600),(7132591,240163,386,1728660600),(7132592,240538,386,1728660600),(7132593,240633,386,1728660600),(7132594,244178,386,1728660600),(7132595,247083,386,1728660600),(7132596,247173,386,1728660600),(7132597,247583,386,1728660600),(7132598,247953,386,1728660600),(7132599,248048,386,1728660600),(7132600,248358,386,1728660600),(7132601,249183,386,1728660600),(7132602,249218,386,1728660600),(7132603,249323,386,1728660600 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 366 page no 1274 n bits 328 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 725710624 lock_mode X locks gap before rec Record lock, heap no 260 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 0000000000070984; asc ;; 1: len 8; hex 0000000000000183; asc ;; 2: len 8; hex 00000000006cdfeb; asc l ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 366 page no 1225 n bits 592 index event_suppress_1 of table `zabbix`.`event_suppress` trx id 725710624 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;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 725712058 Purge done for trx's n:o < 725712031 undo n:o < 0 state: running but idle History list length 3340 LIST OF TRANSACTIONS FOR EACH SESSION: ---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 304586602629328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 304586602626760, 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 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)