15861:20130626:105814.465 Trapper got [] len 0 15853:20130626:105814.575 In get_values() 15853:20130626:105814.575 In DCconfig_get_poller_items() poller_type:0 15853:20130626:105814.575 End of DCconfig_get_poller_items():0 15853:20130626:105814.575 End of get_values():0 15853:20130626:105814.575 poller #3 spent 0.000192 seconds while updating 0 values 15853:20130626:105814.575 In DCconfig_get_poller_nextcheck() poller_type:0 15853:20130626:105814.575 End of DCconfig_get_poller_nextcheck():1372233495 15853:20130626:105814.575 sleeping for 1 seconds 15874:20130626:105814.643 In collect_selfmon_stats() 15874:20130626:105814.643 End of collect_selfmon_stats() 15874:20130626:105814.643 sleeping for 1 seconds 15872:20130626:105814.651 In process_escalations() 15872:20130626:105814.651 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status,nextcheck from escalations where 1=1 and escalationid between 0 and 99999999999999 order by actionid,triggerid,escalationid] 15872:20130626:105814.651 End of process_escalations() 15872:20130626:105814.651 escalator #1 spent 0.000419 seconds while processing escalations 15872:20130626:105814.651 sleeping for 3 seconds 15855:20130626:105814.656 In get_values() 15855:20130626:105814.656 In DCconfig_get_poller_items() poller_type:0 15855:20130626:105814.656 End of DCconfig_get_poller_items():0 15855:20130626:105814.656 End of get_values():0 15855:20130626:105814.656 poller #5 spent 0.000185 seconds while updating 0 values 15855:20130626:105814.656 In DCconfig_get_poller_nextcheck() poller_type:0 15855:20130626:105814.656 End of DCconfig_get_poller_nextcheck():1372233495 15855:20130626:105814.656 sleeping for 1 seconds 15852:20130626:105814.662 In get_values() 15852:20130626:105814.662 In DCconfig_get_poller_items() poller_type:0 15852:20130626:105814.662 End of DCconfig_get_poller_items():0 15852:20130626:105814.662 End of get_values():0 15852:20130626:105814.662 poller #2 spent 0.000206 seconds while updating 0 values 15852:20130626:105814.662 In DCconfig_get_poller_nextcheck() poller_type:0 15852:20130626:105814.662 End of DCconfig_get_poller_nextcheck():1372233495 15852:20130626:105814.662 sleeping for 1 seconds 15861:20130626:105815.070 Trapper got [{ "request":"active checks", "host":"it0proxy"}] len 49 15861:20130626:105815.070 In send_list_of_active_checks_json() 15861:20130626:105815.070 In get_hostid_by_host() host:'it0proxy' 15861:20130626:105815.070 query [txnlev:0] [select hostid,status from hosts where host='it0proxy' and status in (0,1) and proxy_hostid is null and hostid between 0 and 99999999999999] 15861:20130626:105815.071 query [txnlev:1] [begin;] 15861:20130626:105815.071 query [txnlev:1] [select autoreg_hostid from autoreg_host where proxy_hostid is null and host='it0proxy' and autoreg_hostid between 0 and 99999999999999] 15861:20130626:105815.071 In DCget_nextid() table:'autoreg_host' num:1 15861:20130626:105815.072 query [txnlev:1] [select max(autoreg_hostid) from autoreg_host where autoreg_hostid between 0 and 99999999999] 15861:20130626:105815.072 End of DCget_nextid() table:'autoreg_host' [3:3] 15861:20130626:105815.072 query [txnlev:1] [insert into autoreg_host (autoreg_hostid,proxy_hostid,host,listen_ip,listen_dns,listen_port) values (3,null,'it0proxy','127.0.0.1','localhost',10050)] 15861:20130626:105815.072 In process_event() eventid:0 object:3 objectid:3 value:1 value_changed:0 15861:20130626:105815.073 In add_trigger_info() 15861:20130626:105815.073 End of add_trigger_info():SUCCEED 15861:20130626:105815.073 In DBget_nextid() tablename:'events' 15861:20130626:105815.073 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid'] 15861:20130626:105815.073 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'] 15861:20130626:105815.073 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid'] 15861:20130626:105815.074 End of DBget_nextid():141355 table:'events' recid:'eventid' 15861:20130626:105815.074 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (141355,2,3,3,1372233495,0,1,0)] 15861:20130626:105815.075 In process_actions() eventid:141355 15861:20130626:105815.075 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=2 and actionid between 0 and 99999999999999] 15861:20130626:105815.075 In check_action_conditions() actionid:5 15861:20130626:105815.075 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=5 order by conditiontype] 15861:20130626:105815.076 In check_action_condition() actionid:5 conditionid:13 cond.value:'it' 15861:20130626:105815.076 In check_auto_registration_condition() 15861:20130626:105815.076 query [txnlev:1] [select host from autoreg_host where autoreg_hostid=3] 15861:20130626:105815.076 End of check_auto_registration_condition():SUCCEED 15861:20130626:105815.076 End of check_action_condition():SUCCEED 15861:20130626:105815.076 End of check_action_conditions():SUCCEED 15861:20130626:105815.076 In DBstart_escalation() 15861:20130626:105815.076 In DCget_nextid() table:'escalations' num:1 15861:20130626:105815.076 query [txnlev:1] [select max(escalationid) from escalations where escalationid between 0 and 99999999999999] 15861:20130626:105815.077 End of DCget_nextid() table:'escalations' [1:1] 15861:20130626:105815.077 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (1,5,null,141355,0)] 15861:20130626:105815.077 End of DBstart_escalation() 15861:20130626:105815.077 In execute_operations() actionid:5 15861:20130626:105815.077 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=5] 15861:20130626:105815.078 In op_host_add() 15861:20130626:105815.078 In add_discovered_host() eventid:141355 15861:20130626:105815.078 query [txnlev:1] [select proxy_hostid,host,listen_ip,listen_dns,listen_port from autoreg_host where autoreg_hostid=3] 15861:20130626:105815.078 query [txnlev:1] [select hostid,proxy_hostid from hosts where host='it0proxy' and hostid between 0 and 99999999999999 order by hostid limit 1] 15861:20130626:105815.078 In DBadd_interface() 15861:20130626:105815.078 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10134 and type=1] 15861:20130626:105815.079 In DBget_nextid() tablename:'interface' 15861:20130626:105815.079 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid'] 15861:20130626:105815.079 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='interface' and field_name='interfaceid'] 15861:20130626:105815.079 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid'] 15861:20130626:105815.080 End of DBget_nextid():45 table:'interface' recid:'interfaceid' 15861:20130626:105815.080 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (45,10134,1,1,1,'127.0.0.1','localhost',10050)] 15861:20130626:105815.080 End of DBadd_interface():45 15861:20130626:105815.080 End of add_discovered_host() 15861:20130626:105815.080 End of op_host_add() 15861:20130626:105815.080 In op_template_add() 15861:20130626:105815.080 In add_discovered_host() eventid:141355 15861:20130626:105815.080 query [txnlev:1] [select proxy_hostid,host,listen_ip,listen_dns,listen_port from autoreg_host where autoreg_hostid=3] 15861:20130626:105815.081 query [txnlev:1] [select hostid,proxy_hostid from hosts where host='it0proxy' and hostid between 0 and 99999999999999 order by hostid limit 1] 15861:20130626:105815.081 In DBadd_interface() 15861:20130626:105815.081 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10134 and type=1] 15861:20130626:105815.081 In substitute_simple_macros() data:'10050' 15861:20130626:105815.082 End of DBadd_interface():45 15861:20130626:105815.082 End of add_discovered_host() 15861:20130626:105815.082 In DBcopy_template_elements() 15861:20130626:105815.082 query [txnlev:1] [select templateid from hosts_templates where hostid=10134] 15861:20130626:105815.082 In validate_linked_templates() 15861:20130626:105815.082 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=10050 and not i2.hostid=10050 limit 1] 15861:20130626:105815.083 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=10050 and not i2.hostid=10050 and h2.status=3 limit 1] 15861:20130626:105815.084 End of validate_linked_templates():SUCCEED 15861:20130626:105815.084 In validate_host() 15861:20130626:105815.084 In validate_inventory_links() 15861:20130626:105815.084 query [txnlev:1] [select inventory_link,count(*) from items where inventory_link<>0 and hostid=10050 group by inventory_link having count(*)>1 limit 1] 15861:20130626:105815.084 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=10050 and i.hostid=10134 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10050 and items.key_=i.key_) limit 1] 15861:20130626:105815.085 End of validate_inventory_links():SUCCEED 15861:20130626:105815.085 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=10050] 15861:20130626:105815.085 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10134 and t.hostid=10050 limit 1] 15861:20130626:105815.086 query [txnlev:1] [select type,interfaceid from interface where hostid=10134 and type in (1,2,3,4) and main=1 and interfaceid between 0 and 99999999999999] 15861:20130626:105815.086 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,11,15) and hostid=10050] 15861:20130626:105815.086 In validate_host():SUCCEED 15861:20130626:105815.086 In DBget_nextid() tablename:'hosts_templates' 15861:20130626:105815.086 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid'] 15861:20130626:105815.087 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid'] 15861:20130626:105815.087 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid'] 15861:20130626:105815.087 End of DBget_nextid():52 table:'hosts_templates' recid:'hosttemplateid' 15861:20130626:105815.088 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (52,10134,10050)] 15861:20130626:105815.088 In DBcopy_template_applications() 15861:20130626:105815.088 query [txnlev:1] [select ta.applicationid,ta.name,ha.applicationid from applications ta left join applications ha on ha.name=ta.name and ha.hostid=10134 where ta.hostid=10050 order by ha.applicationid] 15861:20130626:105815.088 In DBget_nextid() tablename:'applications' 15861:20130626:105815.089 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid'] 15861:20130626:105815.089 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='applications' and field_name='applicationid'] 15861:20130626:105815.089 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid'] 15861:20130626:105815.089 End of DBget_nextid():401 table:'applications' recid:'applicationid' 15861:20130626:105815.090 query [txnlev:1] [insert into applications (applicationid,hostid,name,templateid) values (401,10134,'Zabbix agent',206); ] 15861:20130626:105815.090 End of DBcopy_template_applications() 15861:20130626:105815.090 In DBcopy_template_items() 15861:20130626:105815.090 query [txnlev:1] [select type,interfaceid from interface where hostid=10134 and type in (1,2,3,4) and main=1] 15861:20130626:105815.090 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_authpassphrase,ti.snmpv3_privpassphrase,ti.authtype,ti.username,ti.password,ti.publickey,ti.privatekey,ti.flags,ti.filter,ti.description,ti.inventory_link,ti.lifetime,hi.itemid from items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10134 where ti.hostid=10050 order by hi.itemid] 15861:20130626:105815.091 In DBget_nextid() tablename:'items' 15861:20130626:105815.091 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid'] 15861:20130626:105815.092 query [txnlev:1] [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid'] 15861:20130626:105815.092 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid'] 15861:20130626:105815.092 End of DBget_nextid():23756 table:'items' recid:'itemid' 15861:20130626:105815.092 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_authpassphrase,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,templateid,flags,filter,description,inventory_link,interfaceid,lifetime) values (23756,'Host name of zabbix_agentd running','agent.hostname',10134,0,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',23318,0,'','',0,45,'30'),(23757,'Agent ping','agent.ping',10134,0,3,0,60,'',7,365,0,'','',0,0,'1','',10,'','','','','',0,'','',0,'','','','',22232,0,'','The agent always returns 1 for this item. It could be used in combination with nodata() for availability check.',0,45,'0'),(23758,'Version of zabbix_agent(d) running','agent.version',10134,0,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',22231,0,'','',0,45,'0'); ] 15861:20130626:105815.093 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid in (23756,23757,23758) join applications ha on ha.templateid=tia.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] 15861:20130626:105815.093 In DBget_nextid() tablename:'items_applications' 15861:20130626:105815.093 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid'] 15861:20130626:105815.093 query [txnlev:1] [update ids set nextid=nextid+3 where nodeid=0 and table_name='items_applications' and field_name='itemappid'] 15861:20130626:105815.093 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid'] 15861:20130626:105815.093 End of DBget_nextid():5878 table:'items_applications' recid:'itemappid' 15861:20130626:105815.094 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (5878,23756,401),(5879,23757,401),(5880,23758,401); ] 15861:20130626:105815.094 End of DBcopy_template_items() 15861:20130626:105815.094 In DBcopy_template_triggers() 15861:20130626:105815.094 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=10050] 15861:20130626:105815.094 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=10134 and t.description='Host name of zabbix_agentd was changed on {HOST.NAME}'] 15861:20130626:105815.094 In DBget_nextid() tablename:'triggers' 15861:20130626:105815.094 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.095 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.095 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.095 End of DBget_nextid():13592 table:'triggers' recid:'triggerid' 15861:20130626:105815.095 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=10134 where tf.itemid=ti.itemid and tf.triggerid=13507] 15861:20130626:105815.095 In DBget_nextid() tablename:'functions' 15861:20130626:105815.095 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.096 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.096 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.096 End of DBget_nextid():13048 table:'functions' recid:'functionid' 15861:20130626:105815.096 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (13592,'Host name of zabbix_agentd was changed on {HOST.NAME}',1,0,'','',0,0,1,13507,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (13048,23756,13592,'diff','0'); update triggers set expression='{13048}>0' where triggerid=13592; ] 15861:20130626:105815.096 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=10134 and t.description='Zabbix agent on {HOST.NAME} is unreachable for 5 minutes'] 15861:20130626:105815.097 In DBget_nextid() tablename:'triggers' 15861:20130626:105815.097 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.097 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.097 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.097 End of DBget_nextid():13593 table:'triggers' recid:'triggerid' 15861:20130626:105815.097 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=10134 where tf.itemid=ti.itemid and tf.triggerid=13025] 15861:20130626:105815.097 In DBget_nextid() tablename:'functions' 15861:20130626:105815.097 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.098 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.098 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.098 End of DBget_nextid():13049 table:'functions' recid:'functionid' 15861:20130626:105815.098 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (13593,'Zabbix agent on {HOST.NAME} is unreachable for 5 minutes',3,0,'','',0,0,1,13025,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (13049,23757,13593,'nodata','5m'); update triggers set expression='{13049}=1' where triggerid=13593; ] 15861:20130626:105815.098 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=10134 and t.description='Version of zabbix_agent(d) was changed on {HOST.NAME}'] 15861:20130626:105815.099 In DBget_nextid() tablename:'triggers' 15861:20130626:105815.099 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.099 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.099 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 15861:20130626:105815.099 End of DBget_nextid():13594 table:'triggers' recid:'triggerid' 15861:20130626:105815.099 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=10134 where tf.itemid=ti.itemid and tf.triggerid=13026] 15861:20130626:105815.100 In DBget_nextid() tablename:'functions' 15861:20130626:105815.100 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.100 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.100 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 15861:20130626:105815.101 End of DBget_nextid():13050 table:'functions' recid:'functionid' 15861:20130626:105815.101 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (13594,'Version of zabbix_agent(d) was changed on {HOST.NAME}',1,0,'','',0,0,1,13026,0); insert into functions (functionid,itemid,triggerid,function,parameter) values (13050,23758,13594,'diff','0'); update triggers set expression='{13050}>0' where triggerid=13594; ] 15861:20130626:105815.101 query [txnlev:1] [select triggerid,templateid from triggers where triggerid in (13592,13593,13594)] 15861:20130626:105815.101 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 in (13592,13593,13594)] 15861:20130626:105815.102 End of DBcopy_template_triggers():SUCCEED 15861:20130626:105815.102 In DBcopy_template_graphs() 15861:20130626:105815.102 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=10050] 15861:20130626:105815.102 End of DBcopy_template_graphs():SUCCEED 15861:20130626:105815.102 End of DBcopy_template_elements():SUCCEED 15861:20130626:105815.102 End of op_template_add() 15861:20130626:105815.102 In op_groups_add() 15861:20130626:105815.102 In add_discovered_host() eventid:141355 15861:20130626:105815.102 query [txnlev:1] [select proxy_hostid,host,listen_ip,listen_dns,listen_port from autoreg_host where autoreg_hostid=3] 15861:20130626:105815.102 query [txnlev:1] [select hostid,proxy_hostid from hosts where host='it0proxy' and hostid between 0 and 99999999999999 order by hostid limit 1] 15861:20130626:105815.103 In DBadd_interface() 15861:20130626:105815.103 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10134 and type=1] 15861:20130626:105815.103 In substitute_simple_macros() data:'10050' 15861:20130626:105815.103 End of DBadd_interface():45 15861:20130626:105815.103 End of add_discovered_host() 15861:20130626:105815.103 In add_discovered_host_groups() 15861:20130626:105815.103 query [txnlev:1] [select groupid from hosts_groups where hostid=10134 and groupid=4] 15861:20130626:105815.104 In DBget_nextid() tablename:'hosts_groups' 15861:20130626:105815.104 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid'] 15861:20130626:105815.104 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid'] 15861:20130626:105815.105 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid'] 15861:20130626:105815.105 End of DBget_nextid():160 table:'hosts_groups' recid:'hostgroupid' 15861:20130626:105815.105 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (160,10134,4); ] 15861:20130626:105815.105 End of add_discovered_host_groups() 15861:20130626:105815.105 End of op_groups_add() 15861:20130626:105815.105 End of execute_operations() 15861:20130626:105815.105 End of process_actions() 15861:20130626:105815.105 End of process_event():SUCCEED 15861:20130626:105815.105 query [txnlev:1] [commit;] 15861:20130626:105815.206 End of get_hostid_by_host():FAIL 15861:20130626:105815.206 cannot send list of active checks to [127.0.0.1]: host [it0proxy] not found 15861:20130626:105815.206 send_list_of_active_checks_json() sending [{ "response":"failed", "info":"host [it0proxy] not found"}] 15861:20130626:105815.206 End of send_list_of_active_checks_json():SUCCEED