701:20220107:143417.284 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+2 where table_name='triggers' and field_name='triggerid'] 701:20220107:143417.284 slow query: 45.048212 sec, "update ids set nextid=nextid+2 where table_name='triggers' and field_name='triggerid'" zabbix_server [701]: ERROR [file and function: , revision:422e00c66a, line:824] Something impossible has just happened. 701:20220107:143417.297 === Backtrace: === 700:20220107:143417.298 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+2 where table_name='triggers' and field_name='triggerid'] 700:20220107:143417.298 slow query: 45.071375 sec, "update ids set nextid=nextid+2 where table_name='triggers' and field_name='triggerid'" zabbix_server [700]: ERROR [file and function: , revision:422e00c66a, line:824] Something impossible has just happened. 700:20220107:143417.301 === Backtrace: === 704:20220107:143417.301 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+4 where table_name='triggers' and field_name='triggerid'] 704:20220107:143417.302 slow query: 45.072480 sec, "update ids set nextid=nextid+4 where table_name='triggers' and field_name='triggerid'" zabbix_server [704]: ERROR [file and function: , revision:422e00c66a, line:824] Something impossible has just happened. 704:20220107:143417.304 === Backtrace: === 703:20220107:143417.305 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+4 where table_name='triggers' and field_name='triggerid'] 703:20220107:143417.305 slow query: 45.071262 sec, "update ids set nextid=nextid+4 where table_name='triggers' and field_name='triggerid'" zabbix_server [703]: ERROR [file and function: , revision:422e00c66a, line:824] Something impossible has just happened. 703:20220107:143417.309 === Backtrace: === 700:20220107:143417.322 13: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](zbx_backtrace+0x52) [0x563150702809] 700:20220107:143417.323 12: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](+0x26ceab) [0x563150777eab] 700:20220107:143417.323 11: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](DBget_maxid_num+0x112) [0x56315077804f] 700:20220107:143417.323 10: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](+0x1610e9) [0x56315066c0e9] 700:20220107:143417.323 9: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](lld_update_triggers+0x2e9) [0x56315066effe] 700:20220107:143417.323 8: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](lld_process_discovery_rule+0x5a1) [0x563150646574] 703:20220107:143417.323 13: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](zbx_backtrace+0x52) [0x563150702809] 703:20220107:143417.323 12: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](+0x26ceab) [0x563150777eab] 703:20220107:143417.323 11: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](DBget_maxid_num+0x112) [0x56315077804f] 703:20220107:143417.323 10: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](+0x1610e9) [0x56315066c0e9] 703:20220107:143417.323 9: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](lld_update_triggers+0x2e9) [0x56315066effe] 703:20220107:143417.323 8: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](lld_process_discovery_rule+0x5a1) [0x563150646574] 703:20220107:143417.323 7: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](+0x137823) [0x563150642823] 703:20220107:143417.323 6: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](lld_worker_thread+0x36c) [0x563150642f74] 703:20220107:143417.323 5: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](zbx_thread_start+0x3b) [0x563150712dd7] 704:20220107:143417.323 13: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](zbx_backtrace+0x52) [0x563150702809] 700:20220107:143417.323 7: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](+0x137823) [0x563150642823] 700:20220107:143417.323 6: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](lld_worker_thread+0x36c) [0x563150642f74] 700:20220107:143417.323 5: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](zbx_thread_start+0x3b) [0x563150712dd7] 700:20220107:143417.323 4: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](MAIN_ZABBIX_ENTRY+0xfef) [0x563150556939] 704:20220107:143417.323 12: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](+0x26ceab) [0x563150777eab] 704:20220107:143417.323 11: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](DBget_maxid_num+0x112) [0x56315077804f] 704:20220107:143417.323 10: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](+0x1610e9) [0x56315066c0e9] 704:20220107:143417.323 9: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](lld_update_triggers+0x2e9) [0x56315066effe] 704:20220107:143417.323 8: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](lld_process_discovery_rule+0x5a1) [0x563150646574] 704:20220107:143417.323 7: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](+0x137823) [0x563150642823] 704:20220107:143417.323 6: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](lld_worker_thread+0x36c) [0x563150642f74] 704:20220107:143417.323 5: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](zbx_thread_start+0x3b) [0x563150712dd7] 704:20220107:143417.323 4: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](MAIN_ZABBIX_ENTRY+0xfef) [0x563150556939] 704:20220107:143417.323 3: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](daemon_start+0x303) [0x56315070234b] 704:20220107:143417.323 2: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](main+0x309) [0x5631505558e7] 704:20220107:143417.323 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f566fa700b3] 701:20220107:143417.323 13: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](zbx_backtrace+0x52) [0x563150702809] 701:20220107:143417.323 12: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](+0x26ceab) [0x563150777eab] 701:20220107:143417.323 11: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](DBget_maxid_num+0x112) [0x56315077804f] 701:20220107:143417.323 10: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](+0x1610e9) [0x56315066c0e9] 701:20220107:143417.323 9: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](lld_update_triggers+0x2e9) [0x56315066effe] 701:20220107:143417.323 8: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](lld_process_discovery_rule+0x5a1) [0x563150646574] 701:20220107:143417.323 7: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](+0x137823) [0x563150642823] 701:20220107:143417.323 6: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](lld_worker_thread+0x36c) [0x563150642f74] 701:20220107:143417.323 5: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](zbx_thread_start+0x3b) [0x563150712dd7] 701:20220107:143417.323 4: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](MAIN_ZABBIX_ENTRY+0xfef) [0x563150556939] 701:20220107:143417.323 3: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](daemon_start+0x303) [0x56315070234b] 701:20220107:143417.323 2: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](main+0x309) [0x5631505558e7] 701:20220107:143417.324 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f566fa700b3] 701:20220107:143417.324 0: /usr/sbin/zabbix_server: lld worker #2 [processed 28 LLD rules, idle 4.759152 sec during 5.189698 sec](_start+0x2e) [0x56315055488e] 700:20220107:143417.324 3: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](daemon_start+0x303) [0x56315070234b] 700:20220107:143417.324 2: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](main+0x309) [0x5631505558e7] 700:20220107:143417.324 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f566fa700b3] 700:20220107:143417.324 0: /usr/sbin/zabbix_server: lld worker #1 [processed 35 LLD rules, idle 4.779111 sec during 5.184204 sec](_start+0x2e) [0x56315055488e] 703:20220107:143417.324 4: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](MAIN_ZABBIX_ENTRY+0xfef) [0x563150556939] 703:20220107:143417.324 3: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](daemon_start+0x303) [0x56315070234b] 703:20220107:143417.324 2: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](main+0x309) [0x5631505558e7] 703:20220107:143417.324 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f566fa700b3] 703:20220107:143417.324 0: /usr/sbin/zabbix_server: lld worker #4 [processed 35 LLD rules, idle 4.871734 sec during 5.301117 sec](_start+0x2e) [0x56315055488e] 704:20220107:143417.324 0: /usr/sbin/zabbix_server: lld worker #5 [processed 27 LLD rules, idle 4.793368 sec during 5.192698 sec](_start+0x2e) [0x56315055488e] 702:20220107:143417.362 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+1 where table_name='trigger_depends' and field_name='triggerdepid'] 702:20220107:143417.362 slow query: 45.143978 sec, "update ids set nextid=nextid+1 where table_name='trigger_depends' and field_name='triggerdepid'" zabbix_server [702]: ERROR [file and function: , revision:422e00c66a, line:824] Something impossible has just happened. 702:20220107:143417.365 === Backtrace: === 702:20220107:143417.366 13: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](zbx_backtrace+0x52) [0x563150702809] 702:20220107:143417.366 12: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](+0x26ceab) [0x563150777eab] 702:20220107:143417.366 11: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](DBget_maxid_num+0x112) [0x56315077804f] 702:20220107:143417.366 10: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](+0x16124a) [0x56315066c24a] 702:20220107:143417.366 9: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](lld_update_triggers+0x2e9) [0x56315066effe] 702:20220107:143417.366 8: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](lld_process_discovery_rule+0x5a1) [0x563150646574] 702:20220107:143417.366 7: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](+0x137823) [0x563150642823] 702:20220107:143417.366 6: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](lld_worker_thread+0x36c) [0x563150642f74] 702:20220107:143417.366 5: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](zbx_thread_start+0x3b) [0x563150712dd7] 702:20220107:143417.366 4: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](MAIN_ZABBIX_ENTRY+0xfef) [0x563150556939] 702:20220107:143417.366 3: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](daemon_start+0x303) [0x56315070234b] 702:20220107:143417.366 2: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](main+0x309) [0x5631505558e7] 702:20220107:143417.366 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f566fa700b3] 702:20220107:143417.366 0: /usr/sbin/zabbix_server: lld worker #3 [processed 31 LLD rules, idle 4.703067 sec during 5.107193 sec](_start+0x2e) [0x56315055488e]