14616:20180418:155830.349 trapper #1 [processing data] 14616:20180418:155830.349 trapper got '{"request":"auto registration","host":"proxy.server.name","data":[{"clock":1524085109,"host":"duplicate.test.server.us","ip":"xxx.xxx.xxx.xxx","port":"10050","host_metadata":"Linux,tst,alpha,int"}],"clock":1524085110,"ns":349502021}' 14616:20180418:155830.349 In recv_areg_data() 14616:20180418:155830.350 query [txnlev:0] [select hostid,status from hosts where host='proxy.server.name' and status in (5,6)] 14616:20180418:155830.350 In process_areg_data() 14616:20180418:155830.350 query [txnlev:1] [begin;] 14616:20180418:155830.351 query [txnlev:1] [select hostid from hosts where proxy_hostid=10237 and host='duplicate.test.server.us'] 14616:20180418:155830.352 query [txnlev:1] [select autoreg_hostid from autoreg_host where proxy_hostid=10237 and host='duplicate.test.server.us'] 14616:20180418:155830.354 query [txnlev:1] [update autoreg_host set listen_ip='xxx.xxx.xxx.xxx',listen_dns='',listen_port=10050,host_metadata='Linux,tst,alpha,int' where autoreg_hostid=358] 14616:20180418:155830.355 In process_events() events_num:1 14616:20180418:155830.355 In DCget_nextid() table:'events' num:1 14616:20180418:155830.355 End of DCget_nextid() table:'events' [105226:105226] 14616:20180418:155830.355 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (105226,2,3,358,1524085109,0,1); ] 14616:20180418:155830.356 In process_actions() events_num:1 14616:20180418:155830.356 query [txnlev:1] [select actionid,evaltype,formula from actions where status=0 and eventsource=2] 14616:20180418:155830.357 In check_action_conditions() actionid:8 14616:20180418:155830.357 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=8 order by conditiontype] 14616:20180418:155830.358 In check_action_condition() actionid:8 conditionid:12 cond.value:'.domain.suffix' 14616:20180418:155830.358 In check_auto_registration_condition() 14616:20180418:155830.358 query [txnlev:1] [select host from autoreg_host where autoreg_hostid=358] 14616:20180418:155830.359 End of check_auto_registration_condition():SUCCEED 14616:20180418:155830.359 End of check_action_condition():SUCCEED 14616:20180418:155830.359 In check_action_condition() actionid:8 conditionid:11 cond.value:'Linux' 14616:20180418:155830.359 In check_auto_registration_condition() 14616:20180418:155830.359 query [txnlev:1] [select host_metadata from autoreg_host where autoreg_hostid=358] 14616:20180418:155830.360 End of check_auto_registration_condition():SUCCEED 14616:20180418:155830.360 End of check_action_condition():SUCCEED 14616:20180418:155830.360 End of check_action_conditions():SUCCEED 14616:20180418:155830.360 In DCget_nextid() table:'escalations' num:1 14616:20180418:155830.360 End of DCget_nextid() table:'escalations' [17:17] 14616:20180418:155830.360 In execute_operations() actionid:8 14616:20180418:155830.361 query [txnlev:1] [select o.operationtype,g.groupid,t.templateid from operations o left join opgroup g on g.operationid=o.operationid left join optemplate t on t.operationid=o.operationid where o.actionid=8] 14616:20180418:155830.361 In op_host_add() 14616:20180418:155830.361 In add_discovered_host() eventid:105226 14616:20180418:155830.361 query [txnlev:1] [select proxy_hostid,host,listen_ip,listen_dns,listen_port from autoreg_host where autoreg_hostid=358] 14616:20180418:155830.362 query [txnlev:1] [select null from hosts where host='duplicate.test.server.us' and status=3] 14616:20180418:155830.363 query [txnlev:1] [select hostid,proxy_hostid from hosts where host='duplicate.test.server.us' and flags<>2 and status in (0,1) order by hostid limit 1] 14616:20180418:155830.364 In DBget_nextid() tablename:'hosts' 14616:20180418:155830.364 query [txnlev:1] [select nextid from ids where table_name='hosts' and field_name='hostid'] 14616:20180418:155830.365 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts' and field_name='hostid'] 14616:20180418:155830.845 query [txnlev:1] [select nextid from ids where table_name='hosts' and field_name='hostid'] 14616:20180418:155830.846 query [txnlev:1] [select nextid from ids where table_name='hosts' and field_name='hostid'] 14616:20180418:155830.847 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts' and field_name='hostid'] 14616:20180418:155830.848 query [txnlev:1] [select nextid from ids where table_name='hosts' and field_name='hostid'] 14616:20180418:155830.849 End of DBget_nextid():10427 table:'hosts' recid:'hostid' 14616:20180418:155830.849 query [txnlev:1] [insert into hosts (hostid,proxy_hostid,host,name,description) values (10427,10237,'duplicate.test.server.us','duplicate.test.server.us','')] 14616:20180418:155830.850 In DBadd_interface() 14616:20180418:155830.850 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10427 and type=1] 14616:20180418:155830.851 In DBget_nextid() tablename:'interface' 14616:20180418:155830.851 query [txnlev:1] [select nextid from ids where table_name='interface' and field_name='interfaceid'] 14616:20180418:155830.852 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='interface' and field_name='interfaceid'] 14616:20180418:155830.853 query [txnlev:1] [select nextid from ids where table_name='interface' and field_name='interfaceid'] 14616:20180418:155830.854 query [txnlev:1] [select nextid from ids where table_name='interface' and field_name='interfaceid'] 14616:20180418:155830.855 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='interface' and field_name='interfaceid'] 14616:20180418:155830.856 query [txnlev:1] [select nextid from ids where table_name='interface' and field_name='interfaceid'] 14616:20180418:155830.857 End of DBget_nextid():196 table:'interface' recid:'interfaceid' 14616:20180418:155830.857 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (196,10427,1,1,1,'xxx.xxx.xxx.xxx','',10050)] 14616:20180418:155830.857 End of DBadd_interface():196 14616:20180418:155830.857 In add_discovered_host_groups() 14616:20180418:155830.857 query [txnlev:1] [select groupid from hosts_groups where hostid=10427 and groupid=5] 14616:20180418:155830.858 In DBget_nextid() tablename:'hosts_groups' 14616:20180418:155830.858 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 14616:20180418:155830.858 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts_groups' and field_name='hostgroupid'] 14616:20180418:155830.859 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 14616:20180418:155830.859 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 14616:20180418:155830.860 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts_groups' and field_name='hostgroupid'] 14616:20180418:155830.860 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 14616:20180418:155830.861 End of DBget_nextid():1600 table:'hosts_groups' recid:'hostgroupid' 14616:20180418:155830.861 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (1600,10427,5); ] 14616:20180418:155830.861 End of add_discovered_host_groups() 14616:20180418:155830.861 End of add_discovered_host() 14616:20180418:155830.861 End of op_host_add() 14616:20180418:155830.861 In op_template_add() 14616:20180418:155830.861 In add_discovered_host() eventid:105226 14616:20180418:155830.861 query [txnlev:1] [select proxy_hostid,host,listen_ip,listen_dns,listen_port from autoreg_host where autoreg_hostid=358] 14616:20180418:155830.862 query [txnlev:1] [select null from hosts where host='duplicate.test.server.us' and status=3] 14616:20180418:155830.862 query [txnlev:1] [select hostid,proxy_hostid from hosts where host='duplicate.test.server.us' and flags<>2 and status in (0,1) order by hostid limit 1] 14616:20180418:155830.863 In DBadd_interface() 14616:20180418:155830.863 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10427 and type=1] 14616:20180418:155830.863 In substitute_simple_macros() data:'10050' 14616:20180418:155830.864 End of DBadd_interface():196 14616:20180418:155830.864 End of add_discovered_host() 14616:20180418:155830.864 In DBcopy_template_elements() 14616:20180418:155830.864 query [txnlev:1] [select templateid from hosts_templates where hostid=10427] 14616:20180418:155830.864 In validate_linked_templates() 14616:20180418:155830.864 query [txnlev:1] [select t1.description,h2.host from items i1,functions f1,triggers t1,functions f2,items i2,hosts h2 where i1.itemid=f1.itemid and f1.triggerid=t1.triggerid and t1.triggerid=f2.triggerid and f2.itemid=i2.itemid and i2.hostid=h2.hostid and h2.status=3 and i1.hostid=10096 and not i2.hostid=10096 limit 1] 14616:20180418:155830.866 query [txnlev:1] [select t1.description,h1.host,t2.description as description2,h2.host as host2 from trigger_depends td,triggers t1,functions f1,items i1,hosts h1,triggers t2,functions f2,items i2,hosts h2 where td.triggerid_down=t1.triggerid and t1.triggerid=f1.triggerid and f1.itemid=i1.itemid and i1.hostid=h1.hostid and td.triggerid_up=t2.triggerid and t2.triggerid=f2.triggerid and f2.itemid=i2.itemid and i2.hostid=h2.hostid and i1.hostid=10096 and not i2.hostid=10096 and h2.status=3 limit 1] 14616:20180418:155830.868 End of validate_linked_templates():SUCCEED 14616:20180418:155830.868 In validate_host() 14616:20180418:155830.868 In validate_inventory_links() 14616:20180418:155830.868 query [txnlev:1] [select inventory_link,count(*) from items where inventory_link<>0 and hostid=10096 group by inventory_link having count(*)>1 limit 1] 14616:20180418:155830.869 query [txnlev:1] [select ti.itemid from items ti,items i where ti.key_<>i.key_ and ti.inventory_link=i.inventory_link and ti.hostid=10096 and i.hostid=10427 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10096 and items.key_=i.key_) limit 1] 14616:20180418:155830.869 End of validate_inventory_links():SUCCEED 14616:20180418:155830.869 In validate_httptests() 14616:20180418:155830.869 query [txnlev:1] [select t.httptestid,t.name,h.httptestid from httptest t inner join httptest h on h.name=t.name and h.hostid=10427 where t.hostid=10096] 14616:20180418:155830.870 End of validate_httptests():SUCCEED 14616:20180418:155830.870 query [txnlev:1] [select distinct g.graphid,g.name,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10096] 14616:20180418:155830.871 In DBget_graphitems() 14616:20180418:155830.871 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=2 order by i.key_] 14616:20180418:155830.871 DBget_graphitems() [0] itemid:0 key:'net.if.in[{#IFNAME}]' 14616:20180418:155830.871 DBget_graphitems() [1] itemid:0 key:'net.if.out[{#IFNAME}]' 14616:20180418:155830.871 End of DBget_graphitems() 14616:20180418:155830.871 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Network traffic on {#IFNAME}' and g.templateid is null] 14616:20180418:155830.872 In DBget_graphitems() 14616:20180418:155830.872 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=6 order by i.key_] 14616:20180418:155830.872 DBget_graphitems() [0] itemid:0 key:'system.cpu.intr' 14616:20180418:155830.872 DBget_graphitems() [1] itemid:0 key:'system.cpu.switches' 14616:20180418:155830.873 End of DBget_graphitems() 14616:20180418:155830.873 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='CPU jumps' and g.templateid is null] 14631:20180418:155830.873 timer #4 [processed 0 triggers, 0 events in 0.000096 sec, processing time functions] 14631:20180418:155830.873 In process_time_functions() 14631:20180418:155830.873 End of process_time_functions() 14631:20180418:155830.873 timer #4 [processed 0 triggers, 0 events in 0.000104 sec, idle 30 sec] 14616:20180418:155830.873 In DBget_graphitems() 14616:20180418:155830.873 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=8 order by i.key_] 14616:20180418:155830.874 DBget_graphitems() [0] itemid:0 key:'system.cpu.load[percpu,avg15]' 14616:20180418:155830.874 DBget_graphitems() [1] itemid:0 key:'system.cpu.load[percpu,avg1]' 14616:20180418:155830.874 DBget_graphitems() [2] itemid:0 key:'system.cpu.load[percpu,avg5]' 14616:20180418:155830.874 End of DBget_graphitems() 14616:20180418:155830.874 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='CPU load' and g.templateid is null] 14616:20180418:155830.875 In DBget_graphitems() 14616:20180418:155830.875 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=10 order by i.key_] 14616:20180418:155830.875 DBget_graphitems() [0] itemid:0 key:'system.cpu.util[,idle]' 14616:20180418:155830.875 DBget_graphitems() [1] itemid:0 key:'system.cpu.util[,interrupt]' 14616:20180418:155830.875 DBget_graphitems() [2] itemid:0 key:'system.cpu.util[,iowait]' 14616:20180418:155830.875 DBget_graphitems() [3] itemid:0 key:'system.cpu.util[,nice]' 14616:20180418:155830.875 DBget_graphitems() [4] itemid:0 key:'system.cpu.util[,softirq]' 14616:20180418:155830.875 DBget_graphitems() [5] itemid:0 key:'system.cpu.util[,steal]' 14616:20180418:155830.875 DBget_graphitems() [6] itemid:0 key:'system.cpu.util[,system]' 14616:20180418:155830.876 DBget_graphitems() [7] itemid:0 key:'system.cpu.util[,user]' 14616:20180418:155830.876 End of DBget_graphitems() 14616:20180418:155830.876 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='CPU utilization' and g.templateid is null] 14616:20180418:155830.876 In DBget_graphitems() 14616:20180418:155830.876 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=18 order by i.key_] 14616:20180418:155830.877 DBget_graphitems() [0] itemid:0 key:'system.swap.size[,free]' 14616:20180418:155830.877 DBget_graphitems() [1] itemid:0 key:'system.swap.size[,total]' 14616:20180418:155830.877 End of DBget_graphitems() 14616:20180418:155830.877 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Swap usage' and g.templateid is null] 14616:20180418:155830.878 In DBget_graphitems() 14616:20180418:155830.878 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=16 order by i.key_] 14616:20180418:155830.878 DBget_graphitems() [0] itemid:0 key:'system.swap.size[,pfree]' 14616:20180418:155830.878 DBget_graphitems() [1] itemid:0 key:'vm.memory.percent_used' 14616:20180418:155830.878 End of DBget_graphitems() 14616:20180418:155830.878 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Memory Usage' and g.templateid is null] 14616:20180418:155830.879 In DBget_graphitems() 14616:20180418:155830.879 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=13 order by i.key_] 14616:20180418:155830.879 DBget_graphitems() [0] itemid:0 key:'vfs.dev.read[,sps]' 14616:20180418:155830.879 DBget_graphitems() [1] itemid:0 key:'vfs.dev.write[,sps]' 14616:20180418:155830.879 End of DBget_graphitems() 14616:20180418:155830.880 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Disk IO' and g.templateid is null] 14616:20180418:155830.880 In DBget_graphitems() 14616:20180418:155830.880 query [txnlev:1] [select 0,0,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=1 order by i.key_] 14616:20180418:155830.881 DBget_graphitems() [0] itemid:0 key:'vfs.fs.size[{#FSNAME},free]' 14616:20180418:155830.881 DBget_graphitems() [1] itemid:0 key:'vfs.fs.size[{#FSNAME},total]' 14616:20180418:155830.881 End of DBget_graphitems() 14616:20180418:155830.881 query [txnlev:1] [select distinct g.graphid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Disk space usage {#FSNAME}' and g.templateid is null] 14616:20180418:155830.881 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10427 and t.hostid=10096 limit 1] 14616:20180418:155830.882 query [txnlev:1] [select type,interfaceid from interface where hostid=10427 and type in (1,2,3,4) and main=1] 14616:20180418:155830.882 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,9,11,15) and hostid=10096] 14616:20180418:155830.883 In validate_host():SUCCEED 14616:20180418:155830.883 In DBget_nextid() tablename:'hosts_templates' 14616:20180418:155830.883 query [txnlev:1] [select nextid from ids where table_name='hosts_templates' and field_name='hosttemplateid'] 14616:20180418:155830.883 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts_templates' and field_name='hosttemplateid'] 14616:20180418:155830.884 query [txnlev:1] [select nextid from ids where table_name='hosts_templates' and field_name='hosttemplateid'] 14616:20180418:155830.884 query [txnlev:1] [select nextid from ids where table_name='hosts_templates' and field_name='hosttemplateid'] 14616:20180418:155830.884 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts_templates' and field_name='hosttemplateid'] 14616:20180418:155830.885 query [txnlev:1] [select nextid from ids where table_name='hosts_templates' and field_name='hosttemplateid'] 14616:20180418:155830.885 End of DBget_nextid():548 table:'hosts_templates' recid:'hosttemplateid' 14616:20180418:155830.885 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (548,10427,10096)] 14616:20180418:155830.886 In DBcopy_template_applications() 14616:20180418:155830.886 query [txnlev:1] [select applicationid,hostid,name from applications where hostid=10427 or hostid=10096] 14616:20180418:155830.886 In DBget_nextid() tablename:'applications' 14616:20180418:155830.886 query [txnlev:1] [select nextid from ids where table_name='applications' and field_name='applicationid'] 14616:20180418:155830.887 query [txnlev:1] [update ids set nextid=nextid+14 where table_name='applications' and field_name='applicationid'] 14616:20180418:155830.887 query [txnlev:1] [select nextid from ids where table_name='applications' and field_name='applicationid'] 14616:20180418:155830.887 query [txnlev:1] [select nextid from ids where table_name='applications' and field_name='applicationid'] 14616:20180418:155830.888 query [txnlev:1] [update ids set nextid=nextid+14 where table_name='applications' and field_name='applicationid'] 14616:20180418:155830.888 query [txnlev:1] [select nextid from ids where table_name='applications' and field_name='applicationid'] 14633:20180418:155830.888 timer #6 [processed 0 triggers, 0 events in 0.000073 sec, processing time functions] 14633:20180418:155830.888 In process_time_functions() 14633:20180418:155830.888 End of process_time_functions() 14633:20180418:155830.888 timer #6 [processed 0 triggers, 0 events in 0.000092 sec, idle 30 sec] 14616:20180418:155830.889 End of DBget_nextid():3587 table:'applications' recid:'applicationid' 14616:20180418:155830.889 query [txnlev:1] [insert into applications (applicationid,hostid,name) values (3587,10427,'CPU'),(3588,10427,'Filesystems'),(3589,10427,'General'),(3590,10427,'ICMP'),(3591,10427,'Inventory Information'),(3592,10427,'Logstash Agent'),(3593,10427,'Memory'),(3594,10427,'Network interfaces'),(3595,10427,'OS'),(3596,10427,'Performance'),(3597,10427,'Processes'),(3598,10427,'Security'),(3599,10427,'SSH'),(3600,10427,'Zabbix agent'); ] 14629:20180418:155830.889 timer #2 [processed 0 triggers, 0 events in 0.000065 sec, processing time functions] 14629:20180418:155830.889 In process_time_functions() 14629:20180418:155830.889 End of process_time_functions() 14629:20180418:155830.889 timer #2 [processed 0 triggers, 0 events in 0.000111 sec, idle 30 sec] 14616:20180418:155830.889 In DBget_nextid() tablename:'application_template' 14616:20180418:155830.889 query [txnlev:1] [select nextid from ids where table_name='application_template' and field_name='application_templateid'] 14616:20180418:155830.890 query [txnlev:1] [update ids set nextid=nextid+14 where table_name='application_template' and field_name='application_templateid'] 14616:20180418:155830.890 query [txnlev:1] [select nextid from ids where table_name='application_template' and field_name='application_templateid'] 14616:20180418:155830.891 query [txnlev:1] [select nextid from ids where table_name='application_template' and field_name='application_templateid'] 14616:20180418:155830.891 query [txnlev:1] [update ids set nextid=nextid+14 where table_name='application_template' and field_name='application_templateid'] 14616:20180418:155830.892 query [txnlev:1] [select nextid from ids where table_name='application_template' and field_name='application_templateid'] 14616:20180418:155830.892 End of DBget_nextid():3393 table:'application_template' recid:'application_templateid' 14616:20180418:155830.892 query [txnlev:1] [insert into application_template (application_templateid,applicationid,templateid) values (3393,3587,3),(3394,3588,30),(3395,3589,31),(3396,3590,28),(3397,3591,33),(3398,3592,29),(3399,3593,4),(3400,3594,5),(3401,3595,6),(3402,3596,7),(3403,3597,32),(3404,3598,8),(3405,3599,34),(3406,3600,35); ] 14632:20180418:155830.893 timer #5 [processed 0 triggers, 0 events in 0.000346 sec, processing time functions] 14632:20180418:155830.893 In process_time_functions() 14632:20180418:155830.893 End of process_time_functions() 14632:20180418:155830.893 timer #5 [processed 0 triggers, 0 events in 0.000133 sec, idle 30 sec] 14616:20180418:155830.893 End of DBcopy_template_applications() 14616:20180418:155830.893 In DBcopy_template_items() 14616:20180418:155830.893 query [txnlev:1] [select type,interfaceid from interface where hostid=10427 and type in (1,2,3,4) and main=1] 14616:20180418:155830.894 query [txnlev:1] [select ti.itemid,ti.name,ti.key_,ti.type,ti.value_type,ti.data_type,ti.delay,ti.delay_flex,ti.history,ti.trends,ti.status,ti.trapper_hosts,ti.units,ti.multiplier,ti.delta,ti.formula,ti.logtimefmt,ti.valuemapid,ti.params,ti.ipmi_sensor,ti.snmp_community,ti.snmp_oid,ti.snmpv3_securityname,ti.snmpv3_securitylevel,ti.snmpv3_authprotocol,ti.snmpv3_authpassphrase,ti.snmpv3_privprotocol,ti.snmpv3_privpassphrase,ti.authtype,ti.username,ti.password,ti.publickey,ti.privatekey,ti.flags,ti.description,ti.inventory_link,ti.lifetime,ti.snmpv3_contextname,hi.itemid,ti.evaltype,ti.port from items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where ti.hostid=10096] 14616:20180418:155830.895 query [txnlev:1] [select item_conditionid,itemid,operator,macro,value from item_condition where itemid in (210,211)] 14630:20180418:155830.896 timer #3 [processed 0 triggers, 0 events in 0.000352 sec, processing time functions] 14628:20180418:155830.896 timer #1 [processed 0 triggers, 0 events in 0.000095 sec, 0 maintenances in 0.001934 sec, processing time functions] 14630:20180418:155830.897 In process_time_functions() 14628:20180418:155830.897 In process_time_functions() 14616:20180418:155830.897 In DBget_nextid() tablename:'item_condition' 14630:20180418:155830.898 End of process_time_functions() 14628:20180418:155830.898 End of process_time_functions() 14616:20180418:155830.898 query [txnlev:1] [select nextid from ids where table_name='item_condition' and field_name='item_conditionid'] 14630:20180418:155830.898 timer #3 [processed 0 triggers, 0 events in 0.001643 sec, idle 30 sec] 14628:20180418:155830.898 timer #1 [processed 0 triggers, 0 events in 0.001619 sec, 0 maintenances in 0.000000 sec, idle 30 sec] 14616:20180418:155830.898 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='item_condition' and field_name='item_conditionid'] 14616:20180418:155830.899 query [txnlev:1] [select nextid from ids where table_name='item_condition' and field_name='item_conditionid'] 14616:20180418:155830.899 query [txnlev:1] [select nextid from ids where table_name='item_condition' and field_name='item_conditionid'] 14616:20180418:155830.900 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='item_condition' and field_name='item_conditionid'] 14616:20180418:155830.900 query [txnlev:1] [select nextid from ids where table_name='item_condition' and field_name='item_conditionid'] 14616:20180418:155830.900 End of DBget_nextid():305 table:'item_condition' recid:'item_conditionid' 14616:20180418:155830.900 In DBget_nextid() tablename:'items' 14616:20180418:155830.900 query [txnlev:1] [select nextid from ids where table_name='items' and field_name='itemid'] 14616:20180418:155830.901 query [txnlev:1] [update ids set nextid=nextid+66 where table_name='items' and field_name='itemid'] 14616:20180418:155830.901 query [txnlev:1] [select nextid from ids where table_name='items' and field_name='itemid'] 14616:20180418:155830.902 query [txnlev:1] [select nextid from ids where table_name='items' and field_name='itemid'] 14616:20180418:155830.902 query [txnlev:1] [update ids set nextid=nextid+66 where table_name='items' and field_name='itemid'] 14616:20180418:155830.902 query [txnlev:1] [select nextid from ids where table_name='items' and field_name='itemid'] 14616:20180418:155830.903 End of DBget_nextid():27235 table:'items' recid:'itemid' 14616:20180418:155830.904 query [txnlev:1] [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,templateid,flags,description,inventory_link,interfaceid,lifetime,snmpv3_contextname,evaltype,port) values (27235,'Host name of zabbix_agentd running','agent.hostname',10427,7,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',201,0,'',0,null,'30','',0,''),(27236,'Agent ping','agent.ping',10427,7,3,0,60,'',7,365,0,'','',0,0,'1','',10,'','','','','',0,0,'',0,'',0,'','','','',199,0,'The agent always returns 1 for this item. It could be used in combination with nodata() for availability check.',0,null,'30','',0,''),(27237,'Version of zabbix_agent(d) running','agent.version',10427,7,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',203,0,'',0,null,'30','',0,''),(27238,'ICMP ping','icmpping',10427,3,3,0,60,'',7,365,0,'','',0,0,'1','',1,'','','','','',0,0,'',0,'',0,'','','','',180,0,'',0,196,'30','',0,''),(27239,'ICMP loss','icmppingloss',10427,3,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',179,0,'',0,196,'30','',0,''),(27240,'ICMP response time','icmppingsec',10427,3,0,0,60,'',7,365,0,'','s',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',181,0,'',0,196,'30','',0,''),(27241,'Maximum number of opened files','kernel.maxfiles',10427,7,3,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',21,0,'It could be increased by using sysctrl utility or modifying file /etc/sysctl.conf.',0,null,'30','',0,''),(27242,'Maximum number of processes','kernel.maxproc',10427,7,3,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',22,0,'It could be increased by using sysctrl utility or modifying file /etc/sysctl.conf.',0,null,'30','',0,''),(27243,'Network interface discovery','net.if.discovery',10427,7,4,0,3600,'',90,365,0,'','',0,0,'','',null,'','','','','',0,0,'',0,'',0,'','','','',211,1,'Discovery of network interfaces as defined in global regular expression "Network interfaces for discovery".',0,null,'30','',0,''),(27244,'Incoming network traffic on $1','net.if.in[{#IFNAME}]',10427,7,3,0,60,'',7,365,0,'','bps',1,1,'8','',null,'','','','','',0,0,'',0,'',0,'','','','',219,2,'',0,null,'30','',0,''),(27245,'Outgoing network traffic on $1','net.if.out[{#IFNAME}]',10427,7,3,0,60,'',7,365,0,'','bps',1,1,'8','',null,'','','','','',0,0,'',0,'',0,'','','','',220,2,'',0,null,'30','',0,''),(27246,'SSH listening','net.tcp.service[ssh]',10427,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',197,0,'',0,196,'30','',0,''),(27247,'Number of running processes','proc.num[,,run]',10427,7,3,0,60,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',28,0,'Number of processes in running state.',0,null,'30','',0,''),(27248,'Logstash agent process','proc.num[java,,,/logstash/]',10427,7,3,0,600,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',182,0,'',0,null,'30','',0,''),(27249,'NTPD Process Count','proc.num[ntpd,ntp,,]',10427,7,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',25,0,'',0,null,'30','',0,''),(27250,'Active Checks','proc.num[zabbix_agentd,zabbix,,: active checks]',10427,7,3,0,60,'',7,90,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',198,0,'',0,null,'30','',0,''),(27251,'Collector','proc.num[zabbix_agentd,zabbix,,: collector]',10427,7,3,0,60,'',7,90,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',200,0,'',0,null,'30','',0,''),(27252,'Listener','proc.num[zabbix_agentd,zabbix,,: listener]',10427,7,3,0,60,'',7,90,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',202,0,'',0,null,'30','',0,''),(27253,'Number of processes','proc.num[]',10427,7,3,0,60,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',27,0,'Total number of processes in any state.',0,null,'30','',0,''),(27254,'Host boot time','system.boottime',10427,7,3,0,600,'',7,365,0,'','unixtime',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',18,0,'',0,null,'30','',0,''),(27255,'Interrupts per second','system.cpu.intr',10427,7,3,0,60,'',7,365,0,'','ips',0,1,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',20,0,'',0,null,'30','',0,''),(27256,'Processor load (15 min average per core)','system.cpu.load[percpu,avg15]',10427,7,0,0,60,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',31,0,'The processor load is calculated as system CPU load divided by number of CPU cores.',0,null,'30','',0,''),(27257,'Processor load (1 min average per core)','system.cpu.load[percpu,avg1]',10427,7,0,0,60,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',29,0,'The processor load is calculated as system CPU load divided by number of CPU cores.',0,null,'30','',0,''),(27258,'Processor load (5 min average per core)','system.cpu.load[percpu,avg5]',10427,7,0,0,60,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',30,0,'The processor load is calculated as system CPU load divided by number of CPU cores.',0,null,'30','',0,''),(27259,'Context switches per second','system.cpu.switches',10427,7,3,0,60,'',7,365,0,'','sps',0,1,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',7,0,'',0,null,'30','',0,''),(27260,'CPU $2 time','system.cpu.util[,idle]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',9,0,'The time the CPU has spent doing nothing.',0,null,'30','',0,''),(27261,'CPU $2 time','system.cpu.util[,interrupt]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',8,0,'The amount of time the CPU has been servicing hardware interrupts.',0,null,'30','',0,''),(27262,'CPU $2 time','system.cpu.util[,iowait]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',10,0,'Amount of time the CPU has been waiting for I/O to complete.',0,null,'30','',0,''),(27263,'CPU $2 time','system.cpu.util[,nice]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',14,0,'The time the CPU has spent running users\' proccess that have been niced.',0,null,'30','',0,''),(27264,'CPU $2 time','system.cpu.util[,softirq]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',15,0,'The amount of time the CPU has been servicing software interrupts.',0,null,'30','',0,''),(27265,'CPU $2 time','system.cpu.util[,steal]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',13,0,'The amount of CPU \'stolen\' from this virtual machine by the hypervisor for other tasks (such as running another virtual machine).',0,null,'30','',0,''),(27266,'CPU $2 time','system.cpu.util[,system]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',11,0,'The time the CPU has spent running the kernel and its processes.',0,null,'30','',0,''),(27267,'CPU $2 time','system.cpu.util[,user]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',12,0,'The time the CPU has spent running users\' processes that are not niced.',0,null,'30','',0,''),(27268,'Host name','system.hostname',10427,7,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',19,0,'System host name.',3,null,'30','',0,''),(27269,'Hardware Devices','system.hw.devices',10427,7,4,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',187,0,'',15,null,'30','',0,''),(27270,'MAC Addresses','system.hw.macaddr[eth0]',10427,7,4,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',189,0,'',12,null,'30','',0,''),(27271,'System Local time','system.localtime',10427,7,3,0,60,'',2,30,0,'','unixtime',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',185,0,'',0,null,'30','',0,''),(27272,'Top 5 Processes above 10%','system.run["ps -eo pcpu,user,args | sort -k 1 -r|head -5|awk \'NR==2 { firstRow=$0; found=0 } NR>1{ if ($1 > 10) { found=1; print $0 } } END { if (found !=1) { print firstRow } }\'"]',10427,7,4,0,60,'',2,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',186,0,'',0,null,'30','',0,''),(27273,'System Kernel Release','system.run["uname -s -r -v"]',10427,7,4,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',195,0,'',7,null,'30','',0,''),(27274,'Host Manufacturer','system.run[sudo /usr/sbin/dmidecode -s system-manufacturer]',10427,7,4,0,3600,'',7,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',188,0,'',31,null,'30','',0,''),(27275,'Product Name','system.run[sudo /usr/sbin/dmidecode -s system-product-name]',10427,7,4,0,3600,'',7,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',191,0,'',1,null,'30','',0,''),(27276,'System Serial Number','system.run[sudo /usr/sbin/dmidecode -s system-serial-number]',10427,7,1,0,3600,'',7,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',196,0,'',8,null,'30','',0,''),(27277,'system architecture','system.sw.arch',10427,7,4,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',193,0,'',0,null,'30','',0,''),(27278,'System information','system.sw.os[name]',10427,7,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',194,0,'The information as normally returned by \'uname -a\'.',5,null,'30','',0,''),(27279,'Software installed','system.sw.packages[all,all,full]',10427,7,4,0,3600,'',7,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',192,0,'',17,null,'30','',0,''),(27280,'Free swap space','system.swap.size[,free]',10427,7,3,0,60,'',7,365,0,'','B',0,0,'0','',null,'','','','','',0,0,'',0,'',0,'','','','',16,0,'',0,null,'30','',0,''),(27281,'Free swap space in %','system.swap.size[,pfree]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',17,0,'',0,null,'30','',0,''),(27282,'Total swap space','system.swap.size[,total]',10427,7,3,0,3600,'',7,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',36,0,'',0,null,'30','',0,''),(27283,'OS Full Details','system.uname',10427,7,4,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',190,0,'',6,null,'30','',0,''),(27284,'System uptime','system.uptime',10427,7,3,0,600,'',7,365,0,'','uptime',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',34,0,'',0,null,'30','',0,''),(27285,'Number of logged in users','system.users.num',10427,7,3,0,60,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',26,0,'Number of users who are currently logged in.',0,null,'30','',0,''),(27286,'Disk Read Rate','vfs.dev.read[,sps]',10427,7,0,0,60,'',7,365,0,'','B/sec',1,0,'512','',null,'','','','','',0,0,'',0,'',0,'','','','',183,0,'',0,null,'30','',0,''),(27287,'Disk Write Rate','vfs.dev.write[,sps]',10427,7,0,0,60,'',7,365,0,'','B/sec',1,0,'512','',null,'','','','','',0,0,'',0,'',0,'','','','',184,0,'',0,null,'30','',0,''),(27288,'Checksum of $1','vfs.file.cksum[/etc/passwd]',10427,7,3,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',6,0,'',0,null,'30','',0,''),(27289,'Messages log size','vfs.file.size[/var/log/messages]',10427,7,3,0,86400,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',24,0,'',0,null,'30','',0,''),(27290,'Secure log Size','vfs.file.size[/var/log/secure]',10427,7,3,0,86400,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',32,0,'',0,null,'30','',0,''),(27291,'SSHD PID changed','vfs.file.time[/var/run/sshd.pid,change]',10427,7,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',33,0,'',0,null,'30','',0,''),(27292,'Mounted filesystem discovery','vfs.fs.discovery',10427,7,4,0,3600,'',90,365,0,'','',0,0,'','',null,'','','','','',0,0,'',0,'',0,'','','','',210,1,'Discovery of file systems of different types as defined in global regular expression "File systems for discovery".',0,null,'30','',0,''),(27293,'Free inodes % on $1','vfs.fs.inode[{#FSNAME},pfree]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',216,2,'',0,null,'30','',0,''),(27294,'Free disk space on $1','vfs.fs.size[{#FSNAME},free]',10427,7,3,0,60,'',7,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',215,2,'',0,null,'30','',0,''),(27295,'Free disk space % on $1','vfs.fs.size[{#FSNAME},pfree]',10427,7,0,0,60,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',214,2,'',0,null,'30','',0,''),(27296,'Total disk space on $1','vfs.fs.size[{#FSNAME},total]',10427,7,3,0,3600,'',7,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',217,2,'',0,null,'30','',0,''),(27297,'Used disk space on $1','vfs.fs.size[{#FSNAME},used]',10427,7,3,0,60,'',7,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',218,2,'',0,null,'30','',0,''),(27298,'Memory Free (%)','vm.memory.percent_used',10427,15,0,0,60,'',90,365,0,'','%',1,0,'100','',null,'last("vm.memory.size[available]")/last("vm.memory.size[total]")','','','','',0,0,'',0,'',0,'','','','',23,0,'',0,null,'30','',0,''),(27299,'Available memory','vm.memory.size[available]',10427,7,3,0,60,'',7,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'','','','',5,0,'Available memory is defined as free+cached+buffers memory.',0,null,'30','',0,''),(27300,'Total memory','vm.memory.size[total]',10427,7,3,0,3600,'',7,365,0,'','B',0,0,'0','',null,'','','','','',0,0,'',0,'',0,'','','','',35,0,'',0,null,'30','',0,''); ] 14616:20180418:155830.912 query [txnlev:1] [insert into item_condition (item_conditionid,itemid,operator,macro,value) values (306,27243,8,'{#IFNAME}','@Network interfaces for discovery'),(305,27292,8,'{#FSTYPE}','@File systems for discovery'); ] 14616:20180418:155830.913 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid between 27235 and 27300 join application_template hat on hat.templateid=tia.applicationid join applications ha on ha.applicationid=hat.applicationid and ha.hostid=hi.hostid left join items_applications hia on hia.applicationid=ha.applicationid and hia.itemid=hi.itemid where hia.itemappid is null] 14616:20180418:155830.921 In DBget_nextid() tablename:'items_applications' 14616:20180418:155830.921 query [txnlev:1] [select nextid from ids where table_name='items_applications' and field_name='itemappid'] 14616:20180418:155830.921 query [txnlev:1] [update ids set nextid=nextid+80 where table_name='items_applications' and field_name='itemappid'] 14616:20180418:155830.921 query [txnlev:1] [select nextid from ids where table_name='items_applications' and field_name='itemappid'] 14616:20180418:155830.922 query [txnlev:1] [select nextid from ids where table_name='items_applications' and field_name='itemappid'] 14616:20180418:155830.922 query [txnlev:1] [update ids set nextid=nextid+80 where table_name='items_applications' and field_name='itemappid'] 14616:20180418:155830.923 query [txnlev:1] [select nextid from ids where table_name='items_applications' and field_name='itemappid'] 14616:20180418:155830.924 End of DBget_nextid():33601 table:'items_applications' recid:'itemappid' 14616:20180418:155830.924 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (33601,27235,3600),(33602,27236,3600),(33603,27237,3600),(33604,27238,3590),(33605,27239,3590),(33606,27240,3590),(33607,27241,3595),(33608,27242,3595),(33609,27244,3594),(33610,27245,3594),(33611,27246,3599),(33612,27247,3597),(33613,27248,3592),(33614,27249,3597),(33615,27250,3600),(33616,27251,3600),(33617,27252,3600),(33618,27253,3597),(33619,27254,3589),(33620,27254,3595),(33621,27255,3587),(33622,27255,3596),(33623,27256,3587),(33624,27256,3596),(33625,27257,3587),(33626,27257,3596),(33627,27258,3587),(33628,27258,3596),(33629,27259,3587),(33630,27259,3596),(33631,27260,3587),(33632,27260,3596),(33633,27261,3587),(33634,27261,3596),(33635,27262,3587),(33636,27262,3596),(33637,27263,3587),(33638,27263,3596),(33639,27264,3587),(33640,27264,3596),(33641,27265,3587),(33642,27265,3596),(33643,27266,3587),(33644,27266,3596),(33645,27267,3587),(33646,27267,3596),(33647,27268,3589),(33648,27268,3595),(33649,27269,3591),(33650,27270,3591),(33651,27271,3589),(33652,27272,3597),(33653,27273,3591),(33654,27274,3591),(33655,27275,3591),(33656,27276,3591),(33657,27277,3591),(33658,27278,3591),(33659,27279,3591),(33660,27280,3593),(33661,27281,3593),(33662,27282,3593),(33663,27283,3591),(33664,27284,3595),(33665,27285,3595),(33666,27285,3598),(33667,27286,3588),(33668,27287,3588),(33669,27288,3598),(33670,27289,3588),(33671,27290,3588),(33672,27291,3598),(33673,27293,3588),(33674,27294,3588),(33675,27295,3588),(33676,27296,3588),(33677,27297,3588),(33678,27298,3593),(33679,27299,3593),(33680,27300,3593); ] 14616:20180418:155830.925 query [txnlev:1] [select i.itemid,r.itemid from items i,item_discovery id,items r where i.templateid=id.itemid and id.parent_itemid=r.templateid and r.hostid=10427 and (i.itemid between 27293 and 27297 or i.itemid in (27244,27245))] 14616:20180418:155830.927 In DBget_nextid() tablename:'item_discovery' 14616:20180418:155830.927 query [txnlev:1] [select nextid from ids where table_name='item_discovery' and field_name='itemdiscoveryid'] 14616:20180418:155830.927 query [txnlev:1] [update ids set nextid=nextid+7 where table_name='item_discovery' and field_name='itemdiscoveryid'] 14616:20180418:155830.928 query [txnlev:1] [select nextid from ids where table_name='item_discovery' and field_name='itemdiscoveryid'] 14616:20180418:155830.928 query [txnlev:1] [select nextid from ids where table_name='item_discovery' and field_name='itemdiscoveryid'] 14616:20180418:155830.928 query [txnlev:1] [update ids set nextid=nextid+7 where table_name='item_discovery' and field_name='itemdiscoveryid'] 14616:20180418:155830.929 query [txnlev:1] [select nextid from ids where table_name='item_discovery' and field_name='itemdiscoveryid'] 14616:20180418:155830.929 End of DBget_nextid():4564 table:'item_discovery' recid:'itemdiscoveryid' 14616:20180418:155830.929 query [txnlev:1] [insert into item_discovery (itemdiscoveryid,itemid,parent_itemid) values (4564,27244,27243),(4565,27245,27243),(4566,27293,27292),(4567,27294,27292),(4568,27295,27292),(4569,27296,27292),(4570,27297,27292); ] 14616:20180418:155830.930 End of DBcopy_template_items() 14616:20180418:155830.930 query [txnlev:1] [select flags from hosts where hostid=10427] 14616:20180418:155830.930 query [txnlev:1] [select hi.itemid,th.hostid,th.host,th.name,th.status from items hi,items ti,host_discovery thd,hosts th where hi.templateid=ti.itemid and ti.itemid=thd.parent_itemid and thd.hostid=th.hostid and hi.hostid=10427 and ti.hostid=10096] 14616:20180418:155830.931 In DBcopy_template_triggers() 14616:20180418:155830.931 query [txnlev:1] [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.flags from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10096] 14616:20180418:155830.932 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Zabbix agent on {HOST.NAME} is unreachable for 30 minutes'] 14616:20180418:155830.933 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.933 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.933 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.933 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.934 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.934 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.934 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.935 End of DBget_nextid():8641 table:'triggers' recid:'triggerid' 14616:20180418:155830.935 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=96] 14616:20180418:155830.935 In DBget_nextid() tablename:'functions' 14616:20180418:155830.935 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.935 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.936 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.936 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.936 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.937 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.937 End of DBget_nextid():10647 table:'functions' recid:'functionid' 14616:20180418:155830.937 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8641,'Zabbix agent on {HOST.NAME} is unreachable for 30 minutes',2,0,'','',0,0,0,96,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10647,27236,8641,'nodata','30m'); update triggers set expression='{10647}=1' where triggerid=8641; ] 14616:20180418:155830.938 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Zabbix agent on {HOST.NAME} is unreachable for 90 minutes'] 14616:20180418:155830.939 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.939 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.939 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.939 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.940 End of DBget_nextid():8642 table:'triggers' recid:'triggerid' 14616:20180418:155830.940 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=98] 14616:20180418:155830.940 In DBget_nextid() tablename:'functions' 14616:20180418:155830.940 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.940 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.941 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.941 End of DBget_nextid():10648 table:'functions' recid:'functionid' 14616:20180418:155830.941 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8642,'Zabbix agent on {HOST.NAME} is unreachable for 90 minutes',4,0,'','',0,0,0,98,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10648,27236,8642,'nodata','90m'); update triggers set expression='{10648}=1' where triggerid=8642; ] 14616:20180418:155830.942 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='{HOST.NAME} is unavailable by ICMP'] 14616:20180418:155830.943 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.943 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.943 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.943 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.944 End of DBget_nextid():8643 table:'triggers' recid:'triggerid' 14616:20180418:155830.944 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=100] 14616:20180418:155830.944 In DBget_nextid() tablename:'functions' 14616:20180418:155830.944 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.944 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.945 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.945 End of DBget_nextid():10649 table:'functions' recid:'functionid' 14616:20180418:155830.945 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8643,'{HOST.NAME} is unavailable by ICMP',4,0,'','',0,0,0,100,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10649,27238,8643,'max','#5'); update triggers set expression='{10649}=0' where triggerid=8643; ] 14616:20180418:155830.946 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Ping loss is too high on {HOST.NAME}'] 14616:20180418:155830.946 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.946 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.947 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.947 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.947 End of DBget_nextid():8644 table:'triggers' recid:'triggerid' 14616:20180418:155830.947 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=90] 14616:20180418:155830.948 In DBget_nextid() tablename:'functions' 14616:20180418:155830.948 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.948 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.949 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.949 End of DBget_nextid():10650 table:'functions' recid:'functionid' 14616:20180418:155830.949 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8644,'Ping loss is too high on {HOST.NAME}',2,0,'','',0,0,0,90,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10650,27239,8644,'min','5m'); update triggers set expression='{10650}>20' where triggerid=8644; ] 14616:20180418:155830.950 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Response time is too high on {HOST.NAME}'] 14616:20180418:155830.950 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.951 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.951 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.951 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.952 End of DBget_nextid():8645 table:'triggers' recid:'triggerid' 14616:20180418:155830.952 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=92] 14616:20180418:155830.952 In DBget_nextid() tablename:'functions' 14616:20180418:155830.952 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.953 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.953 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.953 End of DBget_nextid():10651 table:'functions' recid:'functionid' 14616:20180418:155830.953 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8645,'Response time is too high on {HOST.NAME}',2,0,'','',0,0,0,92,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10651,27240,8645,'avg','5m'); update triggers set expression='{10651}>0.15' where triggerid=8645; ] 14616:20180418:155830.954 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Configured max number of opened files is too low on {HOST.NAME}'] 14616:20180418:155830.955 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.955 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.955 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.955 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.956 End of DBget_nextid():8646 table:'triggers' recid:'triggerid' 14616:20180418:155830.956 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=9] 14616:20180418:155830.956 In DBget_nextid() tablename:'functions' 14616:20180418:155830.956 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.957 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.957 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.957 End of DBget_nextid():10652 table:'functions' recid:'functionid' 14616:20180418:155830.957 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8646,'Configured max number of opened files is too low on {HOST.NAME}',1,0,'','',0,0,0,9,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10652,27241,8646,'last','0'); update triggers set expression='{10652}<1024' where triggerid=8646; ] 14616:20180418:155830.958 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Configured max number of processes is too low on {HOST.NAME}'] 14616:20180418:155830.959 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.959 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.959 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.959 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.960 End of DBget_nextid():8647 table:'triggers' recid:'triggerid' 14616:20180418:155830.960 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=10] 14616:20180418:155830.960 In DBget_nextid() tablename:'functions' 14616:20180418:155830.960 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.961 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.961 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.961 End of DBget_nextid():10653 table:'functions' recid:'functionid' 14616:20180418:155830.961 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8647,'Configured max number of processes is too low on {HOST.NAME}',1,0,'','',0,0,0,10,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10653,27242,8647,'last','0'); update triggers set expression='{10653}<256' where triggerid=8647; ] 14616:20180418:155830.962 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='{HOST.NAME} ({HOST.CONN}) is not listening on SSH port 22'] 14616:20180418:155830.963 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.963 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.963 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.964 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.964 End of DBget_nextid():8648 table:'triggers' recid:'triggerid' 14616:20180418:155830.964 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=99] 14616:20180418:155830.964 In DBget_nextid() tablename:'functions' 14616:20180418:155830.965 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.965 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.965 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.966 End of DBget_nextid():10654 table:'functions' recid:'functionid' 14616:20180418:155830.966 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8648,'{HOST.NAME} ({HOST.CONN}) is not listening on SSH port 22',2,0,'','',0,0,0,99,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10654,27246,8648,'max','#5'); update triggers set expression='{10654}=0' where triggerid=8648; ] 14616:20180418:155830.966 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Too many processes running on {HOST.NAME}'] 14616:20180418:155830.967 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.967 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.967 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.968 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.968 End of DBget_nextid():8649 table:'triggers' recid:'triggerid' 14616:20180418:155830.968 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=35] 14616:20180418:155830.969 In DBget_nextid() tablename:'functions' 14616:20180418:155830.969 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.969 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.969 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.970 End of DBget_nextid():10655 table:'functions' recid:'functionid' 14616:20180418:155830.970 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8649,'Too many processes running on {HOST.NAME}',2,1,'','',0,0,0,35,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10655,27247,8649,'last','0'); update triggers set expression='{10655}>60' where triggerid=8649; ] 14616:20180418:155830.970 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Logstash agent process not running'] 14616:20180418:155830.971 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.971 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.971 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.972 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.972 End of DBget_nextid():8650 table:'triggers' recid:'triggerid' 14616:20180418:155830.972 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=89] 14616:20180418:155830.973 In DBget_nextid() tablename:'functions' 14616:20180418:155830.973 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.973 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.973 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.974 End of DBget_nextid():10656 table:'functions' recid:'functionid' 14616:20180418:155830.974 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8650,'Logstash agent process not running',4,0,'','',0,0,0,89,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10656,27248,8650,'max','#5'); update triggers set expression='{10656}=0' where triggerid=8650; ] 14616:20180418:155830.974 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Too many processes on {HOST.NAME}'] 14616:20180418:155830.975 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.975 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.975 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.976 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.976 End of DBget_nextid():8651 table:'triggers' recid:'triggerid' 14616:20180418:155830.976 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=32] 14616:20180418:155830.977 In DBget_nextid() tablename:'functions' 14616:20180418:155830.977 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.977 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.977 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.978 End of DBget_nextid():10657 table:'functions' recid:'functionid' 14616:20180418:155830.978 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8651,'Too many processes on {HOST.NAME}',2,1,'','',0,0,0,32,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10657,27253,8651,'last','0'); update triggers set expression='{10657}>{$WARN_LIMIT_PROCESSES}' where triggerid=8651; ] 14616:20180418:155830.978 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Processor load is too high on {HOST.NAME}'] 14616:20180418:155830.979 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.979 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.980 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.980 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.980 End of DBget_nextid():8652 table:'triggers' recid:'triggerid' 14616:20180418:155830.980 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=25] 14616:20180418:155830.981 In DBget_nextid() tablename:'functions' 14616:20180418:155830.981 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.981 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.981 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.982 End of DBget_nextid():10658 table:'functions' recid:'functionid' 14616:20180418:155830.982 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8652,'Processor load is too high on {HOST.NAME}',2,0,'','',0,0,0,25,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10658,27258,8652,'last','0'); update triggers set expression='{10658}>25' where triggerid=8652; ] 14616:20180418:155830.982 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Disk I/O is overloaded on {HOST.NAME}'] 14616:20180418:155830.983 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.983 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.983 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.984 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.984 End of DBget_nextid():8653 table:'triggers' recid:'triggerid' 14616:20180418:155830.984 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=12] 14616:20180418:155830.984 In DBget_nextid() tablename:'functions' 14616:20180418:155830.984 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.985 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.985 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.985 End of DBget_nextid():10659 table:'functions' recid:'functionid' 14616:20180418:155830.985 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8653,'Disk I/O is overloaded on {HOST.NAME}',2,1,'OS spends significant time waiting for I/O (input/output) operations. It could be indicator of performance issues with storage system.','',0,0,0,12,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10659,27262,8653,'avg','5m'); update triggers set expression='{10659}>20' where triggerid=8653; ] 14616:20180418:155830.986 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Hostname was changed on {HOST.NAME}'] 14616:20180418:155830.987 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.987 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.987 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.987 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.988 End of DBget_nextid():8654 table:'triggers' recid:'triggerid' 14616:20180418:155830.988 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=14] 14616:20180418:155830.988 In DBget_nextid() tablename:'functions' 14616:20180418:155830.988 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.989 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.989 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.989 End of DBget_nextid():10660 table:'functions' recid:'functionid' 14616:20180418:155830.989 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8654,'Hostname was changed on {HOST.NAME}',1,0,'','',0,0,0,14,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10660,27268,8654,'diff','0'); update triggers set expression='{10660}>0' where triggerid=8654; ] 14616:20180418:155830.990 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Time drift between server {HOST.HOST} and Zabbix Server is more than 15 seconds off'] 14616:20180418:155830.991 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.991 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.991 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.991 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.992 End of DBget_nextid():8655 table:'triggers' recid:'triggerid' 14616:20180418:155830.992 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=94] 14616:20180418:155830.992 In DBget_nextid() tablename:'functions' 14616:20180418:155830.992 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.992 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.993 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.993 End of DBget_nextid():10661 table:'functions' recid:'functionid' 14616:20180418:155830.993 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8655,'Time drift between server {HOST.HOST} and Zabbix Server is more than 15 seconds off',2,0,'System time is more than 10 seconds off from zabbix time.','',0,0,0,94,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10661,27271,8655,'fuzzytime','15'); update triggers set expression='{10661}=0' where triggerid=8655; ] 14616:20180418:155830.994 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='System uptime 208 Day limit - {ITEM.LASTVALUE}'] 14616:20180418:155830.994 In DBget_nextid() tablename:'triggers' 14616:20180418:155830.994 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.995 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.995 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155830.995 End of DBget_nextid():8656 table:'triggers' recid:'triggerid' 14616:20180418:155830.995 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=28] 14616:20180418:155830.996 In DBget_nextid() tablename:'functions' 14616:20180418:155830.996 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.996 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.997 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.997 End of DBget_nextid():10662 table:'functions' recid:'functionid' 14616:20180418:155830.997 In DBget_nextid() tablename:'functions' 14616:20180418:155830.997 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.997 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155830.998 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155830.998 End of DBget_nextid():10663 table:'functions' recid:'functionid' 14616:20180418:155830.998 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8656,'System uptime 208 Day limit - {ITEM.LASTVALUE}',2,0,'System uptime warning! We\'ve seen crashes if the server goes beyond 208 days. http://www.aelius.com/njh/unixtime/?y=1970&m=0&d=208&h=0&i=0&s=0 208 days apparently equates to 15206400','',0,0,0,28,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10662,27284,8656,'last',''); insert into functions (functionid,itemid,triggerid,function,parameter) values (10663,27283,8656,'str','2.6.32'); update triggers set expression='{10662}>16818400 and {10663}=1' where triggerid=8656; ] 14616:20180418:155830.999 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='{HOST.NAME} has just been restarted'] 14616:20180418:155831.000 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.000 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.000 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.000 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.001 End of DBget_nextid():8657 table:'triggers' recid:'triggerid' 14616:20180418:155831.001 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=87] 14616:20180418:155831.001 In DBget_nextid() tablename:'functions' 14616:20180418:155831.001 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.002 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.003 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.003 End of DBget_nextid():10664 table:'functions' recid:'functionid' 14616:20180418:155831.003 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8657,'{HOST.NAME} has just been restarted',1,0,'','',0,0,0,87,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10664,27284,8657,'change','0'); update triggers set expression='{10664}<0' where triggerid=8657; ] 14616:20180418:155831.004 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='PID changed'] 14616:20180418:155831.005 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.005 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.006 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.006 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.006 End of DBget_nextid():8658 table:'triggers' recid:'triggerid' 14616:20180418:155831.006 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=22] 14616:20180418:155831.007 In DBget_nextid() tablename:'functions' 14616:20180418:155831.007 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.007 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.008 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.008 End of DBget_nextid():10665 table:'functions' recid:'functionid' 14616:20180418:155831.008 In DBget_nextid() tablename:'functions' 14616:20180418:155831.008 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.009 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.009 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.009 End of DBget_nextid():10666 table:'functions' recid:'functionid' 14616:20180418:155831.009 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8658,'PID changed',3,0,'','',0,0,0,22,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10665,27291,8658,'diff','0'); insert into functions (functionid,itemid,triggerid,function,parameter) values (10666,27284,8658,'last',''); update triggers set expression='{10665}>0 and {10666}>900' where triggerid=8658; ] 14616:20180418:155831.010 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='/etc/passwd has been changed on {HOST.NAME}'] 14616:20180418:155831.011 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.011 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.011 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.012 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.012 End of DBget_nextid():8659 table:'triggers' recid:'triggerid' 14616:20180418:155831.012 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=6] 14616:20180418:155831.012 In DBget_nextid() tablename:'functions' 14616:20180418:155831.012 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.013 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.013 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.013 End of DBget_nextid():10667 table:'functions' recid:'functionid' 14616:20180418:155831.013 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8659,'/etc/passwd has been changed on {HOST.NAME}',1,0,'','',0,0,0,6,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10667,27288,8659,'diff','0'); update triggers set expression='{10667}>0' where triggerid=8659; ] 14616:20180418:155831.014 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='/var/log/messages size is 0'] 14616:20180418:155831.015 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.015 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.015 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.015 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.016 End of DBget_nextid():8660 table:'triggers' recid:'triggerid' 14616:20180418:155831.016 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=7] 14616:20180418:155831.016 In DBget_nextid() tablename:'functions' 14616:20180418:155831.016 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.016 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.017 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.017 End of DBget_nextid():10668 table:'functions' recid:'functionid' 14616:20180418:155831.017 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8660,'/var/log/messages size is 0',3,0,'','',0,0,0,7,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10668,27289,8660,'last',''); update triggers set expression='{10668}=0' where triggerid=8660; ] 14616:20180418:155831.018 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='/var/log/secure size is 0'] 14616:20180418:155831.019 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.019 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.019 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.019 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.019 End of DBget_nextid():8661 table:'triggers' recid:'triggerid' 14616:20180418:155831.020 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=8] 14616:20180418:155831.020 In DBget_nextid() tablename:'functions' 14616:20180418:155831.020 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.020 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.021 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.021 End of DBget_nextid():10669 table:'functions' recid:'functionid' 14616:20180418:155831.021 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8661,'/var/log/secure size is 0',3,1,'','',0,0,0,8,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10669,27290,8661,'last',''); update triggers set expression='{10669}=0' where triggerid=8661; ] 14616:20180418:155831.022 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Free inodes is less than 20% on volume {#FSNAME}'] 14616:20180418:155831.022 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.022 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.023 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.023 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.023 End of DBget_nextid():8662 table:'triggers' recid:'triggerid' 14616:20180418:155831.024 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=3] 14616:20180418:155831.024 In DBget_nextid() tablename:'functions' 14616:20180418:155831.024 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.024 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.025 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.025 End of DBget_nextid():10670 table:'functions' recid:'functionid' 14616:20180418:155831.025 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8662,'Free inodes is less than 20% on volume {#FSNAME}',2,0,'','',0,0,0,3,2); insert into functions (functionid,itemid,triggerid,function,parameter) values (10670,27293,8662,'last','0'); update triggers set expression='{10670}<20' where triggerid=8662; ] 14616:20180418:155831.026 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Free disk space is less than 5% on volume {#FSNAME}'] 14616:20180418:155831.027 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.027 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.027 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.027 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.027 End of DBget_nextid():8663 table:'triggers' recid:'triggerid' 14616:20180418:155831.028 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=1] 14616:20180418:155831.028 In DBget_nextid() tablename:'functions' 14616:20180418:155831.028 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.028 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.029 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.029 End of DBget_nextid():10671 table:'functions' recid:'functionid' 14616:20180418:155831.029 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8663,'Free disk space is less than 5% on volume {#FSNAME}',4,0,'','',0,0,0,1,2); insert into functions (functionid,itemid,triggerid,function,parameter) values (10671,27295,8663,'last','0'); update triggers set expression='{10671}<5' where triggerid=8663; ] 14616:20180418:155831.030 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Free disk space is less than 10% on volume {#FSNAME}'] 14654:20180418:155831.030 self-monitoring [processing data] 14654:20180418:155831.030 In collect_selfmon_stats() 14654:20180418:155831.030 End of collect_selfmon_stats() 14654:20180418:155831.030 self-monitoring [processed data in 0.000096 sec, idle 1 sec] 14616:20180418:155831.030 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.030 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.031 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.031 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.031 End of DBget_nextid():8664 table:'triggers' recid:'triggerid' 14616:20180418:155831.031 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=2] 14616:20180418:155831.032 In DBget_nextid() tablename:'functions' 14616:20180418:155831.032 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.032 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.033 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.033 End of DBget_nextid():10672 table:'functions' recid:'functionid' 14616:20180418:155831.033 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8664,'Free disk space is less than 10% on volume {#FSNAME}',2,0,'','',0,0,0,2,2); insert into functions (functionid,itemid,triggerid,function,parameter) values (10672,27295,8664,'last','0'); update triggers set expression='{10672}<10' where triggerid=8664; ] 14616:20180418:155831.034 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Memory Free less than 5% for the past 30 minutes'] 14616:20180418:155831.034 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.034 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.035 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.035 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.036 End of DBget_nextid():8665 table:'triggers' recid:'triggerid' 14616:20180418:155831.036 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=21] 14616:20180418:155831.036 In DBget_nextid() tablename:'functions' 14616:20180418:155831.036 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.037 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.037 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.037 End of DBget_nextid():10673 table:'functions' recid:'functionid' 14616:20180418:155831.037 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8665,'Memory Free less than 5% for the past 30 minutes',2,0,'','',0,0,0,21,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10673,27298,8665,'avg','30m'); update triggers set expression='{10673}<5' where triggerid=8665; ] 14616:20180418:155831.038 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.templateid is null and i.hostid=10427 and t.description='Lack of available memory on server {HOST.NAME}'] 14616:20180418:155831.039 In DBget_nextid() tablename:'triggers' 14616:20180418:155831.039 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.040 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.040 query [txnlev:1] [select nextid from ids where table_name='triggers' and field_name='triggerid'] 14616:20180418:155831.040 End of DBget_nextid():8666 table:'triggers' recid:'triggerid' 14616:20180418:155831.040 query [txnlev:1] [select hi.itemid,tf.functionid,tf.function,tf.parameter,ti.key_ from functions tf,items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10427 where tf.itemid=ti.itemid and tf.triggerid=15] 14616:20180418:155831.041 In DBget_nextid() tablename:'functions' 14616:20180418:155831.041 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.041 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='functions' and field_name='functionid'] 14616:20180418:155831.042 query [txnlev:1] [select nextid from ids where table_name='functions' and field_name='functionid'] 14616:20180418:155831.042 End of DBget_nextid():10674 table:'functions' recid:'functionid' 14616:20180418:155831.042 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,state,templateid,flags) values (8666,'Lack of available memory on server {HOST.NAME}',3,0,'','',0,0,0,15,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (10674,27299,8666,'last','0'); update triggers set expression='{10674}<20M' where triggerid=8666; ] 14616:20180418:155831.043 query [txnlev:1] [select triggerid,templateid from triggers where triggerid between 8641 and 8666] 14616:20180418:155831.043 query [txnlev:1] [select distinct td.triggerid_down,td.triggerid_up from triggers t,trigger_depends td where t.templateid in (td.triggerid_up,td.triggerid_down) and t.triggerid between 8641 and 8666] 14616:20180418:155831.044 In DBget_nextid() tablename:'trigger_depends' 14616:20180418:155831.044 query [txnlev:1] [select nextid from ids where table_name='trigger_depends' and field_name='triggerdepid'] 14616:20180418:155831.045 query [txnlev:1] [update ids set nextid=nextid+4 where table_name='trigger_depends' and field_name='triggerdepid'] 14616:20180418:155831.045 query [txnlev:1] [select nextid from ids where table_name='trigger_depends' and field_name='triggerdepid'] 14616:20180418:155831.045 query [txnlev:1] [select nextid from ids where table_name='trigger_depends' and field_name='triggerdepid'] 14647:20180418:155831.046 escalator [processed 0 escalations in 0.001294 sec, processing escalations] 14647:20180418:155831.046 In process_escalations() 14647:20180418:155831.046 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid from escalations order by actionid,triggerid,itemid,escalationid] 14616:20180418:155831.046 query [txnlev:1] [update ids set nextid=nextid+4 where table_name='trigger_depends' and field_name='triggerdepid'] 14616:20180418:155831.046 query [txnlev:1] [select nextid from ids where table_name='trigger_depends' and field_name='triggerdepid'] 14616:20180418:155831.047 End of DBget_nextid():627 table:'trigger_depends' recid:'triggerdepid' 14616:20180418:155831.047 query [txnlev:1] [insert into trigger_depends (triggerdepid,triggerid_down,triggerid_up) values (627,8644,8643),(628,8645,8643),(629,8641,8643),(630,8642,8643); ] 14616:20180418:155831.047 End of DBcopy_template_triggers():SUCCEED 14616:20180418:155831.047 In DBcopy_template_graphs() 14616:20180418:155831.047 query [txnlev:1] [select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,g.ymax_type,g.ymin_itemid,g.ymax_itemid,g.flags from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10096] 14616:20180418:155831.049 In DBcopy_graph_to_host() 14616:20180418:155831.049 In DBget_graphitems() 14616:20180418:155831.049 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=2 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.049 DBget_graphitems() [0] itemid:27244 key:'net.if.in[{#IFNAME}]' 14616:20180418:155831.050 DBget_graphitems() [1] itemid:27245 key:'net.if.out[{#IFNAME}]' 14616:20180418:155831.050 End of DBget_graphitems() 14616:20180418:155831.050 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Network traffic on {#IFNAME}' and g.templateid is null] 14616:20180418:155831.050 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.050 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.050 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.051 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.051 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.051 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.052 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.052 End of DBget_nextid():4725 table:'graphs' recid:'graphid' 14616:20180418:155831.052 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.052 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.053 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.053 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.053 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.053 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.054 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.054 End of DBget_nextid():13299 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.054 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4725,'Network traffic on {#IFNAME}',900,200,0.000000,100.000000,2,1,1,0,1,0,0.000000,0.000000,1,0,null,null,2); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13299,4725,27244,5,0,'00AA00',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13300,4725,27245,5,1,'3333FF',0,2,0); ] 14616:20180418:155831.055 End of DBcopy_graph_to_host() 14616:20180418:155831.055 In DBcopy_graph_to_host() 14616:20180418:155831.055 In DBget_graphitems() 14616:20180418:155831.055 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=6 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.055 DBget_graphitems() [0] itemid:27255 key:'system.cpu.intr' 14616:20180418:155831.055 DBget_graphitems() [1] itemid:27259 key:'system.cpu.switches' 14616:20180418:155831.055 End of DBget_graphitems() 14616:20180418:155831.055 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='CPU jumps' and g.templateid is null] 14616:20180418:155831.056 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.056 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.056 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.057 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.057 End of DBget_nextid():4726 table:'graphs' recid:'graphid' 14616:20180418:155831.057 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.057 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.057 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.058 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.058 End of DBget_nextid():13301 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.058 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4726,'CPU jumps',900,200,0.000000,100.000000,6,1,1,0,1,0,0.000000,0.000000,0,0,null,null,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13301,4726,27255,0,2,'000099',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13302,4726,27259,0,1,'009900',0,2,0); ] 14616:20180418:155831.059 End of DBcopy_graph_to_host() 14616:20180418:155831.059 In DBcopy_graph_to_host() 14616:20180418:155831.059 In DBget_graphitems() 14616:20180418:155831.059 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=8 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.059 DBget_graphitems() [0] itemid:27256 key:'system.cpu.load[percpu,avg15]' 14616:20180418:155831.059 DBget_graphitems() [1] itemid:27257 key:'system.cpu.load[percpu,avg1]' 14616:20180418:155831.059 DBget_graphitems() [2] itemid:27258 key:'system.cpu.load[percpu,avg5]' 14616:20180418:155831.059 End of DBget_graphitems() 14616:20180418:155831.059 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='CPU load' and g.templateid is null] 14616:20180418:155831.060 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.060 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.060 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.061 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.061 End of DBget_nextid():4727 table:'graphs' recid:'graphid' 14616:20180418:155831.061 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.061 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.061 query [txnlev:1] [update ids set nextid=nextid+3 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.062 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.062 End of DBget_nextid():13303 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.062 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4727,'CPU load',900,200,0.000000,100.000000,8,1,1,0,1,0,0.000000,0.000000,1,0,null,null,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13303,4727,27256,0,2,'990000',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13304,4727,27257,0,0,'009900',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13305,4727,27258,0,1,'000099',0,2,0); ] 14616:20180418:155831.063 End of DBcopy_graph_to_host() 14616:20180418:155831.063 In DBcopy_graph_to_host() 14616:20180418:155831.063 In DBget_graphitems() 14616:20180418:155831.063 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=10 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.064 DBget_graphitems() [0] itemid:27260 key:'system.cpu.util[,idle]' 14616:20180418:155831.064 DBget_graphitems() [1] itemid:27261 key:'system.cpu.util[,interrupt]' 14616:20180418:155831.064 DBget_graphitems() [2] itemid:27262 key:'system.cpu.util[,iowait]' 14616:20180418:155831.064 DBget_graphitems() [3] itemid:27263 key:'system.cpu.util[,nice]' 14616:20180418:155831.064 DBget_graphitems() [4] itemid:27264 key:'system.cpu.util[,softirq]' 14616:20180418:155831.064 DBget_graphitems() [5] itemid:27265 key:'system.cpu.util[,steal]' 14616:20180418:155831.064 DBget_graphitems() [6] itemid:27266 key:'system.cpu.util[,system]' 14616:20180418:155831.064 DBget_graphitems() [7] itemid:27267 key:'system.cpu.util[,user]' 14616:20180418:155831.064 End of DBget_graphitems() 14616:20180418:155831.064 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='CPU utilization' and g.templateid is null] 14616:20180418:155831.065 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.065 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.065 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14647:20180418:155831.065 End of process_escalations() 14647:20180418:155831.065 escalator [processed 0 escalations in 0.019421 sec, idle 3 sec] 14616:20180418:155831.065 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.066 End of DBget_nextid():4728 table:'graphs' recid:'graphid' 14616:20180418:155831.066 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.066 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.066 query [txnlev:1] [update ids set nextid=nextid+8 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.067 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.067 End of DBget_nextid():13306 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.067 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4728,'CPU utilization',900,200,0.000000,100.000000,10,1,0,1,1,0,0.000000,0.000000,1,1,null,null,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13306,4728,27260,1,8,'009900',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13307,4728,27261,1,3,'009999',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13308,4728,27262,1,5,'999900',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13309,4728,27263,1,4,'990099',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13310,4728,27264,1,2,'55FF55',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13311,4728,27265,1,1,'FF5555',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13312,4728,27266,1,6,'990000',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13313,4728,27267,1,7,'000099',0,2,0); ] 14616:20180418:155831.069 End of DBcopy_graph_to_host() 14616:20180418:155831.069 In DBcopy_graph_to_host() 14616:20180418:155831.069 In DBget_graphitems() 14616:20180418:155831.069 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=18 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.069 DBget_graphitems() [0] itemid:27280 key:'system.swap.size[,free]' 14616:20180418:155831.069 DBget_graphitems() [1] itemid:27282 key:'system.swap.size[,total]' 14616:20180418:155831.069 End of DBget_graphitems() 14616:20180418:155831.069 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Swap usage' and g.templateid is null] 14616:20180418:155831.070 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.070 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.070 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.071 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.071 End of DBget_nextid():4729 table:'graphs' recid:'graphid' 14616:20180418:155831.071 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.071 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.071 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.072 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.072 End of DBget_nextid():13314 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.072 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4729,'Swap usage',600,340,0.000000,0.000000,18,0,0,2,1,1,0.000000,0.000000,0,0,null,null,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13314,4729,27280,0,1,'00AA00',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13315,4729,27282,0,0,'AA0000',0,2,2); ] 14616:20180418:155831.072 End of DBcopy_graph_to_host() 14616:20180418:155831.073 In DBcopy_graph_to_host() 14616:20180418:155831.073 In DBget_graphitems() 14616:20180418:155831.073 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=16 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.073 DBget_graphitems() [0] itemid:27281 key:'system.swap.size[,pfree]' 14616:20180418:155831.073 DBget_graphitems() [1] itemid:27298 key:'vm.memory.percent_used' 14616:20180418:155831.073 End of DBget_graphitems() 14616:20180418:155831.073 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Memory Usage' and g.templateid is null] 14616:20180418:155831.074 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.074 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.074 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.075 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.075 End of DBget_nextid():4730 table:'graphs' recid:'graphid' 14616:20180418:155831.075 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.075 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.075 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.076 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.076 End of DBget_nextid():13316 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.076 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4730,'Memory Usage',900,200,0.000000,100.000000,16,0,1,0,1,0,0.000000,0.000000,0,0,null,null,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13316,4730,27281,0,1,'00C800',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13317,4730,27298,0,0,'C80000',0,2,0); ] 14616:20180418:155831.076 End of DBcopy_graph_to_host() 14616:20180418:155831.077 In DBcopy_graph_to_host() 14616:20180418:155831.077 In DBget_graphitems() 14616:20180418:155831.077 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=13 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.077 DBget_graphitems() [0] itemid:27286 key:'vfs.dev.read[,sps]' 14616:20180418:155831.077 DBget_graphitems() [1] itemid:27287 key:'vfs.dev.write[,sps]' 14616:20180418:155831.077 End of DBget_graphitems() 14616:20180418:155831.077 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Disk IO' and g.templateid is null] 14616:20180418:155831.078 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.078 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.078 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.078 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.079 End of DBget_nextid():4731 table:'graphs' recid:'graphid' 14616:20180418:155831.079 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.079 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.079 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.080 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.080 End of DBget_nextid():13318 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.080 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4731,'Disk IO',900,200,0.000000,100.000000,13,1,1,0,1,0,0.000000,0.000000,0,0,null,null,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13318,4731,27286,0,0,'DD00DD',0,7,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13319,4731,27287,0,1,'00C800',0,7,0); ] 14616:20180418:155831.081 End of DBcopy_graph_to_host() 14616:20180418:155831.081 In DBcopy_graph_to_host() 14616:20180418:155831.081 In DBget_graphitems() 14616:20180418:155831.081 query [txnlev:1] [select 0,dst.itemid,dst.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,i.flags from graphs_items gi,items i,items dst where gi.itemid=i.itemid and i.key_=dst.key_ and gi.graphid=1 and dst.hostid=10427 order by dst.key_] 14616:20180418:155831.082 DBget_graphitems() [0] itemid:27294 key:'vfs.fs.size[{#FSNAME},free]' 14616:20180418:155831.082 DBget_graphitems() [1] itemid:27296 key:'vfs.fs.size[{#FSNAME},total]' 14616:20180418:155831.082 End of DBget_graphitems() 14616:20180418:155831.082 query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10427 and g.name='Disk space usage {#FSNAME}' and g.templateid is null] 14616:20180418:155831.083 In DBget_nextid() tablename:'graphs' 14616:20180418:155831.083 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.083 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.084 query [txnlev:1] [select nextid from ids where table_name='graphs' and field_name='graphid'] 14616:20180418:155831.084 End of DBget_nextid():4732 table:'graphs' recid:'graphid' 14616:20180418:155831.084 In DBget_nextid() tablename:'graphs_items' 14616:20180418:155831.084 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.085 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.085 query [txnlev:1] [select nextid from ids where table_name='graphs_items' and field_name='gitemid'] 14616:20180418:155831.086 End of DBget_nextid():13320 table:'graphs_items' recid:'gitemid' 14616:20180418:155831.086 query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,templateid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (4732,'Disk space usage {#FSNAME}',900,200,0.000000,100.000000,1,0,0,0,1,0,0.000000,0.000000,0,0,null,null,2); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13320,4732,27294,0,1,'00C800',0,2,0); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (13321,4732,27296,0,0,'C80000',0,2,2); ] 14616:20180418:155831.087 End of DBcopy_graph_to_host() 14616:20180418:155831.087 End of DBcopy_template_graphs() 14616:20180418:155831.087 In DBcopy_template_httptests() 14616:20180418:155831.087 In DBget_httptests() 14616:20180418:155831.087 query [txnlev:1] [select t.httptestid,t.name,t.applicationid,t.delay,t.status,t.variables,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,h.httptestid from httptest t left join httptest h on h.hostid=10427 and h.name=t.name where t.hostid=10096 order by t.httptestid] 14616:20180418:155831.087 End of DBget_httptests() 14616:20180418:155831.087 End of DBcopy_template_httptests() 14616:20180418:155831.087 End of DBcopy_template_elements():SUCCEED 14616:20180418:155831.088 End of op_template_add() 14616:20180418:155831.088 In op_groups_add() 14616:20180418:155831.088 In add_discovered_host() eventid:105226 14616:20180418:155831.088 query [txnlev:1] [select proxy_hostid,host,listen_ip,listen_dns,listen_port from autoreg_host where autoreg_hostid=358] 14616:20180418:155831.088 query [txnlev:1] [select null from hosts where host='duplicate.test.server.us' and status=3] 14616:20180418:155831.088 query [txnlev:1] [select hostid,proxy_hostid from hosts where host='duplicate.test.server.us' and flags<>2 and status in (0,1) order by hostid limit 1] 14616:20180418:155831.089 In DBadd_interface() 14616:20180418:155831.089 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10427 and type=1] 14616:20180418:155831.089 In substitute_simple_macros() data:'10050' 14616:20180418:155831.089 End of DBadd_interface():196 14616:20180418:155831.089 End of add_discovered_host() 14616:20180418:155831.090 In add_discovered_host_groups() 14616:20180418:155831.090 query [txnlev:1] [select groupid from hosts_groups where hostid=10427 and groupid=5] 14616:20180418:155831.090 End of add_discovered_host_groups() 14616:20180418:155831.090 End of op_groups_add() 14616:20180418:155831.090 End of execute_operations() 14616:20180418:155831.090 query [txnlev:1] [insert into escalations (escalationid,actionid,status,triggerid,itemid,eventid,r_eventid) values (17,8,0,null,null,105226,null); ] 14616:20180418:155831.091 End of process_actions() 14616:20180418:155831.091 In DBupdate_itservices() 14616:20180418:155831.091 End of DBupdate_itservices():SUCCEED 14616:20180418:155831.091 End of process_events() 14616:20180418:155831.091 query [txnlev:1] [commit;] 14616:20180418:155831.092 End of process_areg_data():SUCCEED 14616:20180418:155831.093 In zbx_send_response() 14616:20180418:155831.093 zbx_send_response() '{"response":"success"}' 14616:20180418:155831.093 End of zbx_send_response():SUCCEED 14616:20180418:155831.093 End of recv_areg_data():SUCCEED 14616:20180418:155831.093 trapper #1 [processed data in 0.743478 sec, waiting for connection] 14618:20180418:155831.225 trapper #3 [processing data] 14618:20180418:155831.225 trapper got '' 14618:20180418:155831.225 trapper #3 [processed data in 0.000068 sec, waiting for connection] 14605:20180418:155831.896 poller #15 [got 0 values in 0.000154 sec, getting values] 14605:20180418:155831.896 In get_values() 14605:20180418:155831.896 In DCconfig_get_poller_items() poller_type:0 14605:20180418:155831.896 End of DCconfig_get_poller_items():0 14605:20180418:155831.896 End of get_values():0 14605:20180418:155831.896 In DCconfig_get_poller_nextcheck() poller_type:0 14605:20180418:155831.896 End of DCconfig_get_poller_nextcheck():-1 14605:20180418:155831.896 poller #15 [got 0 values in 0.000224 sec, idle 5 sec] 14625:20180418:155831.897 icmp pinger #5 [getting values] 14625:20180418:155831.897 In get_pinger_hosts() 14625:20180418:155831.897 In DCconfig_get_poller_items() poller_type:3 14625:20180418:155831.897 End of DCconfig_get_poller_items():0 14625:20180418:155831.897 End of get_pinger_hosts():0 14625:20180418:155831.897 In process_pinger_hosts() 14625:20180418:155831.897 End of process_pinger_hosts() 14625:20180418:155831.897 In DCconfig_get_poller_nextcheck() poller_type:3 14625:20180418:155831.897 End of DCconfig_get_poller_nextcheck():-1 14625:20180418:155831.897 icmp pinger #5 [got 0 values in 0.000391 sec, idle 5 sec] 14621:20180418:155831.911 icmp pinger #1 [getting values] 14621:20180418:155831.911 In get_pinger_hosts() 14621:20180418:155831.911 In DCconfig_get_poller_items() poller_type:3 14621:20180418:155831.911 End of DCconfig_get_poller_items():0 14621:20180418:155831.911 End of get_pinger_hosts():0 14621:20180418:155831.911 In process_pinger_hosts() 14621:20180418:155831.911 End of process_pinger_hosts() 14621:20180418:155831.911 In DCconfig_get_poller_nextcheck() poller_type:3 14621:20180418:155831.911 End of DCconfig_get_poller_nextcheck():-1 14621:20180418:155831.911 icmp pinger #1 [got 0 values in 0.000483 sec, idle 5 sec] 14622:20180418:155831.912 icmp pinger #2 [getting values] 14622:20180418:155831.912 In get_pinger_hosts() 14622:20180418:155831.912 In DCconfig_get_poller_items() poller_type:3 14622:20180418:155831.912 End of DCconfig_get_poller_items():0 14622:20180418:155831.912 End of get_pinger_hosts():0 14622:20180418:155831.912 In process_pinger_hosts() 14622:20180418:155831.912 End of process_pinger_hosts() 14622:20180418:155831.912 In DCconfig_get_poller_nextcheck() poller_type:3 14622:20180418:155831.912 End of DCconfig_get_poller_nextcheck():-1 14622:20180418:155831.912 icmp pinger #2 [got 0 values in 0.000404 sec, idle 5 sec] 14624:20180418:155831.913 icmp pinger #4 [getting values] 14624:20180418:155831.913 In get_pinger_hosts() 14624:20180418:155831.913 In DCconfig_get_poller_items() poller_type:3 14624:20180418:155831.913 End of DCconfig_get_poller_items():0 14624:20180418:155831.913 End of get_pinger_hosts():0 14624:20180418:155831.913 In process_pinger_hosts() 14624:20180418:155831.913 End of process_pinger_hosts() 14624:20180418:155831.913 In DCconfig_get_poller_nextcheck() poller_type:3 14624:20180418:155831.913 End of DCconfig_get_poller_nextcheck():-1 14624:20180418:155831.914 icmp pinger #4 [got 0 values in 0.000411 sec, idle 5 sec] 14607:20180418:155831.921 poller #17 [got 0 values in 0.000282 sec, getting values] 14607:20180418:155831.921 In get_values() 14607:20180418:155831.921 In DCconfig_get_poller_items() poller_type:0 14607:20180418:155831.921 End of DCconfig_get_poller_items():0 14607:20180418:155831.921 End of get_values():0 14607:20180418:155831.921 In DCconfig_get_poller_nextcheck() poller_type:0 14607:20180418:155831.921 End of DCconfig_get_poller_nextcheck():-1 14607:20180418:155831.921 poller #17 [got 0 values in 0.000172 sec, idle 5 sec] 14603:20180418:155831.923 poller #13 [got 0 values in 0.000226 sec, getting values] 14603:20180418:155831.923 In get_values() 14603:20180418:155831.923 In DCconfig_get_poller_items() poller_type:0 14603:20180418:155831.923 End of DCconfig_get_poller_items():0 14603:20180418:155831.923 End of get_values():0 14603:20180418:155831.923 In DCconfig_get_poller_nextcheck() poller_type:0 14603:20180418:155831.923 End of DCconfig_get_poller_nextcheck():-1 14603:20180418:155831.923 poller #13 [got 0 values in 0.000127 sec, idle 5 sec] 14595:20180418:155831.925 poller #5 [got 0 values in 0.000261 sec, getting values] 14595:20180418:155831.925 In get_values() 14595:20180418:155831.925 In DCconfig_get_poller_items() poller_type:0 14595:20180418:155831.925 End of DCconfig_get_poller_items():0 14595:20180418:155831.925 End of get_values():0 14595:20180418:155831.925 In DCconfig_get_poller_nextcheck() poller_type:0 14595:20180418:155831.925 End of DCconfig_get_poller_nextcheck():-1 14595:20180418:155831.925 poller #5 [got 0 values in 0.000184 sec, idle 5 sec] 14599:20180418:155831.932 poller #9 [got 0 values in 0.000275 sec, getting values] 14599:20180418:155831.932 In get_values() 14599:20180418:155831.932 In DCconfig_get_poller_items() poller_type:0 14602:20180418:155831.932 poller #12 [got 0 values in 0.000220 sec, getting values] 14599:20180418:155831.932 End of DCconfig_get_poller_items():0 14602:20180418:155831.932 In get_values() 14599:20180418:155831.932 End of get_values():0 14602:20180418:155831.932 In DCconfig_get_poller_items() poller_type:0 14599:20180418:155831.932 In DCconfig_get_poller_nextcheck() poller_type:0 14602:20180418:155831.932 End of DCconfig_get_poller_items():0 14599:20180418:155831.932 End of DCconfig_get_poller_nextcheck():-1 14602:20180418:155831.932 End of get_values():0 14599:20180418:155831.932 poller #9 [got 0 values in 0.000336 sec, idle 5 sec] 14602:20180418:155831.932 In DCconfig_get_poller_nextcheck() poller_type:0 14602:20180418:155831.933 End of DCconfig_get_poller_nextcheck():-1 14602:20180418:155831.933 poller #12 [got 0 values in 0.000443 sec, idle 5 sec] 14610:20180418:155831.933 poller #20 [got 0 values in 0.000285 sec, getting values] 14610:20180418:155831.933 In get_values() 14610:20180418:155831.933 In DCconfig_get_poller_items() poller_type:0 14610:20180418:155831.933 End of DCconfig_get_poller_items():0 14610:20180418:155831.933 End of get_values():0 14610:20180418:155831.933 In DCconfig_get_poller_nextcheck() poller_type:0 14610:20180418:155831.933 End of DCconfig_get_poller_nextcheck():-1 14610:20180418:155831.933 poller #20 [got 0 values in 0.000181 sec, idle 5 sec] 14635:20180418:155831.935 http poller #2 [got 0 values in 0.001218 sec, getting values] 14635:20180418:155831.935 In process_httptests() 14635:20180418:155831.935 query [txnlev:0] [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_key_password,t.verify_peer,t.verify_host from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1524085111 and mod(t.httptestid,2)=1 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)] 14635:20180418:155831.937 End of process_httptests() 14635:20180418:155831.937 query [txnlev:0] [select min(t.nextcheck) from httptest t,hosts h where t.hostid=h.hostid and mod(t.httptestid,2)=1 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)] 14591:20180418:155831.937 poller #1 [got 0 values in 0.000269 sec, getting values] 14591:20180418:155831.937 In get_values() 14591:20180418:155831.937 In DCconfig_get_poller_items() poller_type:0 14591:20180418:155831.937 End of DCconfig_get_poller_items():0 14591:20180418:155831.937 End of get_values():0 14591:20180418:155831.937 In DCconfig_get_poller_nextcheck() poller_type:0 14591:20180418:155831.937 End of DCconfig_get_poller_nextcheck():-1 14591:20180418:155831.937 poller #1 [got 0 values in 0.000193 sec, idle 5 sec] 14635:20180418:155831.938 No httptests to process in get_minnextcheck. 14635:20180418:155831.938 http poller #2 [got 0 values in 0.001702 sec, idle 5 sec] 14597:20180418:155831.941 poller #7 [got 0 values in 0.000226 sec, getting values] 14597:20180418:155831.941 In get_values() 14597:20180418:155831.941 In DCconfig_get_poller_items() poller_type:0 14597:20180418:155831.942 End of DCconfig_get_poller_items():0 14597:20180418:155831.942 End of get_values():0 14597:20180418:155831.942 In DCconfig_get_poller_nextcheck() poller_type:0 14597:20180418:155831.942 End of DCconfig_get_poller_nextcheck():-1 14597:20180418:155831.942 poller #7 [got 0 values in 0.000110 sec, idle 5 sec] 14592:20180418:155831.943 poller #2 [got 0 values in 0.000710 sec, getting values] 14592:20180418:155831.943 In get_values() 14592:20180418:155831.943 In DCconfig_get_poller_items() poller_type:0 14592:20180418:155831.943 End of DCconfig_get_poller_items():0 14592:20180418:155831.943 End of get_values():0 14592:20180418:155831.943 In DCconfig_get_poller_nextcheck() poller_type:0 14596:20180418:155831.943 poller #6 [got 0 values in 0.000850 sec, getting values] 14592:20180418:155831.943 End of DCconfig_get_poller_nextcheck():-1 14596:20180418:155831.943 In get_values() 14592:20180418:155831.943 poller #2 [got 0 values in 0.000283 sec, idle 5 sec] 14596:20180418:155831.943 In DCconfig_get_poller_items() poller_type:0 14596:20180418:155831.943 End of DCconfig_get_poller_items():0 14596:20180418:155831.943 End of get_values():0 14596:20180418:155831.943 In DCconfig_get_poller_nextcheck() poller_type:0 14596:20180418:155831.943 End of DCconfig_get_poller_nextcheck():-1 14596:20180418:155831.943 poller #6 [got 0 values in 0.000337 sec, idle 5 sec] 14608:20180418:155831.948 poller #18 [got 0 values in 0.000275 sec, getting values] 14608:20180418:155831.948 In get_values() 14608:20180418:155831.948 In DCconfig_get_poller_items() poller_type:0 14608:20180418:155831.948 End of DCconfig_get_poller_items():0 14608:20180418:155831.948 End of get_values():0 14608:20180418:155831.948 In DCconfig_get_poller_nextcheck() poller_type:0 14608:20180418:155831.948 End of DCconfig_get_poller_nextcheck():-1 14608:20180418:155831.948 poller #18 [got 0 values in 0.000283 sec, idle 5 sec] 14609:20180418:155831.955 poller #19 [got 0 values in 0.000142 sec, getting values] 14609:20180418:155831.955 In get_values() 14609:20180418:155831.955 In DCconfig_get_poller_items() poller_type:0 14609:20180418:155831.955 End of DCconfig_get_poller_items():0 14609:20180418:155831.955 End of get_values():0 14609:20180418:155831.956 In DCconfig_get_poller_nextcheck() poller_type:0 14609:20180418:155831.956 End of DCconfig_get_poller_nextcheck():-1 14609:20180418:155831.956 poller #19 [got 0 values in 0.000263 sec, idle 5 sec] 14600:20180418:155831.961 poller #10 [got 0 values in 0.000270 sec, getting values] 14600:20180418:155831.961 In get_values() 14600:20180418:155831.961 In DCconfig_get_poller_items() poller_type:0 14600:20180418:155831.961 End of DCconfig_get_poller_items():0 14600:20180418:155831.961 End of get_values():0 14600:20180418:155831.961 In DCconfig_get_poller_nextcheck() poller_type:0 14600:20180418:155831.961 End of DCconfig_get_poller_nextcheck():-1 14600:20180418:155831.961 poller #10 [got 0 values in 0.000105 sec, idle 5 sec] 14606:20180418:155831.963 poller #16 [got 0 values in 0.000204 sec, getting values] 14606:20180418:155831.963 In get_values() 14606:20180418:155831.963 In DCconfig_get_poller_items() poller_type:0 14606:20180418:155831.963 End of DCconfig_get_poller_items():0 14606:20180418:155831.963 End of get_values():0 14606:20180418:155831.963 In DCconfig_get_poller_nextcheck() poller_type:0 14606:20180418:155831.963 End of DCconfig_get_poller_nextcheck():-1 14606:20180418:155831.963 poller #16 [got 0 values in 0.000113 sec, idle 5 sec] 14593:20180418:155831.965 poller #3 [got 0 values in 0.000392 sec, getting values] 14593:20180418:155831.965 In get_values() 14593:20180418:155831.965 In DCconfig_get_poller_items() poller_type:0 14593:20180418:155831.965 End of DCconfig_get_poller_items():0 14593:20180418:155831.965 End of get_values():0 14593:20180418:155831.965 In DCconfig_get_poller_nextcheck() poller_type:0 14593:20180418:155831.965 End of DCconfig_get_poller_nextcheck():-1 14593:20180418:155831.965 poller #3 [got 0 values in 0.000262 sec, idle 5 sec] 14601:20180418:155831.966 poller #11 [got 0 values in 0.000578 sec, getting values] 14601:20180418:155831.966 In get_values() 14601:20180418:155831.966 In DCconfig_get_poller_items() poller_type:0 14601:20180418:155831.966 End of DCconfig_get_poller_items():0 14601:20180418:155831.966 End of get_values():0 14601:20180418:155831.966 In DCconfig_get_poller_nextcheck() poller_type:0 14601:20180418:155831.966 End of DCconfig_get_poller_nextcheck():-1 14601:20180418:155831.966 poller #11 [got 0 values in 0.000120 sec, idle 5 sec] 14598:20180418:155831.974 poller #8 [got 0 values in 0.000157 sec, getting values] 14598:20180418:155831.974 In get_values() 14598:20180418:155831.974 In DCconfig_get_poller_items() poller_type:0 14598:20180418:155831.974 End of DCconfig_get_poller_items():0 14598:20180418:155831.974 End of get_values():0 14598:20180418:155831.974 In DCconfig_get_poller_nextcheck() poller_type:0 14598:20180418:155831.974 End of DCconfig_get_poller_nextcheck():-1 14598:20180418:155831.974 poller #8 [got 0 values in 0.000288 sec, idle 5 sec] 14594:20180418:155831.983 poller #4 [got 0 values in 0.000134 sec, getting values] 14594:20180418:155831.983 In get_values() 14594:20180418:155831.983 In DCconfig_get_poller_items() poller_type:0 14594:20180418:155831.984 End of DCconfig_get_poller_items():0 14594:20180418:155831.984 End of get_values():0 14594:20180418:155831.984 In DCconfig_get_poller_nextcheck() poller_type:0 14594:20180418:155831.984 End of DCconfig_get_poller_nextcheck():-1 14594:20180418:155831.984 poller #4 [got 0 values in 0.000263 sec, idle 5 sec] 14645:20180418:155832.002 history syncer #9 [synced 0 items in 0.000034 sec, syncing history] 14645:20180418:155832.003 In DCsync_history() history_first:371309 history_num:0 14645:20180418:155832.003 history syncer #9 [synced 0 items in 0.000074 sec, idle 5 sec] 14654:20180418:155832.030 self-monitoring [processing data] 14654:20180418:155832.030 In collect_selfmon_stats() 14654:20180418:155832.030 End of collect_selfmon_stats() 14654:20180418:155832.030 self-monitoring [processed data in 0.000065 sec, idle 1 sec] 14637:20180418:155832.897 history syncer #1 [synced 0 items in 0.000044 sec, syncing history] 14637:20180418:155832.897 In DCsync_history() history_first:371309 history_num:0 14637:20180418:155832.897 history syncer #1 [synced 0 items in 0.000036 sec, idle 5 sec] 14640:20180418:155832.897 history syncer #4 [synced 0 items in 0.000040 sec, syncing history] 14640:20180418:155832.898 In DCsync_history() history_first:371309 history_num:0 14644:20180418:155832.898 history syncer #8 [synced 0 items in 0.000033 sec, syncing history] 14640:20180418:155832.898 history syncer #4 [synced 0 items in 0.000080 sec, idle 5 sec] 14644:20180418:155832.898 In DCsync_history() history_first:371309 history_num:0 14639:20180418:155832.898 history syncer #3 [synced 0 items in 0.000077 sec, syncing history] 14644:20180418:155832.898 history syncer #8 [synced 0 items in 0.000149 sec, idle 5 sec] 14639:20180418:155832.898 In DCsync_history() history_first:371309 history_num:0 14639:20180418:155832.898 history syncer #3 [synced 0 items in 0.000112 sec, idle 5 sec] 14638:20180418:155832.899 history syncer #2 [synced 0 items in 0.000036 sec, syncing history] 14638:20180418:155832.899 In DCsync_history() history_first:371309 history_num:0 14638:20180418:155832.899 history syncer #2 [synced 0 items in 0.000084 sec, idle 5 sec] 14646:20180418:155832.899 history syncer #10 [synced 0 items in 0.000033 sec, syncing history] 14646:20180418:155832.899 In DCsync_history() history_first:371309 history_num:0 14646:20180418:155832.899 history syncer #10 [synced 0 items in 0.000066 sec, idle 5 sec] 14642:20180418:155832.900 history syncer #6 [synced 0 items in 0.000055 sec, syncing history] 14642:20180418:155832.900 In DCsync_history() history_first:371309 history_num:0 14642:20180418:155832.900 history syncer #6 [synced 0 items in 0.000067 sec, idle 5 sec] 14643:20180418:155832.901 history syncer #7 [synced 0 items in 0.000054 sec, syncing history] 14643:20180418:155832.901 In DCsync_history() history_first:371309 history_num:0 14643:20180418:155832.901 history syncer #7 [synced 0 items in 0.000086 sec, idle 5 sec] 14604:20180418:155832.911 poller #14 [got 0 values in 0.000208 sec, getting values] 14604:20180418:155832.911 In get_values() 14604:20180418:155832.911 In DCconfig_get_poller_items() poller_type:0 14604:20180418:155832.911 End of DCconfig_get_poller_items():0 14604:20180418:155832.911 End of get_values():0 14604:20180418:155832.911 In DCconfig_get_poller_nextcheck() poller_type:0 14604:20180418:155832.911 End of DCconfig_get_poller_nextcheck():-1 14604:20180418:155832.912 poller #14 [got 0 values in 0.000112 sec, idle 5 sec] 14614:20180418:155832.925 unreachable poller #4 [got 0 values in 0.000217 sec, getting values] 14614:20180418:155832.925 In get_values() 14614:20180418:155832.925 In DCconfig_get_poller_items() poller_type:1 14614:20180418:155832.925 End of DCconfig_get_poller_items():0 14614:20180418:155832.925 End of get_values():0 14614:20180418:155832.925 In DCconfig_get_poller_nextcheck() poller_type:1 14614:20180418:155832.925 End of DCconfig_get_poller_nextcheck():-1 14614:20180418:155832.925 unreachable poller #4 [got 0 values in 0.000121 sec, idle 5 sec] 14615:20180418:155832.942 unreachable poller #5 [got 0 values in 0.000268 sec, getting values] 14615:20180418:155832.942 In get_values() 14615:20180418:155832.942 In DCconfig_get_poller_items() poller_type:1 14615:20180418:155832.942 End of DCconfig_get_poller_items():0 14615:20180418:155832.942 End of get_values():0 14615:20180418:155832.942 In DCconfig_get_poller_nextcheck() poller_type:1 14615:20180418:155832.942 End of DCconfig_get_poller_nextcheck():-1 14615:20180418:155832.942 unreachable poller #5 [got 0 values in 0.000175 sec, idle 5 sec] 14612:20180418:155832.958 unreachable poller #2 [got 0 values in 0.000215 sec, getting values] 14612:20180418:155832.958 In get_values() 14612:20180418:155832.958 In DCconfig_get_poller_items() poller_type:1 14612:20180418:155832.958 End of DCconfig_get_poller_items():0 14612:20180418:155832.958 End of get_values():0 14612:20180418:155832.958 In DCconfig_get_poller_nextcheck() poller_type:1 14612:20180418:155832.958 End of DCconfig_get_poller_nextcheck():-1 14612:20180418:155832.958 unreachable poller #2 [got 0 values in 0.000130 sec, idle 5 sec] 14613:20180418:155832.978 unreachable poller #3 [got 0 values in 0.000107 sec, getting values] 14613:20180418:155832.978 In get_values() 14613:20180418:155832.978 In DCconfig_get_poller_items() poller_type:1 14613:20180418:155832.978 End of DCconfig_get_poller_items():0 14613:20180418:155832.978 End of get_values():0 14613:20180418:155832.978 In DCconfig_get_poller_nextcheck() poller_type:1 14613:20180418:155832.978 End of DCconfig_get_poller_nextcheck():-1 14613:20180418:155832.978 unreachable poller #3 [got 0 values in 0.000129 sec, idle 5 sec] 14611:20180418:155832.984 unreachable poller #1 [got 0 values in 0.000260 sec, getting values] 14611:20180418:155832.984 In get_values() 14611:20180418:155832.984 In DCconfig_get_poller_items() poller_type:1 14611:20180418:155832.984 End of DCconfig_get_poller_items():0 14611:20180418:155832.984 End of get_values():0 14611:20180418:155832.984 In DCconfig_get_poller_nextcheck() poller_type:1 14611:20180418:155832.984 End of DCconfig_get_poller_nextcheck():-1 14611:20180418:155832.984 unreachable poller #1 [got 0 values in 0.000122 sec, idle 5 sec] 14641:20180418:155833.001 history syncer #5 [synced 0 items in 0.000075 sec, syncing history] 14641:20180418:155833.001 In DCsync_history() history_first:371309 history_num:0 14641:20180418:155833.001 history syncer #5 [synced 0 items in 0.000075 sec, idle 5 sec] 14654:20180418:155833.030 self-monitoring [processing data] 14654:20180418:155833.031 In collect_selfmon_stats() 14654:20180418:155833.031 End of collect_selfmon_stats() 14654:20180418:155833.031 self-monitoring [processed data in 0.000067 sec, idle 1 sec] 14623:20180418:155833.899 icmp pinger #3 [getting values] 14623:20180418:155833.899 In get_pinger_hosts() 14623:20180418:155833.899 In DCconfig_get_poller_items() poller_type:3 14623:20180418:155833.899 End of DCconfig_get_poller_items():0 14623:20180418:155833.899 End of get_pinger_hosts():0 14623:20180418:155833.900 In process_pinger_hosts() 14623:20180418:155833.900 End of process_pinger_hosts() 14623:20180418:155833.900 In DCconfig_get_poller_nextcheck() poller_type:3 14623:20180418:155833.900 End of DCconfig_get_poller_nextcheck():-1 14623:20180418:155833.900 icmp pinger #3 [got 0 values in 0.000444 sec, idle 5 sec] 14655:20180418:155833.941 vmware collector #1 [updated 0, removed 0 VMware services in 0.000004 sec, querying VMware services] 14655:20180418:155833.941 vmware collector #1 [updated 0, removed 0 VMware services in 0.000004 sec, idle 5 sec] 14636:20180418:155833.970 discoverer #1 [processed 0 rules in 0.000866 sec, performing discovery] 14636:20180418:155833.970 query [txnlev:0] [select distinct r.druleid,r.iprange,r.name,c.dcheckid,r.proxy_hostid from drules r left join dchecks c on c.druleid=r.druleid and c.uniq=1 where r.status=0 and (r.nextcheck<=1524085113 or r.nextcheck>1524085113+r.delay) and mod(r.druleid,1)=0] 14636:20180418:155833.972 query [txnlev:0] [select count(*),min(nextcheck) from drules where status=0 and mod(druleid,1)=0] 14636:20180418:155833.972 get_minnextcheck(): no items to update 14636:20180418:155833.972 discoverer #1 [processed 0 rules in 0.001297 sec, idle 60 sec] 14651:20180418:155833.977 java poller #4 [got 0 values in 0.000221 sec, getting values] 14651:20180418:155833.977 In get_values() 14651:20180418:155833.977 In DCconfig_get_poller_items() poller_type:4 14651:20180418:155833.977 End of DCconfig_get_poller_items():0 14651:20180418:155833.977 End of get_values():0 14651:20180418:155833.977 In DCconfig_get_poller_nextcheck() poller_type:4 14651:20180418:155833.977 End of DCconfig_get_poller_nextcheck():-1 14651:20180418:155833.978 java poller #4 [got 0 values in 0.000159 sec, idle 5 sec] 14649:20180418:155834.001 java poller #2 [got 0 values in 0.000292 sec, getting values] 14649:20180418:155834.001 In get_values() 14649:20180418:155834.001 In DCconfig_get_poller_items() poller_type:4 14649:20180418:155834.001 End of DCconfig_get_poller_items():0 14649:20180418:155834.001 End of get_values():0 14649:20180418:155834.001 In DCconfig_get_poller_nextcheck() poller_type:4 14649:20180418:155834.001 End of DCconfig_get_poller_nextcheck():-1 14649:20180418:155834.001 java poller #2 [got 0 values in 0.000115 sec, idle 5 sec] 14654:20180418:155834.031 self-monitoring [processing data] 14654:20180418:155834.031 In collect_selfmon_stats() 14654:20180418:155834.031 End of collect_selfmon_stats() 14654:20180418:155834.031 self-monitoring [processed data in 0.000137 sec, idle 1 sec] 14647:20180418:155834.065 escalator [processed 0 escalations in 0.019421 sec, processing escalations] 14647:20180418:155834.066 In process_escalations() 14647:20180418:155834.066 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid from escalations order by actionid,triggerid,itemid,escalationid] 14647:20180418:155834.066 query [txnlev:1] [begin;] 14647:20180418:155834.067 In execute_escalation() escalationid:17 status:active 14647:20180418:155834.067 In check_escalation() escalationid:17 status:active 14647:20180418:155834.067 query [txnlev:1] [select source,object from events where eventid=105226] 14647:20180418:155834.067 query [txnlev:1] [select actionid,name,status,eventsource,esc_period,def_shortdata,def_longdata,recovery_msg from actions where actionid=8] 14647:20180418:155834.067 End of check_escalation() error: (null) 14647:20180418:155834.067 query [txnlev:1] [select eventid,source,object,objectid,clock,value,acknowledged,ns from events where eventid=105226] 14647:20180418:155834.068 In execute_operations() 14647:20180418:155834.068 query [txnlev:1] [select o.operationid,o.operationtype,o.esc_period,o.evaltype,m.operationid,m.default_msg,subject,message,mediatypeid from operations o left join opmessage m on m.operationid=o.operationid where o.actionid=8 and o.operationtype in (0,1)] 14647:20180418:155834.068 End of execute_operations() 14647:20180418:155834.069 End of execute_escalation() 14647:20180418:155834.069 query [txnlev:1] [delete from escalations where escalationid=17] 14647:20180418:155834.069 query [txnlev:1] [commit;] 14647:20180418:155834.070 End of process_escalations() 14647:20180418:155834.070 escalator [processed 0 escalations in 0.004817 sec, idle 3 sec] 14653:20180418:155835.006 proxy poller #1 [exchanged data with 0 proxies in 0.000219 sec, exchanging data] 14653:20180418:155835.006 In process_proxy() 14653:20180418:155835.006 In DCconfig_get_proxypoller_hosts() 14653:20180418:155835.006 End of DCconfig_get_proxypoller_hosts():0 14653:20180418:155835.006 End of process_proxy() 14653:20180418:155835.007 In DCconfig_get_proxypoller_nextcheck() 14653:20180418:155835.007 End of DCconfig_get_proxypoller_nextcheck():-1 14653:20180418:155835.007 proxy poller #1 [exchanged data with 0 proxies in 0.000222 sec, idle 5 sec] 14648:20180418:155835.022 java poller #1 [got 0 values in 0.000131 sec, getting values] 14648:20180418:155835.022 In get_values() 14648:20180418:155835.022 In DCconfig_get_poller_items() poller_type:4 14648:20180418:155835.022 End of DCconfig_get_poller_items():0 14648:20180418:155835.022 End of get_values():0 14648:20180418:155835.022 In DCconfig_get_poller_nextcheck() poller_type:4 14648:20180418:155835.022 End of DCconfig_get_poller_nextcheck():-1 14648:20180418:155835.022 java poller #1 [got 0 values in 0.000273 sec, idle 5 sec] 14650:20180418:155835.023 java poller #3 [got 0 values in 0.000130 sec, getting values] 14650:20180418:155835.023 In get_values() 14650:20180418:155835.023 In DCconfig_get_poller_items() poller_type:4 14650:20180418:155835.023 End of DCconfig_get_poller_items():0 14650:20180418:155835.023 End of get_values():0 14650:20180418:155835.023 In DCconfig_get_poller_nextcheck() poller_type:4 14650:20180418:155835.023 End of DCconfig_get_poller_nextcheck():-1 14650:20180418:155835.023 java poller #3 [got 0 values in 0.000261 sec, idle 5 sec] 14652:20180418:155835.024 java poller #5 [got 0 values in 0.000306 sec, getting values] 14652:20180418:155835.024 In get_values() 14652:20180418:155835.024 In DCconfig_get_poller_items() poller_type:4 14652:20180418:155835.024 End of DCconfig_get_poller_items():0 14652:20180418:155835.024 End of get_values():0 14652:20180418:155835.024 In DCconfig_get_poller_nextcheck() poller_type:4 14652:20180418:155835.024 End of DCconfig_get_poller_nextcheck():-1 14652:20180418:155835.024 java poller #5 [got 0 values in 0.000149 sec, idle 5 sec] 14654:20180418:155835.031 self-monitoring [processing data] 14654:20180418:155835.031 In collect_selfmon_stats() 14654:20180418:155835.031 End of collect_selfmon_stats() 14654:20180418:155835.031 self-monitoring [processed data in 0.000064 sec, idle 1 sec] 14634:20180418:155835.048 http poller #1 [got 0 values in 0.001086 sec, getting values] 14634:20180418:155835.048 In process_httptests() 14634:20180418:155835.048 query [txnlev:0] [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_key_password,t.verify_peer,t.verify_host from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1524085115 and mod(t.httptestid,2)=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)] 14634:20180418:155835.049 End of process_httptests() 14634:20180418:155835.049 query [txnlev:0] [select min(t.nextcheck) from httptest t,hosts h where t.hostid=h.hostid and mod(t.httptestid,2)=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)] 14634:20180418:155835.050 No httptests to process in get_minnextcheck. 14634:20180418:155835.050 http poller #1 [got 0 values in 0.001218 sec, idle 5 sec] 14654:20180418:155836.032 self-monitoring [processing data] 14654:20180418:155836.032 In collect_selfmon_stats() 14654:20180418:155836.032 End of collect_selfmon_stats() 14654:20180418:155836.032 self-monitoring [processed data in 0.000133 sec, idle 1 sec] 14605:20180418:155836.909 poller #15 [got 0 values in 0.000224 sec, getting values] 14605:20180418:155836.910 In get_values() 14605:20180418:155836.910 In DCconfig_get_poller_items() poller_type:0 14605:20180418:155836.910 End of DCconfig_get_poller_items():0 14605:20180418:155836.910 End of get_values():0 14605:20180418:155836.910 In DCconfig_get_poller_nextcheck() poller_type:0 14605:20180418:155836.910 End of DCconfig_get_poller_nextcheck():-1 14605:20180418:155836.910 poller #15 [got 0 values in 0.000317 sec, idle 5 sec] 14625:20180418:155836.910 icmp pinger #5 [getting values] 14625:20180418:155836.910 In get_pinger_hosts() 14625:20180418:155836.910 In DCconfig_get_poller_items() poller_type:3 14625:20180418:155836.910 End of DCconfig_get_poller_items():0 14625:20180418:155836.910 End of get_pinger_hosts():0 14625:20180418:155836.911 In process_pinger_hosts() 14625:20180418:155836.911 End of process_pinger_hosts() 14625:20180418:155836.911 In DCconfig_get_poller_nextcheck() poller_type:3 14625:20180418:155836.911 End of DCconfig_get_poller_nextcheck():-1 14625:20180418:155836.911 icmp pinger #5 [got 0 values in 0.000320 sec, idle 5 sec] 14621:20180418:155836.912 icmp pinger #1 [getting values] 14621:20180418:155836.912 In get_pinger_hosts() 14621:20180418:155836.912 In DCconfig_get_poller_items() poller_type:3 14621:20180418:155836.912 End of DCconfig_get_poller_items():0 14621:20180418:155836.912 End of get_pinger_hosts():0 14621:20180418:155836.912 In process_pinger_hosts() 14621:20180418:155836.912 End of process_pinger_hosts() 14621:20180418:155836.912 In DCconfig_get_poller_nextcheck() poller_type:3 14621:20180418:155836.912 End of DCconfig_get_poller_nextcheck():-1 14621:20180418:155836.912 icmp pinger #1 [got 0 values in 0.000303 sec, idle 5 sec] 14622:20180418:155836.913 icmp pinger #2 [getting values] 14622:20180418:155836.913 In get_pinger_hosts() 14622:20180418:155836.913 In DCconfig_get_poller_items() poller_type:3 14622:20180418:155836.913 End of DCconfig_get_poller_items():0 14622:20180418:155836.913 End of get_pinger_hosts():0 14622:20180418:155836.913 In process_pinger_hosts() 14622:20180418:155836.913 End of process_pinger_hosts() 14622:20180418:155836.913 In DCconfig_get_poller_nextcheck() poller_type:3 14622:20180418:155836.913 End of DCconfig_get_poller_nextcheck():-1 14622:20180418:155836.913 icmp pinger #2 [got 0 values in 0.000196 sec, idle 5 sec] 14624:20180418:155836.914 icmp pinger #4 [getting values] 14624:20180418:155836.914 In get_pinger_hosts() 14624:20180418:155836.914 In DCconfig_get_poller_items() poller_type:3 14624:20180418:155836.914 End of DCconfig_get_poller_items():0 14624:20180418:155836.914 End of get_pinger_hosts():0 14624:20180418:155836.914 In process_pinger_hosts() 14624:20180418:155836.914 End of process_pinger_hosts() 14624:20180418:155836.914 In DCconfig_get_poller_nextcheck() poller_type:3 14624:20180418:155836.914 End of DCconfig_get_poller_nextcheck():-1 14624:20180418:155836.914 icmp pinger #4 [got 0 values in 0.000162 sec, idle 5 sec] 14607:20180418:155836.922 poller #17 [got 0 values in 0.000172 sec, getting values] 14607:20180418:155836.922 In get_values() 14607:20180418:155836.922 In DCconfig_get_poller_items() poller_type:0 14607:20180418:155836.922 End of DCconfig_get_poller_items():0 14607:20180418:155836.922 End of get_values():0 14607:20180418:155836.922 In DCconfig_get_poller_nextcheck() poller_type:0 14607:20180418:155836.922 End of DCconfig_get_poller_nextcheck():-1 14607:20180418:155836.922 poller #17 [got 0 values in 0.000166 sec, idle 5 sec] 14603:20180418:155836.925 poller #13 [got 0 values in 0.000127 sec, getting values] 14603:20180418:155836.925 In get_values() 14603:20180418:155836.925 In DCconfig_get_poller_items() poller_type:0 14603:20180418:155836.925 End of DCconfig_get_poller_items():0 14603:20180418:155836.925 End of get_values():0 14603:20180418:155836.925 In DCconfig_get_poller_nextcheck() poller_type:0 14603:20180418:155836.925 End of DCconfig_get_poller_nextcheck():-1 14603:20180418:155836.925 poller #13 [got 0 values in 0.000157 sec, idle 5 sec] 14595:20180418:155836.926 poller #5 [got 0 values in 0.000184 sec, getting values] 14595:20180418:155836.926 In get_values() 14595:20180418:155836.926 In DCconfig_get_poller_items() poller_type:0 14595:20180418:155836.926 End of DCconfig_get_poller_items():0 14595:20180418:155836.926 End of get_values():0 14595:20180418:155836.926 In DCconfig_get_poller_nextcheck() poller_type:0 14595:20180418:155836.926 End of DCconfig_get_poller_nextcheck():-1 14595:20180418:155836.926 poller #5 [got 0 values in 0.000109 sec, idle 5 sec] 14599:20180418:155836.933 poller #9 [got 0 values in 0.000336 sec, getting values] 14599:20180418:155836.933 In get_values() 14599:20180418:155836.933 In DCconfig_get_poller_items() poller_type:0 14599:20180418:155836.933 End of DCconfig_get_poller_items():0 14599:20180418:155836.933 End of get_values():0 14599:20180418:155836.933 In DCconfig_get_poller_nextcheck() poller_type:0 14599:20180418:155836.933 End of DCconfig_get_poller_nextcheck():-1 14599:20180418:155836.933 poller #9 [got 0 values in 0.000111 sec, idle 5 sec] 14602:20180418:155836.933 poller #12 [got 0 values in 0.000443 sec, getting values] 14602:20180418:155836.933 In get_values() 14602:20180418:155836.933 In DCconfig_get_poller_items() poller_type:0 14602:20180418:155836.933 End of DCconfig_get_poller_items():0 14602:20180418:155836.933 End of get_values():0 14602:20180418:155836.933 In DCconfig_get_poller_nextcheck() poller_type:0 14602:20180418:155836.933 End of DCconfig_get_poller_nextcheck():-1 14602:20180418:155836.933 poller #12 [got 0 values in 0.000128 sec, idle 5 sec] 14610:20180418:155836.933 poller #20 [got 0 values in 0.000181 sec, getting values] 14610:20180418:155836.934 In get_values() 14610:20180418:155836.934 In DCconfig_get_poller_items() poller_type:0 14610:20180418:155836.934 End of DCconfig_get_poller_items():0 14610:20180418:155836.934 End of get_values():0 14610:20180418:155836.934 In DCconfig_get_poller_nextcheck() poller_type:0 14610:20180418:155836.934 End of DCconfig_get_poller_nextcheck():-1 14610:20180418:155836.934 poller #20 [got 0 values in 0.000104 sec, idle 5 sec] 14591:20180418:155836.937 poller #1 [got 0 values in 0.000193 sec, getting values] 14591:20180418:155836.938 In get_values() 14591:20180418:155836.938 In DCconfig_get_poller_items() poller_type:0 14591:20180418:155836.938 End of DCconfig_get_poller_items():0 14591:20180418:155836.938 End of get_values():0 14591:20180418:155836.938 In DCconfig_get_poller_nextcheck() poller_type:0 14591:20180418:155836.938 End of DCconfig_get_poller_nextcheck():-1 14591:20180418:155836.938 poller #1 [got 0 values in 0.000117 sec, idle 5 sec] 14635:20180418:155836.939 http poller #2 [got 0 values in 0.001702 sec, getting values] 14635:20180418:155836.939 In process_httptests() 14635:20180418:155836.939 query [txnlev:0] [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_key_password,t.verify_peer,t.verify_host from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1524085116 and mod(t.httptestid,2)=1 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)] 14635:20180418:155836.942 End of process_httptests() 14635:20180418:155836.943 query [txnlev:0] [select min(t.nextcheck) from httptest t,hosts h where t.hostid=h.hostid and mod(t.httptestid,2)=1 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)] 14597:20180418:155836.943 poller #7 [got 0 values in 0.000110 sec, getting values] 14597:20180418:155836.943 In get_values() 14597:20180418:155836.943 In DCconfig_get_poller_items() poller_type:0 14597:20180418:155836.943 End of DCconfig_get_poller_items():0 14597:20180418:155836.943 End of get_values():0 14597:20180418:155836.943 In DCconfig_get_poller_nextcheck() poller_type:0 14597:20180418:155836.943 End of DCconfig_get_poller_nextcheck():-1 14597:20180418:155836.943 poller #7 [got 0 values in 0.000123 sec, idle 5 sec] 14635:20180418:155836.943 No httptests to process in get_minnextcheck. 14635:20180418:155836.943 http poller #2 [got 0 values in 0.003674 sec, idle 5 sec] 14592:20180418:155836.944 poller #2 [got 0 values in 0.000283 sec, getting values] 14592:20180418:155836.944 In get_values() 14592:20180418:155836.944 In DCconfig_get_poller_items() poller_type:0 14592:20180418:155836.944 End of DCconfig_get_poller_items():0 14592:20180418:155836.944 End of get_values():0 14592:20180418:155836.944 In DCconfig_get_poller_nextcheck() poller_type:0 14592:20180418:155836.944 End of DCconfig_get_poller_nextcheck():-1 14592:20180418:155836.944 poller #2 [got 0 values in 0.000109 sec, idle 5 sec] 14596:20180418:155836.945 poller #6 [got 0 values in 0.000337 sec, getting values] 14596:20180418:155836.945 In get_values() 14596:20180418:155836.945 In DCconfig_get_poller_items() poller_type:0 14596:20180418:155836.945 End of DCconfig_get_poller_items():0 14596:20180418:155836.945 End of get_values():0 14596:20180418:155836.945 In DCconfig_get_poller_nextcheck() poller_type:0 14596:20180418:155836.945 End of DCconfig_get_poller_nextcheck():-1 14596:20180418:155836.945 poller #6 [got 0 values in 0.000108 sec, idle 5 sec] 14608:20180418:155836.949 poller #18 [got 0 values in 0.000283 sec, getting values] 14608:20180418:155836.949 In get_values() 14608:20180418:155836.949 In DCconfig_get_poller_items() poller_type:0 14608:20180418:155836.949 End of DCconfig_get_poller_items():0 14608:20180418:155836.949 End of get_values():0 14608:20180418:155836.949 In DCconfig_get_poller_nextcheck() poller_type:0 14608:20180418:155836.949 End of DCconfig_get_poller_nextcheck():-1 14608:20180418:155836.949 poller #18 [got 0 values in 0.000118 sec, idle 5 sec] 14609:20180418:155836.956 poller #19 [got 0 values in 0.000263 sec, getting values] 14609:20180418:155836.956 In get_values() 14609:20180418:155836.956 In DCconfig_get_poller_items() poller_type:0 14609:20180418:155836.956 End of DCconfig_get_poller_items():0 14609:20180418:155836.956 End of get_values():0 14609:20180418:155836.956 In DCconfig_get_poller_nextcheck() poller_type:0 14609:20180418:155836.956 End of DCconfig_get_poller_nextcheck():-1 14609:20180418:155836.956 poller #19 [got 0 values in 0.000112 sec, idle 5 sec] 14600:20180418:155836.962 poller #10 [got 0 values in 0.000105 sec, getting values] 14600:20180418:155836.962 In get_values() 14600:20180418:155836.962 In DCconfig_get_poller_items() poller_type:0 14600:20180418:155836.962 End of DCconfig_get_poller_items():0 14600:20180418:155836.962 End of get_values():0 14600:20180418:155836.962 In DCconfig_get_poller_nextcheck() poller_type:0 14600:20180418:155836.962 End of DCconfig_get_poller_nextcheck():-1 14600:20180418:155836.962 poller #10 [got 0 values in 0.000111 sec, idle 5 sec] 14606:20180418:155836.964 poller #16 [got 0 values in 0.000113 sec, getting values] 14606:20180418:155836.964 In get_values() 14606:20180418:155836.964 In DCconfig_get_poller_items() poller_type:0 14606:20180418:155836.964 End of DCconfig_get_poller_items():0 14606:20180418:155836.964 End of get_values():0 14606:20180418:155836.964 In DCconfig_get_poller_nextcheck() poller_type:0 14606:20180418:155836.964 End of DCconfig_get_poller_nextcheck():-1 14606:20180418:155836.964 poller #16 [got 0 values in 0.000145 sec, idle 5 sec] 14593:20180418:155836.966 poller #3 [got 0 values in 0.000262 sec, getting values] 14593:20180418:155836.966 In get_values() 14593:20180418:155836.966 In DCconfig_get_poller_items() poller_type:0 14593:20180418:155836.966 End of DCconfig_get_poller_items():0 14593:20180418:155836.966 End of get_values():0 14593:20180418:155836.966 In DCconfig_get_poller_nextcheck() poller_type:0 14593:20180418:155836.966 End of DCconfig_get_poller_nextcheck():-1 14593:20180418:155836.966 poller #3 [got 0 values in 0.000109 sec, idle 5 sec] 14601:20180418:155836.967 poller #11 [got 0 values in 0.000120 sec, getting values] 14601:20180418:155836.967 In get_values() 14601:20180418:155836.967 In DCconfig_get_poller_items() poller_type:0 14601:20180418:155836.967 End of DCconfig_get_poller_items():0 14601:20180418:155836.967 End of get_values():0 14601:20180418:155836.967 In DCconfig_get_poller_nextcheck() poller_type:0 14601:20180418:155836.967 End of DCconfig_get_poller_nextcheck():-1 14601:20180418:155836.967 poller #11 [got 0 values in 0.000112 sec, idle 5 sec] 14598:20180418:155836.975 poller #8 [got 0 values in 0.000288 sec, getting values] 14598:20180418:155836.975 In get_values() 14598:20180418:155836.975 In DCconfig_get_poller_items() poller_type:0 14598:20180418:155836.975 End of DCconfig_get_poller_items():0 14598:20180418:155836.975 End of get_values():0 14598:20180418:155836.975 In DCconfig_get_poller_nextcheck() poller_type:0 14598:20180418:155836.975 End of DCconfig_get_poller_nextcheck():-1 14598:20180418:155836.975 poller #8 [got 0 values in 0.000248 sec, idle 5 sec] 14594:20180418:155836.984 poller #4 [got 0 values in 0.000263 sec, getting values] 14594:20180418:155836.984 In get_values() 14594:20180418:155836.984 In DCconfig_get_poller_items() poller_type:0 14594:20180418:155836.984 End of DCconfig_get_poller_items():0 14594:20180418:155836.984 End of get_values():0 14594:20180418:155836.984 In DCconfig_get_poller_nextcheck() poller_type:0 14594:20180418:155836.984 End of DCconfig_get_poller_nextcheck():-1 14594:20180418:155836.984 poller #4 [got 0 values in 0.000109 sec, idle 5 sec] 14645:20180418:155837.003 history syncer #9 [synced 0 items in 0.000074 sec, syncing history] 14645:20180418:155837.003 In DCsync_history() history_first:371309 history_num:0 14645:20180418:155837.003 history syncer #9 [synced 0 items in 0.000036 sec, idle 5 sec] 14654:20180418:155837.032 self-monitoring [processing data] 14654:20180418:155837.032 In collect_selfmon_stats() 14654:20180418:155837.032 End of collect_selfmon_stats() 14654:20180418:155837.032 self-monitoring [processed data in 0.000070 sec, idle 1 sec] 14647:20180418:155837.071 escalator [processed 0 escalations in 0.004817 sec, processing escalations] 14647:20180418:155837.071 In process_escalations() 14647:20180418:155837.071 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid from escalations order by actionid,triggerid,itemid,escalationid] 14647:20180418:155837.071 End of process_escalations() 14647:20180418:155837.071 escalator [processed 0 escalations in 0.000539 sec, idle 3 sec] 14637:20180418:155837.899 history syncer #1 [synced 0 items in 0.000036 sec, syncing history] 14637:20180418:155837.899 In DCsync_history() history_first:371309 history_num:0 14637:20180418:155837.899 history syncer #1 [synced 0 items in 0.000081 sec, idle 5 sec] 14639:20180418:155837.900 history syncer #3 [synced 0 items in 0.000112 sec, syncing history] 14639:20180418:155837.900 In DCsync_history() history_first:371309 history_num:0 14639:20180418:155837.900 history syncer #3 [synced 0 items in 0.000036 sec, idle 5 sec] 14644:20180418:155837.900 history syncer #8 [synced 0 items in 0.000149 sec, syncing history] 14644:20180418:155837.900 In DCsync_history() history_first:371309 history_num:0 14644:20180418:155837.900 history syncer #8 [synced 0 items in 0.000031 sec, idle 5 sec] 14638:20180418:155837.900 history syncer #2 [synced 0 items in 0.000084 sec, syncing history] 14638:20180418:155837.900 In DCsync_history() history_first:371309 history_num:0 14638:20180418:155837.900 history syncer #2 [synced 0 items in 0.000030 sec, idle 5 sec] 14642:20180418:155837.900 history syncer #6 [synced 0 items in 0.000067 sec, syncing history] 14642:20180418:155837.901 In DCsync_history() history_first:371309 history_num:0 14642:20180418:155837.901 history syncer #6 [synced 0 items in 0.000031 sec, idle 5 sec] 14643:20180418:155837.901 history syncer #7 [synced 0 items in 0.000086 sec, syncing history] 14643:20180418:155837.901 In DCsync_history() history_first:371309 history_num:0 14643:20180418:155837.901 history syncer #7 [synced 0 items in 0.000030 sec, idle 5 sec] 14640:20180418:155837.911 history syncer #4 [synced 0 items in 0.000080 sec, syncing history] 14640:20180418:155837.911 In DCsync_history() history_first:371309 history_num:0 14640:20180418:155837.911 history syncer #4 [synced 0 items in 0.000035 sec, idle 5 sec] 14646:20180418:155837.911 history syncer #10 [synced 0 items in 0.000066 sec, syncing history] 14646:20180418:155837.911 In DCsync_history() history_first:371309 history_num:0 14646:20180418:155837.911 history syncer #10 [synced 0 items in 0.000027 sec, idle 5 sec] 14604:20180418:155837.913 poller #14 [got 0 values in 0.000112 sec, getting values] 14604:20180418:155837.913 In get_values() 14604:20180418:155837.913 In DCconfig_get_poller_items() poller_type:0 14604:20180418:155837.913 End of DCconfig_get_poller_items():0 14604:20180418:155837.913 End of get_values():0 14604:20180418:155837.913 In DCconfig_get_poller_nextcheck() poller_type:0 14604:20180418:155837.913 End of DCconfig_get_poller_nextcheck():-1 14604:20180418:155837.913 poller #14 [got 0 values in 0.000110 sec, idle 5 sec] 14614:20180418:155837.926 unreachable poller #4 [got 0 values in 0.000121 sec, getting values] 14614:20180418:155837.926 In get_values() 14614:20180418:155837.926 In DCconfig_get_poller_items() poller_type:1 14614:20180418:155837.926 End of DCconfig_get_poller_items():0 14614:20180418:155837.926 End of get_values():0 14614:20180418:155837.926 In DCconfig_get_poller_nextcheck() poller_type:1 14614:20180418:155837.926 End of DCconfig_get_poller_nextcheck():-1 14614:20180418:155837.926 unreachable poller #4 [got 0 values in 0.000124 sec, idle 5 sec] 14615:20180418:155837.943 unreachable poller #5 [got 0 values in 0.000175 sec, getting values] 14615:20180418:155837.943 In get_values() 14615:20180418:155837.943 In DCconfig_get_poller_items() poller_type:1 14615:20180418:155837.943 End of DCconfig_get_poller_items():0 14615:20180418:155837.943 End of get_values():0 14615:20180418:155837.943 In DCconfig_get_poller_nextcheck() poller_type:1 14615:20180418:155837.943 End of DCconfig_get_poller_nextcheck():-1 14615:20180418:155837.943 unreachable poller #5 [got 0 values in 0.000170 sec, idle 5 sec] 14626:20180418:155837.958 alerter [sending alerts] 14626:20180418:155837.958 query [txnlev:0] [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.message,a.status,mt.mediatypeid,mt.type,mt.description,mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_path,mt.gsm_modem,mt.username,mt.passwd,a.retries from alerts a,media_type mt where a.mediatypeid=mt.mediatypeid and a.status=0 and a.alerttype=0 order by a.alertid] 14612:20180418:155837.959 unreachable poller #2 [got 0 values in 0.000130 sec, getting values] 14612:20180418:155837.959 In get_values() 14612:20180418:155837.959 In DCconfig_get_poller_items() poller_type:1 14626:20180418:155837.959 alerter [sent alerts: 0 success, 0 fail in 0.000907 sec, idle 30 sec] 14612:20180418:155837.959 End of DCconfig_get_poller_items():0 14612:20180418:155837.960 End of get_values():0 14612:20180418:155837.960 In DCconfig_get_poller_nextcheck() poller_type:1 14612:20180418:155837.960 End of DCconfig_get_poller_nextcheck():-1 14612:20180418:155837.960 unreachable poller #2 [got 0 values in 0.000444 sec, idle 5 sec] 14613:20180418:155837.979 unreachable poller #3 [got 0 values in 0.000129 sec, getting values] 14613:20180418:155837.979 In get_values() 14613:20180418:155837.979 In DCconfig_get_poller_items() poller_type:1 14613:20180418:155837.979 End of DCconfig_get_poller_items():0 14613:20180418:155837.979 End of get_values():0 14613:20180418:155837.979 In DCconfig_get_poller_nextcheck() poller_type:1 14613:20180418:155837.979 End of DCconfig_get_poller_nextcheck():-1 14613:20180418:155837.980 unreachable poller #3 [got 0 values in 0.000259 sec, idle 5 sec] 14611:20180418:155837.985 unreachable poller #1 [got 0 values in 0.000122 sec, getting values] 14611:20180418:155837.985 In get_values() 14611:20180418:155837.985 In DCconfig_get_poller_items() poller_type:1 14611:20180418:155837.985 End of DCconfig_get_poller_items():0 14611:20180418:155837.985 End of get_values():0 14611:20180418:155837.985 In DCconfig_get_poller_nextcheck() poller_type:1 14611:20180418:155837.985 End of DCconfig_get_poller_nextcheck():-1 14611:20180418:155837.986 unreachable poller #1 [got 0 values in 0.000298 sec, idle 5 sec] 14641:20180418:155838.001 history syncer #5 [synced 0 items in 0.000075 sec, syncing history] 14641:20180418:155838.001 In DCsync_history() history_first:371309 history_num:0 14641:20180418:155838.001 history syncer #5 [synced 0 items in 0.000036 sec, idle 5 sec] 14654:20180418:155838.032 self-monitoring [processing data] 14654:20180418:155838.033 In collect_selfmon_stats() 14654:20180418:155838.033 End of collect_selfmon_stats() 14654:20180418:155838.033 self-monitoring [processed data in 0.000069 sec, idle 1 sec] 14623:20180418:155838.900 icmp pinger #3 [getting values] 14623:20180418:155838.900 In get_pinger_hosts() 14623:20180418:155838.901 In DCconfig_get_poller_items() poller_type:3 14623:20180418:155838.901 End of DCconfig_get_poller_items():0 14623:20180418:155838.901 End of get_pinger_hosts():0 14623:20180418:155838.901 In process_pinger_hosts() 14623:20180418:155838.901 End of process_pinger_hosts() 14623:20180418:155838.901 In DCconfig_get_poller_nextcheck() poller_type:3 14623:20180418:155838.901 End of DCconfig_get_poller_nextcheck():-1 14623:20180418:155838.901 icmp pinger #3 [got 0 values in 0.000342 sec, idle 5 sec] 14655:20180418:155838.943 vmware collector #1 [updated 0, removed 0 VMware services in 0.000004 sec, querying VMware services] 14655:20180418:155838.943 vmware collector #1 [updated 0, removed 0 VMware services in 0.000004 sec, idle 5 sec] 14651:20180418:155838.979 java poller #4 [got 0 values in 0.000159 sec, getting values] 14651:20180418:155838.979 In get_values() 14651:20180418:155838.979 In DCconfig_get_poller_items() poller_type:4 14651:20180418:155838.979 End of DCconfig_get_poller_items():0 14651:20180418:155838.979 End of get_values():0 14651:20180418:155838.979 In DCconfig_get_poller_nextcheck() poller_type:4 14651:20180418:155838.979 End of DCconfig_get_poller_nextcheck():-1 14651:20180418:155838.979 java poller #4 [got 0 values in 0.000136 sec, idle 5 sec] 14649:20180418:155839.002 java poller #2 [got 0 values in 0.000115 sec, getting values] 14649:20180418:155839.002 In get_values() 14649:20180418:155839.002 In DCconfig_get_poller_items() poller_type:4 14649:20180418:155839.002 End of DCconfig_get_poller_items():0 14649:20180418:155839.002 End of get_values():0 14649:20180418:155839.003 In DCconfig_get_poller_nextcheck() poller_type:4 14649:20180418:155839.003 End of DCconfig_get_poller_nextcheck():-1 14649:20180418:155839.003 java poller #2 [got 0 values in 0.000285 sec, idle 5 sec] 14654:20180418:155839.033 self-monitoring [processing data] 14654:20180418:155839.033 In collect_selfmon_stats() 14654:20180418:155839.033 End of collect_selfmon_stats() 14654:20180418:155839.033 self-monitoring [processed data in 0.000151 sec, idle 1 sec]