[2022-01-11 14:36:06.967] ------------------------ [2022-01-11 14:36:06.967] LATEST DETECTED DEADLOCK [2022-01-11 14:36:06.967] ------------------------ [2022-01-11 14:36:06.967] 2022-01-07 14:34:17 0x7fdf4034b700 [2022-01-11 14:36:06.967] *** (1) TRANSACTION: [2022-01-11 14:36:06.967] TRANSACTION 2066005600, ACTIVE 45 sec starting index read [2022-01-11 14:36:06.967] mysql tables in use 1, locked 1 [2022-01-11 14:36:06.967] LOCK WAIT 9 lock struct(s), heap size 1136, 10 row lock(s), undo log entries 2 [2022-01-11 14:36:06.968] MySQL thread id 172, OS thread handle 140596507535104, query id 4967310214 localhost zabbix updating [2022-01-11 14:36:06.983] update ids set nextid=nextid+1 where table_name='trigger_depends' and field_name='triggerdepid' [2022-01-11 14:36:06.983] [2022-01-11 14:36:06.983] *** (1) HOLDS THE LOCK(S): [2022-01-11 14:36:06.983] RECORD LOCKS space id 234 page no 1199 n bits 176 index PRIMARY of table `zabbix`.`triggers` trx id 2066005600 lock_mode X locks rec but not gap [2022-01-11 14:36:06.983] Record lock, heap no 30 PHYSICAL RECORD: n_fields 23; compact format; info bits 0 [2022-01-11 14:36:06.983] 0: len 8; hex 000000000001b0a0; asc ;; [2022-01-11 14:36:06.983] 1: len 6; hex 00002719de4c; asc ' L;; [2022-01-11 14:36:06.983] 2: len 7; hex 81000004cf1fa1; asc ;; [2022-01-11 14:36:06.983] 3: len 12; hex 7b3136393930347d3e3d3830; asc {169904}>=80;; [2022-01-11 14:36:06.983] 4: len 30; hex 696e6f6465e4bdbfe794a8e78e875f52415445287b2346534e414d457d29; asc inode _RATE({#FSNAME}); (total 44 bytes); [2022-01-11 14:36:06.983] 5: len 0; hex ; asc ;; [2022-01-11 14:36:06.983] 6: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.983] 7: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.983] 8: len 4; hex 80000002; asc ;; [2022-01-11 14:36:06.983] 9: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.983] 10: len 0; hex ; asc ;; [2022-01-11 14:36:06.983] 11: len 0; hex ; asc ;; [2022-01-11 14:36:06.983] 12: len 8; hex 0000000000004390; asc C ;; [2022-01-11 14:36:06.999] 13: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 14: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 15: len 4; hex 80000002; asc ;; [2022-01-11 14:36:06.999] 16: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 17: len 0; hex ; asc ;; [2022-01-11 14:36:06.999] 18: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 19: len 0; hex ; asc ;; [2022-01-11 14:36:06.999] 20: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 21: len 0; hex ; asc ;; [2022-01-11 14:36:06.999] 22: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] [2022-01-11 14:36:06.999] Record lock, heap no 31 PHYSICAL RECORD: n_fields 23; compact format; info bits 0 [2022-01-11 14:36:06.999] 0: len 8; hex 000000000001b0a1; asc ;; [2022-01-11 14:36:06.999] 1: len 6; hex 00002719de4c; asc ' L;; [2022-01-11 14:36:06.999] 2: len 7; hex 81000004cf1fb3; asc ;; [2022-01-11 14:36:06.999] 3: len 12; hex 7b3136393930357d3e3d3930; asc {169905}>=90;; [2022-01-11 14:36:06.999] 4: len 30; hex 696e6f6465e4bdbfe794a8e78e875f52415445287b2346534e414d457d29; asc inode _RATE({#FSNAME}); (total 47 bytes); [2022-01-11 14:36:06.999] 5: len 0; hex ; asc ;; [2022-01-11 14:36:06.999] 6: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 7: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 8: len 4; hex 80000004; asc ;; [2022-01-11 14:36:06.999] 9: len 4; hex 80000000; asc ;; [2022-01-11 14:36:06.999] 10: len 0; hex ; asc ;; [2022-01-11 14:36:06.999] 11: len 0; hex ; asc ;; [2022-01-11 14:36:06.999] 12: len 8; hex 0000000000004391; asc C ;; [2022-01-11 14:36:07.013] 13: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.013] 14: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.013] 15: len 4; hex 80000002; asc ;; [2022-01-11 14:36:07.013] 16: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.013] 17: len 0; hex ; asc ;; [2022-01-11 14:36:07.013] 18: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.013] 19: len 0; hex ; asc ;; [2022-01-11 14:36:07.013] 20: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.013] 21: len 0; hex ; asc ;; [2022-01-11 14:36:07.013] 22: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.013] [2022-01-11 14:36:07.013] Record lock, heap no 32 PHYSICAL RECORD: n_fields 23; compact format; info bits 0 [2022-01-11 14:36:07.013] 0: len 8; hex 000000000001b0a2; asc ;; [2022-01-11 14:36:07.013] 1: len 6; hex 00002719de4c; asc ' L;; [2022-01-11 14:36:07.013] 2: len 7; hex 81000004cf1fc5; asc ;; [2022-01-11 14:36:07.013] 3: len 26; hex 7b3136393930367d3e3d7b244449534b5f43524954524154457d; asc {169906}>={$DISK_CRITRATE};; [2022-01-11 14:36:07.013] 4: len 30; hex 6469736be4bdbfe794a8e78e875f52415445287b2346534e414d457d2928; asc disk _RATE({#FSNAME})(; (total 46 bytes); [2022-01-11 14:36:07.013] 5: len 0; hex ; asc ;; [2022-01-11 14:36:07.013] 6: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.014] 7: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.014] 8: len 4; hex 80000004; asc ;; [2022-01-11 14:36:07.014] 9: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.014] 10: len 0; hex ; asc ;; [2022-01-11 14:36:07.030] 11: len 0; hex ; asc ;; [2022-01-11 14:36:07.030] 12: len 8; hex 000000000000438f; asc C ;; [2022-01-11 14:36:07.030] 13: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 14: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 15: len 4; hex 80000002; asc ;; [2022-01-11 14:36:07.030] 16: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 17: len 0; hex ; asc ;; [2022-01-11 14:36:07.030] 18: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 19: len 0; hex ; asc ;; [2022-01-11 14:36:07.030] 20: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 21: len 0; hex ; asc ;; [2022-01-11 14:36:07.030] 22: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] [2022-01-11 14:36:07.030] Record lock, heap no 33 PHYSICAL RECORD: n_fields 23; compact format; info bits 0 [2022-01-11 14:36:07.030] 0: len 8; hex 000000000001b0a3; asc ;; [2022-01-11 14:36:07.030] 1: len 6; hex 00002719de4c; asc ' L;; [2022-01-11 14:36:07.030] 2: len 7; hex 81000004cf1fd7; asc ;; [2022-01-11 14:36:07.030] 3: len 26; hex 7b3136393930377d3e3d7b244449534b5f5741524e524154457d; asc {169907}>={$DISK_WARNRATE};; [2022-01-11 14:36:07.030] 4: len 30; hex 6469736be4bdbfe794a8e78e875f52415445287b2346534e414d457d2928; asc disk _RATE({#FSNAME})(; (total 43 bytes); [2022-01-11 14:36:07.030] 5: len 0; hex ; asc ;; [2022-01-11 14:36:07.030] 6: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 7: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.030] 8: len 4; hex 80000002; asc ;; [2022-01-11 14:36:07.043] 9: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] 10: len 0; hex ; asc ;; [2022-01-11 14:36:07.043] 11: len 0; hex ; asc ;; [2022-01-11 14:36:07.043] 12: len 8; hex 000000000000438e; asc C ;; [2022-01-11 14:36:07.043] 13: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] 14: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] 15: len 4; hex 80000002; asc ;; [2022-01-11 14:36:07.043] 16: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] 17: len 0; hex ; asc ;; [2022-01-11 14:36:07.043] 18: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] 19: len 0; hex ; asc ;; [2022-01-11 14:36:07.043] 20: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] 21: len 0; hex ; asc ;; [2022-01-11 14:36:07.043] 22: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.043] [2022-01-11 14:36:07.043] [2022-01-11 14:36:07.043] *** (1) WAITING FOR THIS LOCK TO BE GRANTED: [2022-01-11 14:36:07.043] RECORD LOCKS space id 78 page no 4 n bits 136 index PRIMARY of table `zabbix`.`ids` trx id 2066005600 lock_mode X locks rec but not gap waiting [2022-01-11 14:36:07.043] Record lock, heap no 12 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 [2022-01-11 14:36:07.043] 0: len 15; hex 747269676765725f646570656e6473; asc trigger_depends;; [2022-01-11 14:36:07.043] 1: len 12; hex 747269676765726465706964; asc triggerdepid;; [2022-01-11 14:36:07.043] 2: len 6; hex 00007b24be54; asc {$ T;; [2022-01-11 14:36:07.043] 3: len 7; hex 01000000f3168e; asc ;; [2022-01-11 14:36:07.043] 4: len 8; hex 000000000001224e; asc "N;; [2022-01-11 14:36:07.060] [2022-01-11 14:36:07.060] [2022-01-11 14:36:07.060] *** (2) TRANSACTION: [2022-01-11 14:36:07.060] TRANSACTION 2066005588, ACTIVE 46 sec inserting [2022-01-11 14:36:07.060] mysql tables in use 1, locked 1 [2022-01-11 14:36:07.060] LOCK WAIT 360 lock struct(s), heap size 57552, 16146 row lock(s), undo log entries 4470 [2022-01-11 14:36:07.060] MySQL thread id 1244320, OS thread handle 140605889103616, query id 4967330389 localhost zabbix update [2022-01-11 14:36:07.060] INSERT INTO trigger_depends (triggerid_down,triggerid_up,triggerdepid) VALUES ('17828','17829','70863'),('17828','138172','70864'),('43686','43687','70865'),('43686','138173','70866'),('43695','43696','70867'),('43695','138174','70868'),('43713','43714','70869'),('43713','138175','70870'),('43722','43723','70871'),('43722','138176','70872'),('43731','43732','70873'),('43731','138177','70874'),('43740','43741','70875'),('43740','138178','70876'),('43749','43750','70877'),('43749','138179','70878'),('43758','43759','70879'),('43758','138180','70880'),('43767','43768','70881'),('43767','138181','70882'),('43833','43834','70883'),('43833','138182','70884'),('43842','43843','70885'),('43842','138183','70886'),('43851','43852','70887'),('43851','138184','70888'),('43860','43861','70889'),('43860','138185','70890'),('43869','43870','70891'),('43869','138186','70892'),('43878','43879','70893'),('43878','138187','70 [2022-01-11 14:36:07.079] [2022-01-11 14:36:07.079] *** (2) HOLDS THE LOCK(S): [2022-01-11 14:36:07.079] RECORD LOCKS space id 78 page no 4 n bits 136 index PRIMARY of table `zabbix`.`ids` trx id 2066005588 lock_mode X locks rec but not gap [2022-01-11 14:36:07.079] Record lock, heap no 12 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 [2022-01-11 14:36:07.079] 0: len 15; hex 747269676765725f646570656e6473; asc trigger_depends;; [2022-01-11 14:36:07.079] 1: len 12; hex 747269676765726465706964; asc triggerdepid;; [2022-01-11 14:36:07.079] 2: len 6; hex 00007b24be54; asc {$ T;; [2022-01-11 14:36:07.079] 3: len 7; hex 01000000f3168e; asc ;; [2022-01-11 14:36:07.079] 4: len 8; hex 000000000001224e; asc "N;; [2022-01-11 14:36:07.079] [2022-01-11 14:36:07.079] [2022-01-11 14:36:07.079] *** (2) WAITING FOR THIS LOCK TO BE GRANTED: [2022-01-11 14:36:07.079] RECORD LOCKS space id 234 page no 1199 n bits 176 index PRIMARY of table `zabbix`.`triggers` trx id 2066005588 lock mode S locks rec but not gap waiting [2022-01-11 14:36:07.079] Record lock, heap no 30 PHYSICAL RECORD: n_fields 23; compact format; info bits 0 [2022-01-11 14:36:07.108] 0: len 8; hex 000000000001b0a0; asc ;; [2022-01-11 14:36:07.108] 1: len 6; hex 00002719de4c; asc ' L;; [2022-01-11 14:36:07.108] 2: len 7; hex 81000004cf1fa1; asc ;; [2022-01-11 14:36:07.108] 3: len 12; hex 7b3136393930347d3e3d3830; asc {169904}>=80;; [2022-01-11 14:36:07.108] 4: len 30; hex 696e6f6465e4bdbfe794a8e78e875f52415445287b2346534e414d457d29; asc inode _RATE({#FSNAME}); (total 44 bytes); [2022-01-11 14:36:07.108] 5: len 0; hex ; asc ;; [2022-01-11 14:36:07.108] 6: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 7: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 8: len 4; hex 80000002; asc ;; [2022-01-11 14:36:07.108] 9: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 10: len 0; hex ; asc ;; [2022-01-11 14:36:07.108] 11: len 0; hex ; asc ;; [2022-01-11 14:36:07.108] 12: len 8; hex 0000000000004390; asc C ;; [2022-01-11 14:36:07.108] 13: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 14: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 15: len 4; hex 80000002; asc ;; [2022-01-11 14:36:07.108] 16: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 17: len 0; hex ; asc ;; [2022-01-11 14:36:07.108] 18: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 19: len 0; hex ; asc ;; [2022-01-11 14:36:07.108] 20: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] 21: len 0; hex ; asc ;; [2022-01-11 14:36:07.108] 22: len 4; hex 80000000; asc ;; [2022-01-11 14:36:07.108] [2022-01-11 14:36:07.108] *** WE ROLL BACK TRANSACTION (1)