16783:20130626:120254.327 server #19 started [discoverer #1]
 16783:20130626:120254.327 In main_discoverer_loop() process_num:1
 16783:20130626:120254.327 In DBconnect() flag:0
 16783:20130626:120254.328 query [txnlev:0] [set names utf8]
 16783:20130626:120254.328 End of DBconnect():0
 16783:20130626:120254.328 query [txnlev:0] [select distinct r.druleid,r.iprange,r.name,c.dcheckid from drules r left join dchecks c on c.druleid=r.druleid and uniq=1 where r.proxy_hostid is null and r.status=0 and (r.nextcheck<=1372237374 or r.nextcheck>1372237374+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999]
 16783:20130626:120254.329 In process_rule() rule:'For proxy linking' range:'10.20.0.32'
 16783:20130626:120254.329 process_rule() '10.20.0.32'
 16783:20130626:120254.329 process_rule() IPv4 Range:'10.20.0.32' - '10.20.0.32'
 16783:20130626:120254.329 process_rule() IP:'10.20.0.32'
 16783:20130626:120254.432 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 and dcheckid=9 order by dcheckid]
 16783:20130626:120254.432 In process_check()
 16783:20130626:120254.432 process_check() port:10050
 16783:20130626:120254.432 In discover_service()
 16783:20130626:120254.432 In get_value_agent() host:'' addr:'10.20.0.32' key:'agent.hostname'
 16783:20130626:120254.432 Sending [agent.hostname
]
 16783:20130626:120254.433 get value from agent result: 'it0.local'
 16783:20130626:120254.433 End of discover_service():SUCCEED
 16783:20130626:120254.433 query [txnlev:1] [begin;]
 16783:20130626:120254.433 In discovery_update_service() ip:'10.20.0.32' port:10050 status:0
 16783:20130626:120254.433 In discovery_register_host() ip:'10.20.0.32' status:0 value:'it0.local'
 16783:20130626:120254.433 query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and ds.dcheckid=9 and ds.value='it0.local' order by dh.dhostid]
 16783:20130626:120254.434 query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and dh.druleid=7 and ds.ip='10.20.0.32' order by dh.dhostid]
 16783:20130626:120254.434 new host discovered at 10.20.0.32
 16783:20130626:120254.434 In DCget_nextid() table:'dhosts' num:1
 16783:20130626:120254.434 query [txnlev:1] [select max(dhostid) from dhosts where dhostid between 0 and 99999999999]
 16783:20130626:120254.435 End of DCget_nextid() table:'dhosts' [10:10]
 16783:20130626:120254.435 query [txnlev:1] [insert into dhosts (dhostid,druleid) values (10,7)]
 16783:20130626:120254.435 End of discovery_register_host()
 16783:20130626:120254.435 In discovery_register_service() ip:'10.20.0.32' port:10050 key:'agent.hostname'
 16783:20130626:120254.435 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=9 and type=9 and key_='agent.hostname' and ip='10.20.0.32' and port=10050]
 16783:20130626:120254.436 new service discovered on port 10050
 16783:20130626:120254.436 In DCget_nextid() table:'dservices' num:1
 16783:20130626:120254.436 query [txnlev:1] [select max(dserviceid) from dservices where dserviceid between 0 and 99999999999]
 16783:20130626:120254.436 End of DCget_nextid() table:'dservices' [1:1]
 16783:20130626:120254.436 query [txnlev:1] [insert into dservices (dserviceid,dhostid,dcheckid,type,key_,ip,dns,port,status) values (1,10,9,9,'agent.hostname','10.20.0.32','it0.local',10050,1)]
 16783:20130626:120254.437 End of discovery_register_service()
 16783:20130626:120254.437 query [txnlev:1] [update dservices set status=0,lastup=1372237374,lastdown=0,value='it0.local' where dserviceid=1]
 16783:20130626:120254.437 In process_event() eventid:0 object:2 objectid:1 value:2 value_changed:0
 16783:20130626:120254.437 In add_trigger_info()
 16783:20130626:120254.437 End of add_trigger_info():SUCCEED
 16783:20130626:120254.437 In DBget_nextid() tablename:'events'
 16783:20130626:120254.438 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.438 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.438 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.439 End of DBget_nextid():141521 table:'events' recid:'eventid'
 16783:20130626:120254.439 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (141521,1,2,1,1372237374,0,2,0)]
 16783:20130626:120254.439 In process_actions() eventid:141521
 16783:20130626:120254.439 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 16783:20130626:120254.439 In check_action_conditions() actionid:7
 16783:20130626:120254.439 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=7 order by conditiontype]
 16783:20130626:120254.440 In check_action_condition() actionid:7 conditionid:12 cond.value:'9'
 16783:20130626:120254.440 In check_discovery_condition()
 16783:20130626:120254.440 query [txnlev:1] [select type from dservices where dserviceid=1]
 16783:20130626:120254.440 End of check_discovery_condition():SUCCEED
 16783:20130626:120254.440 End of check_action_condition():SUCCEED
 16783:20130626:120254.440 In check_action_condition() actionid:7 conditionid:11 cond.value:'1'
 16783:20130626:120254.440 In check_discovery_condition()
 16783:20130626:120254.440 End of check_discovery_condition():FAIL
 16783:20130626:120254.440 End of check_action_condition():FAIL
 16783:20130626:120254.440 End of check_action_conditions():FAIL
 16783:20130626:120254.440 In check_action_conditions() actionid:8
 16783:20130626:120254.440 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=8 order by conditiontype]
 16783:20130626:120254.440 In check_action_condition() actionid:8 conditionid:17 cond.value:'7'
 16783:20130626:120254.441 In check_discovery_condition()
 16783:20130626:120254.441 query [txnlev:1] [select h.druleid from dhosts h,dservices s where h.dhostid=s.dhostid and h.druleid=7 and s.dserviceid=1]
 16783:20130626:120254.441 End of check_discovery_condition():SUCCEED
 16783:20130626:120254.441 End of check_action_condition():SUCCEED
 16783:20130626:120254.441 End of check_action_conditions():SUCCEED
 16783:20130626:120254.441 In DBstart_escalation()
 16783:20130626:120254.441 In DCget_nextid() table:'escalations' num:1
 16783:20130626:120254.441 query [txnlev:1] [select max(escalationid) from escalations where escalationid between 0 and 99999999999999]
 16783:20130626:120254.441 End of DCget_nextid() table:'escalations' [1:1]
 16783:20130626:120254.441 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (1,8,null,141521,0)]
 16783:20130626:120254.442 End of DBstart_escalation()
 16783:20130626:120254.442 In execute_operations() actionid:8
 16783:20130626:120254.442 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]
 16783:20130626:120254.442 In op_host_add()
 16783:20130626:120254.442 In add_discovered_host() eventid:141521
 16783:20130626:120254.442 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=1 order by ds.dserviceid]
 16783:20130626:120254.443 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.443 In DBadd_interface()
 16783:20130626:120254.443 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.444 In DBget_nextid() tablename:'interface'
 16783:20130626:120254.444 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 16783:20130626:120254.444 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='interface' and field_name='interfaceid']
 16783:20130626:120254.444 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 16783:20130626:120254.445 End of DBget_nextid():51 table:'interface' recid:'interfaceid'
 16783:20130626:120254.445 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (51,10138,1,1,1,'10.20.0.32','it0.local',10050)]
 16783:20130626:120254.445 End of DBadd_interface():51
 16783:20130626:120254.445 End of add_discovered_host()
 16783:20130626:120254.445 End of op_host_add()
 16783:20130626:120254.445 In op_template_add()
 16783:20130626:120254.445 In add_discovered_host() eventid:141521
 16783:20130626:120254.445 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=1 order by ds.dserviceid]
 16783:20130626:120254.446 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.446 In DBadd_interface()
 16783:20130626:120254.446 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.447 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.447 End of DBadd_interface():51
 16783:20130626:120254.447 End of add_discovered_host()
 16783:20130626:120254.447 In DBcopy_template_elements()
 16783:20130626:120254.447 query [txnlev:1] [select templateid from hosts_templates where hostid=10138]
 16783:20130626:120254.447 In validate_linked_templates()
 16783:20130626:120254.447 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]
 16783:20130626:120254.448 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]
 16783:20130626:120254.449 End of validate_linked_templates():SUCCEED
 16783:20130626:120254.449 In validate_host()
 16783:20130626:120254.449 In validate_inventory_links()
 16783:20130626:120254.449 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]
 16783:20130626:120254.449 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=10138 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10050 and items.key_=i.key_) limit 1]
 16783:20130626:120254.450 End of validate_inventory_links():SUCCEED
 16783:20130626:120254.450 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]
 16783:20130626:120254.450 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10138 and t.hostid=10050 limit 1]
 16783:20130626:120254.451 query [txnlev:1] [select type,interfaceid from interface where hostid=10138 and type in (1,2,3,4) and main=1 and interfaceid between 0 and 99999999999999]
 16783:20130626:120254.451 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,11,15) and hostid=10050]
 16783:20130626:120254.452 In validate_host():SUCCEED
 16783:20130626:120254.452 In DBget_nextid() tablename:'hosts_templates'
 16783:20130626:120254.452 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 16783:20130626:120254.452 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 16783:20130626:120254.452 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 16783:20130626:120254.453 End of DBget_nextid():56 table:'hosts_templates' recid:'hosttemplateid'
 16783:20130626:120254.453 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (56,10138,10050)]
 16783:20130626:120254.453 In DBcopy_template_applications()
 16783:20130626:120254.453 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=10138 where ta.hostid=10050 order by ha.applicationid]
 16783:20130626:120254.454 In DBget_nextid() tablename:'applications'
 16783:20130626:120254.454 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 16783:20130626:120254.454 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='applications' and field_name='applicationid']
 16783:20130626:120254.454 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 16783:20130626:120254.455 End of DBget_nextid():405 table:'applications' recid:'applicationid'
 16783:20130626:120254.455 query [txnlev:1] [insert into applications (applicationid,hostid,name,templateid) values (405,10138,'Zabbix agent',206);
]
 16783:20130626:120254.455 End of DBcopy_template_applications()
 16783:20130626:120254.455 In DBcopy_template_items()
 16783:20130626:120254.455 query [txnlev:1] [select type,interfaceid from interface where hostid=10138 and type in (1,2,3,4) and main=1]
 16783:20130626:120254.456 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=10138 where ti.hostid=10050 order by hi.itemid]
 16783:20130626:120254.457 In DBget_nextid() tablename:'items'
 16783:20130626:120254.457 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 16783:20130626:120254.457 query [txnlev:1] [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid']
 16783:20130626:120254.457 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 16783:20130626:120254.458 End of DBget_nextid():23768 table:'items' recid:'itemid'
 16783:20130626:120254.458 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 (23768,'Host name of zabbix_agentd running','agent.hostname',10138,0,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',23318,0,'','',0,51,'30'),(23769,'Agent ping','agent.ping',10138,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,51,'0'),(23770,'Version of zabbix_agent(d) running','agent.version',10138,0,1,0,3600,'',7,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',22231,0,'','',0,51,'0');
]
 16783:20130626:120254.459 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid in (23768,23769,23770) 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]
 16783:20130626:120254.460 In DBget_nextid() tablename:'items_applications'
 16783:20130626:120254.460 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 16783:20130626:120254.460 query [txnlev:1] [update ids set nextid=nextid+3 where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 16783:20130626:120254.460 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 16783:20130626:120254.461 End of DBget_nextid():5890 table:'items_applications' recid:'itemappid'
 16783:20130626:120254.461 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (5890,23768,405),(5891,23769,405),(5892,23770,405);
]
 16783:20130626:120254.461 End of DBcopy_template_items()
 16783:20130626:120254.461 In DBcopy_template_triggers()
 16783:20130626:120254.461 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]
 16783:20130626:120254.462 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=10138 and t.description='Host name of zabbix_agentd was changed on {HOST.NAME}']
 16783:20130626:120254.462 In DBget_nextid() tablename:'triggers'
 16783:20130626:120254.462 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.463 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.463 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.463 End of DBget_nextid():13604 table:'triggers' recid:'triggerid'
 16783:20130626:120254.464 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=10138 where tf.itemid=ti.itemid and tf.triggerid=13507]
 16783:20130626:120254.464 In DBget_nextid() tablename:'functions'
 16783:20130626:120254.464 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.464 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.465 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.465 End of DBget_nextid():13060 table:'functions' recid:'functionid'
 16783:20130626:120254.465 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (13604,'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 (13060,23768,13604,'diff','0');
update triggers set expression='{13060}>0' where triggerid=13604;
]
 16783:20130626:120254.466 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=10138 and t.description='Zabbix agent on {HOST.NAME} is unreachable for 5 minutes']
 16783:20130626:120254.466 In DBget_nextid() tablename:'triggers'
 16783:20130626:120254.466 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.467 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.467 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.467 End of DBget_nextid():13605 table:'triggers' recid:'triggerid'
 16783:20130626:120254.467 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=10138 where tf.itemid=ti.itemid and tf.triggerid=13025]
 16783:20130626:120254.468 In DBget_nextid() tablename:'functions'
 16783:20130626:120254.468 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.468 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.469 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.469 End of DBget_nextid():13061 table:'functions' recid:'functionid'
 16783:20130626:120254.469 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (13605,'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 (13061,23769,13605,'nodata','5m');
update triggers set expression='{13061}=1' where triggerid=13605;
]
 16783:20130626:120254.470 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=10138 and t.description='Version of zabbix_agent(d) was changed on {HOST.NAME}']
 16783:20130626:120254.470 In DBget_nextid() tablename:'triggers'
 16783:20130626:120254.470 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.471 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.471 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 16783:20130626:120254.471 End of DBget_nextid():13606 table:'triggers' recid:'triggerid'
 16783:20130626:120254.472 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=10138 where tf.itemid=ti.itemid and tf.triggerid=13026]
 16783:20130626:120254.472 In DBget_nextid() tablename:'functions'
 16783:20130626:120254.472 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.472 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.473 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 16783:20130626:120254.473 End of DBget_nextid():13062 table:'functions' recid:'functionid'
 16783:20130626:120254.473 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (13606,'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 (13062,23770,13606,'diff','0');
update triggers set expression='{13062}>0' where triggerid=13606;
]
 16783:20130626:120254.474 query [txnlev:1] [select triggerid,templateid from triggers where triggerid in (13604,13605,13606)]
 16783:20130626:120254.474 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 (13604,13605,13606)]
 16783:20130626:120254.474 End of DBcopy_template_triggers():SUCCEED
 16783:20130626:120254.474 In DBcopy_template_graphs()
 16783:20130626:120254.474 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]
 16783:20130626:120254.475 End of DBcopy_template_graphs():SUCCEED
 16783:20130626:120254.475 End of DBcopy_template_elements():SUCCEED
 16783:20130626:120254.475 End of op_template_add()
 16783:20130626:120254.475 In op_groups_add()
 16783:20130626:120254.475 In add_discovered_host() eventid:141521
 16783:20130626:120254.475 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=1 order by ds.dserviceid]
 16783:20130626:120254.476 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.476 In DBadd_interface()
 16783:20130626:120254.476 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.477 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.477 End of DBadd_interface():51
 16783:20130626:120254.477 End of add_discovered_host()
 16783:20130626:120254.477 In add_discovered_host_groups()
 16783:20130626:120254.477 query [txnlev:1] [select groupid from hosts_groups where hostid=10138 and groupid=4]
 16783:20130626:120254.477 In DBget_nextid() tablename:'hosts_groups'
 16783:20130626:120254.477 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 16783:20130626:120254.478 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 16783:20130626:120254.478 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 16783:20130626:120254.478 End of DBget_nextid():164 table:'hosts_groups' recid:'hostgroupid'
 16783:20130626:120254.478 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (164,10138,4);
]
 16783:20130626:120254.479 End of add_discovered_host_groups()
 16783:20130626:120254.479 End of op_groups_add()
 16783:20130626:120254.479 End of execute_operations()
 16783:20130626:120254.479 End of process_actions()
 16783:20130626:120254.479 End of process_event():SUCCEED
 16783:20130626:120254.479 In process_event() eventid:0 object:2 objectid:1 value:0 value_changed:0
 16783:20130626:120254.479 In add_trigger_info()
 16783:20130626:120254.479 End of add_trigger_info():SUCCEED
 16783:20130626:120254.479 In DBget_nextid() tablename:'events'
 16783:20130626:120254.479 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.479 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.480 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.480 End of DBget_nextid():141522 table:'events' recid:'eventid'
 16783:20130626:120254.480 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (141522,1,2,1,1372237374,0,0,0)]
 16783:20130626:120254.480 In process_actions() eventid:141522
 16783:20130626:120254.481 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 16783:20130626:120254.481 In check_action_conditions() actionid:7
 16783:20130626:120254.481 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=7 order by conditiontype]
 16783:20130626:120254.481 In check_action_condition() actionid:7 conditionid:12 cond.value:'9'
 16783:20130626:120254.481 In check_discovery_condition()
 16783:20130626:120254.481 query [txnlev:1] [select type from dservices where dserviceid=1]
 16783:20130626:120254.481 End of check_discovery_condition():SUCCEED
 16783:20130626:120254.482 End of check_action_condition():SUCCEED
 16783:20130626:120254.482 In check_action_condition() actionid:7 conditionid:11 cond.value:'1'
 16783:20130626:120254.482 In check_discovery_condition()
 16783:20130626:120254.482 End of check_discovery_condition():FAIL
 16783:20130626:120254.482 End of check_action_condition():FAIL
 16783:20130626:120254.482 End of check_action_conditions():FAIL
 16783:20130626:120254.482 In check_action_conditions() actionid:8
 16783:20130626:120254.482 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=8 order by conditiontype]
 16783:20130626:120254.482 In check_action_condition() actionid:8 conditionid:17 cond.value:'7'
 16783:20130626:120254.482 In check_discovery_condition()
 16783:20130626:120254.482 query [txnlev:1] [select h.druleid from dhosts h,dservices s where h.dhostid=s.dhostid and h.druleid=7 and s.dserviceid=1]
 16783:20130626:120254.482 End of check_discovery_condition():SUCCEED
 16783:20130626:120254.482 End of check_action_condition():SUCCEED
 16783:20130626:120254.483 End of check_action_conditions():SUCCEED
 16783:20130626:120254.483 In DBstart_escalation()
 16783:20130626:120254.483 In DCget_nextid() table:'escalations' num:1
 16783:20130626:120254.483 End of DCget_nextid() table:'escalations' [2:2]
 16783:20130626:120254.483 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (2,8,null,141522,0)]
 16783:20130626:120254.483 End of DBstart_escalation()
 16783:20130626:120254.483 In execute_operations() actionid:8
 16783:20130626:120254.483 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]
 16783:20130626:120254.483 In op_host_add()
 16783:20130626:120254.483 In add_discovered_host() eventid:141522
 16783:20130626:120254.483 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=1 order by ds.dserviceid]
 16783:20130626:120254.484 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.484 In DBadd_interface()
 16783:20130626:120254.484 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.485 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.485 End of DBadd_interface():51
 16783:20130626:120254.485 End of add_discovered_host()
 16783:20130626:120254.485 End of op_host_add()
 16783:20130626:120254.485 In op_template_add()
 16783:20130626:120254.485 In add_discovered_host() eventid:141522
 16783:20130626:120254.485 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=1 order by ds.dserviceid]
 16783:20130626:120254.486 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.486 In DBadd_interface()
 16783:20130626:120254.486 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.486 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.487 End of DBadd_interface():51
 16783:20130626:120254.487 End of add_discovered_host()
 16783:20130626:120254.487 In DBcopy_template_elements()
 16783:20130626:120254.487 query [txnlev:1] [select templateid from hosts_templates where hostid=10138]
 16783:20130626:120254.487 End of DBcopy_template_elements():SUCCEED
 16783:20130626:120254.487 End of op_template_add()
 16783:20130626:120254.487 In op_groups_add()
 16783:20130626:120254.487 In add_discovered_host() eventid:141522
 16783:20130626:120254.487 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=1 order by ds.dserviceid]
 16783:20130626:120254.488 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.488 In DBadd_interface()
 16783:20130626:120254.488 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.489 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.489 End of DBadd_interface():51
 16783:20130626:120254.489 End of add_discovered_host()
 16783:20130626:120254.489 In add_discovered_host_groups()
 16783:20130626:120254.489 query [txnlev:1] [select groupid from hosts_groups where hostid=10138 and groupid=4]
 16783:20130626:120254.489 End of add_discovered_host_groups()
 16783:20130626:120254.489 End of op_groups_add()
 16783:20130626:120254.489 End of execute_operations()
 16783:20130626:120254.489 End of process_actions()
 16783:20130626:120254.489 End of process_event():SUCCEED
 16783:20130626:120254.489 End of discovery_update_service()
 16783:20130626:120254.489 query [txnlev:1] [commit;]
 16783:20130626:120254.515 End of process_check()
 16783:20130626:120254.515 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 and dcheckid<>9 order by dcheckid]
 16783:20130626:120254.515 query [txnlev:1] [begin;]
 16783:20130626:120254.515 In discovery_update_host()
 16783:20130626:120254.515 query [txnlev:1] [update dhosts set status=0,lastup=1372237374,lastdown=0 where dhostid=10]
 16783:20130626:120254.516 In process_event() eventid:0 object:1 objectid:10 value:2 value_changed:0
 16783:20130626:120254.516 In add_trigger_info()
 16783:20130626:120254.516 End of add_trigger_info():SUCCEED
 16783:20130626:120254.516 In DBget_nextid() tablename:'events'
 16783:20130626:120254.516 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.516 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.517 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.517 End of DBget_nextid():141523 table:'events' recid:'eventid'
 16783:20130626:120254.517 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (141523,1,1,10,1372237374,0,2,0)]
 16783:20130626:120254.518 In process_actions() eventid:141523
 16783:20130626:120254.518 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 16783:20130626:120254.518 In check_action_conditions() actionid:7
 16783:20130626:120254.518 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=7 order by conditiontype]
 16783:20130626:120254.518 In check_action_condition() actionid:7 conditionid:12 cond.value:'9'
 16783:20130626:120254.518 In check_discovery_condition()
 16783:20130626:120254.518 End of check_discovery_condition():FAIL
 16783:20130626:120254.518 End of check_action_condition():FAIL
 16783:20130626:120254.518 End of check_action_conditions():FAIL
 16783:20130626:120254.518 In check_action_conditions() actionid:8
 16783:20130626:120254.518 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=8 order by conditiontype]
 16783:20130626:120254.519 In check_action_condition() actionid:8 conditionid:17 cond.value:'7'
 16783:20130626:120254.519 In check_discovery_condition()
 16783:20130626:120254.519 query [txnlev:1] [select druleid from dhosts where druleid=7 and dhostid=10]
 16783:20130626:120254.519 End of check_discovery_condition():SUCCEED
 16783:20130626:120254.519 End of check_action_condition():SUCCEED
 16783:20130626:120254.519 End of check_action_conditions():SUCCEED
 16783:20130626:120254.519 In DBstart_escalation()
 16783:20130626:120254.519 In DCget_nextid() table:'escalations' num:1
 16783:20130626:120254.519 End of DCget_nextid() table:'escalations' [3:3]
 16783:20130626:120254.519 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (3,8,null,141523,0)]
 16783:20130626:120254.520 End of DBstart_escalation()
 16783:20130626:120254.520 In execute_operations() actionid:8
 16783:20130626:120254.520 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]
 16783:20130626:120254.520 In op_host_add()
 16783:20130626:120254.520 In add_discovered_host() eventid:141523
 16783:20130626:120254.520 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds.dhostid=10 order by ds.dserviceid]
 16783:20130626:120254.520 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.521 In DBadd_interface()
 16783:20130626:120254.521 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.521 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.522 End of DBadd_interface():51
 16783:20130626:120254.522 End of add_discovered_host()
 16783:20130626:120254.522 End of op_host_add()
 16783:20130626:120254.522 In op_template_add()
 16783:20130626:120254.522 In add_discovered_host() eventid:141523
 16783:20130626:120254.522 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds.dhostid=10 order by ds.dserviceid]
 16783:20130626:120254.522 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.522 In DBadd_interface()
 16783:20130626:120254.522 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.522 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.522 End of DBadd_interface():51
 16783:20130626:120254.522 End of add_discovered_host()
 16783:20130626:120254.523 In DBcopy_template_elements()
 16783:20130626:120254.523 query [txnlev:1] [select templateid from hosts_templates where hostid=10138]
 16783:20130626:120254.523 End of DBcopy_template_elements():SUCCEED
 16783:20130626:120254.523 End of op_template_add()
 16783:20130626:120254.523 In op_groups_add()
 16783:20130626:120254.523 In add_discovered_host() eventid:141523
 16783:20130626:120254.523 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds.dhostid=10 order by ds.dserviceid]
 16783:20130626:120254.523 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.524 In DBadd_interface()
 16783:20130626:120254.524 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.524 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.524 End of DBadd_interface():51
 16783:20130626:120254.524 End of add_discovered_host()
 16783:20130626:120254.524 In add_discovered_host_groups()
 16783:20130626:120254.524 query [txnlev:1] [select groupid from hosts_groups where hostid=10138 and groupid=4]
 16783:20130626:120254.524 End of add_discovered_host_groups()
 16783:20130626:120254.524 End of op_groups_add()
 16783:20130626:120254.524 End of execute_operations()
 16783:20130626:120254.525 End of process_actions()
 16783:20130626:120254.525 End of process_event():SUCCEED
 16783:20130626:120254.525 In process_event() eventid:0 object:1 objectid:10 value:0 value_changed:0
 16783:20130626:120254.525 In add_trigger_info()
 16783:20130626:120254.525 End of add_trigger_info():SUCCEED
 16783:20130626:120254.525 In DBget_nextid() tablename:'events'
 16783:20130626:120254.525 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.525 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.526 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 16783:20130626:120254.526 End of DBget_nextid():141524 table:'events' recid:'eventid'
 16783:20130626:120254.526 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (141524,1,1,10,1372237374,0,0,0)]
 16783:20130626:120254.526 In process_actions() eventid:141524
 16783:20130626:120254.526 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 16783:20130626:120254.526 In check_action_conditions() actionid:7
 16783:20130626:120254.527 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=7 order by conditiontype]
 16783:20130626:120254.527 In check_action_condition() actionid:7 conditionid:12 cond.value:'9'
 16783:20130626:120254.527 In check_discovery_condition()
 16783:20130626:120254.527 End of check_discovery_condition():FAIL
 16783:20130626:120254.527 End of check_action_condition():FAIL
 16783:20130626:120254.527 End of check_action_conditions():FAIL
 16783:20130626:120254.527 In check_action_conditions() actionid:8
 16783:20130626:120254.527 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=8 order by conditiontype]
 16783:20130626:120254.527 In check_action_condition() actionid:8 conditionid:17 cond.value:'7'
 16783:20130626:120254.527 In check_discovery_condition()
 16783:20130626:120254.527 query [txnlev:1] [select druleid from dhosts where druleid=7 and dhostid=10]
 16783:20130626:120254.528 End of check_discovery_condition():SUCCEED
 16783:20130626:120254.528 End of check_action_condition():SUCCEED
 16783:20130626:120254.528 End of check_action_conditions():SUCCEED
 16783:20130626:120254.528 In DBstart_escalation()
 16783:20130626:120254.528 In DCget_nextid() table:'escalations' num:1
 16783:20130626:120254.528 End of DCget_nextid() table:'escalations' [4:4]
 16783:20130626:120254.528 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (4,8,null,141524,0)]
 16783:20130626:120254.528 End of DBstart_escalation()
 16783:20130626:120254.528 In execute_operations() actionid:8
 16783:20130626:120254.528 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]
 16783:20130626:120254.528 In op_host_add()
 16783:20130626:120254.528 In add_discovered_host() eventid:141524
 16783:20130626:120254.528 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds.dhostid=10 order by ds.dserviceid]
 16783:20130626:120254.529 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.529 In DBadd_interface()
 16783:20130626:120254.529 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.529 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.529 End of DBadd_interface():51
 16783:20130626:120254.529 End of add_discovered_host()
 16783:20130626:120254.529 End of op_host_add()
 16783:20130626:120254.529 In op_template_add()
 16783:20130626:120254.529 In add_discovered_host() eventid:141524
 16783:20130626:120254.529 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds.dhostid=10 order by ds.dserviceid]
 16783:20130626:120254.529 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.529 In DBadd_interface()
 16783:20130626:120254.530 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.530 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.530 End of DBadd_interface():51
 16783:20130626:120254.530 End of add_discovered_host()
 16783:20130626:120254.530 In DBcopy_template_elements()
 16783:20130626:120254.530 query [txnlev:1] [select templateid from hosts_templates where hostid=10138]
 16783:20130626:120254.530 End of DBcopy_template_elements():SUCCEED
 16783:20130626:120254.530 End of op_template_add()
 16783:20130626:120254.530 In op_groups_add()
 16783:20130626:120254.530 In add_discovered_host() eventid:141524
 16783:20130626:120254.530 query [txnlev:1] [select ds.dhostid,dr.proxy_hostid,ds.ip,ds.dns,ds.port,ds.type from drules dr,dchecks dc,dservices ds where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds.dhostid=10 order by ds.dserviceid]
 16783:20130626:120254.530 query [txnlev:1] [select distinct h.hostid,h.proxy_hostid from hosts h,interface i,dservices ds where h.hostid=i.hostid and i.ip=ds.ip and ds.dhostid=10 and h.hostid between 0 and 99999999999999 order by h.hostid]
 16783:20130626:120254.530 In DBadd_interface()
 16783:20130626:120254.530 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10138 and type=1]
 16783:20130626:120254.531 In substitute_simple_macros() data:'10050'
 16783:20130626:120254.531 End of DBadd_interface():51
 16783:20130626:120254.531 End of add_discovered_host()
 16783:20130626:120254.531 In add_discovered_host_groups()
 16783:20130626:120254.531 query [txnlev:1] [select groupid from hosts_groups where hostid=10138 and groupid=4]
 16783:20130626:120254.531 End of add_discovered_host_groups()
 16783:20130626:120254.531 End of op_groups_add()
 16783:20130626:120254.531 End of execute_operations()
 16783:20130626:120254.531 End of process_actions()
 16783:20130626:120254.531 End of process_event():SUCCEED
 16783:20130626:120254.531 End of discovery_update_host()
 16783:20130626:120254.531 query [txnlev:1] [commit;]
 16783:20130626:120254.540 End of process_rule()
 16783:20130626:120254.540 query without transaction detected
 16783:20130626:120254.540 query [txnlev:0] [update drules set nextcheck=1372237374+delay where druleid=7]
 16783:20130626:120254.548 discoverer #1 spent 0.219937 seconds while processing rules
 16783:20130626:120254.548 query [txnlev:0] [select count(*),min(nextcheck) from drules where proxy_hostid is null and status=0 and mod(druleid,1)=0 and druleid between 0 and 99999999999999]
 16783:20130626:120254.549 sleeping for 60 seconds