14341:20120607:205729.361 server #15 started [discoverer #1]
 14341:20120607:205729.361 In main_discoverer_loop() process_num:1
 14341:20120607:205729.361 In DBconnect() flag:0
 14341:20120607:205729.367 query [txnlev:0] [set names utf8]
 14341:20120607:205729.367 End of DBconnect():0
 14341:20120607:205729.367 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<=1339091849 or r.nextcheck>1339091849+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999]
 14341:20120607:205729.368 In process_rule() rule:'Test Discovery LLD' range:'10.20.0.10-15'
 14341:20120607:205729.368 process_rule() '10.20.0.10-15'
 14341:20120607:205729.368 process_rule() IPv4 Range:'10.20.0.10' - '10.20.0.15'
 14341:20120607:205729.368 process_rule() IP:'10.20.0.10'
 14341:20120607:205729.369 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205729.369 In process_check()
 14341:20120607:205729.369 process_check() port:10050
 14341:20120607:205729.369 In discover_service()
 14341:20120607:205729.369 In get_value_agent() host:'' addr:'10.20.0.10' key:'system.uname'
 14341:20120607:205729.369 Sending [system.uname
 14341:20120607:205729.370 get value from agent result: 'Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205729.370 End of discover_service():SUCCEED
 14341:20120607:205729.370 query [txnlev:1] [begin;]
 14341:20120607:205729.372 In discovery_update_service() ip:'10.20.0.10' port:10050 status:0
 14341:20120607:205729.372 In discovery_register_host() ip:'10.20.0.10' status:0 value:'Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205729.372 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=8 and ds.ip='10.20.0.10' order by dh.dhostid]
 14341:20120607:205729.372 new host discovered at 10.20.0.10
 14341:20120607:205729.372 In DCget_nextid() table:'dhosts' num:1
 14341:20120607:205729.372 query [txnlev:1] [select max(dhostid) from dhosts where dhostid between 0 and 99999999999]
 14341:20120607:205729.373 End of DCget_nextid() table:'dhosts' [1:1]
 14341:20120607:205729.373 query [txnlev:1] [insert into dhosts (dhostid,druleid) values (1,8)]
 14341:20120607:205729.373 End of discovery_register_host()
 14341:20120607:205729.373 In discovery_register_service() ip:'10.20.0.10' port:10050 key:'system.uname'
 14341:20120607:205729.373 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.10' and port=10050]
 14341:20120607:205729.373 new service discovered on port 10050
 14341:20120607:205729.373 In DCget_nextid() table:'dservices' num:1
 14341:20120607:205729.373 query [txnlev:1] [select max(dserviceid) from dservices where dserviceid between 0 and 99999999999]
 14341:20120607:205729.373 End of DCget_nextid() table:'dservices' [1:1]
 14341:20120607:205729.373 query [txnlev:1] [insert into dservices (dserviceid,dhostid,dcheckid,type,key_,ip,dns,port,status) values (1,1,39,9,'system.uname','10.20.0.10','it0',10050,1)]
 14341:20120607:205729.373 End of discovery_register_service()
 14341:20120607:205729.373 query [txnlev:1] [update dservices set status=0,lastup=1339091849,lastdown=0,value='Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32' where dserviceid=1]
 14341:20120607:205729.373 In process_event() eventid:0 object:2 objectid:1 value:2 value_changed:0
 14341:20120607:205729.373 In add_trigger_info()
 14341:20120607:205729.373 End of add_trigger_info():SUCCEED
 14341:20120607:205729.374 In DBget_nextid() tablename:'events'
 14341:20120607:205729.374 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.374 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.374 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.374 End of DBget_nextid():2248794 table:'events' recid:'eventid'
 14341:20120607:205729.374 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248794,1,2,1,1339091849,0,2,0)]
 14341:20120607:205729.374 In process_actions() eventid:2248794
 14341:20120607:205729.374 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.374 In check_action_conditions() actionid:42
 14341:20120607:205729.374 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.375 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.375 In check_discovery_condition()
 14341:20120607:205729.375 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.375 End of check_action_condition():SUCCEED
 14341:20120607:205729.375 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205729.375 In check_discovery_condition()
 14341:20120607:205729.375 query [txnlev:1] [select value from dservices where dserviceid=1]
 14341:20120607:205729.375 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.375 End of check_action_condition():SUCCEED
 14341:20120607:205729.375 In check_action_condition() actionid:42 conditionid:463 cond.value:'8'
 14341:20120607:205729.375 In check_discovery_condition() 
 14341:20120607:205729.375 query [txnlev:1] [select h.druleid from dhosts h,dservices s where h.dhostid=s.dhostid and h.druleid=8 and s.dserviceid=1]
 14341:20120607:205729.375 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.375 End of check_action_condition():SUCCEED
 14341:20120607:205729.375 End of check_action_conditions():SUCCEED
 14341:20120607:205729.375 In DBstart_escalation()
 14341:20120607:205729.375 In DCget_nextid() table:'escalations' num:1
 14341:20120607:205729.375 query [txnlev:1] [select max(escalationid) from escalations where escalationid between 0 and 99999999999999]
 14341:20120607:205729.375 End of DCget_nextid() table:'escalations' [1:1]
 14341:20120607:205729.375 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (1,42,null,2248794,0)]
 14341:20120607:205729.375 End of DBstart_escalation()
 14341:20120607:205729.375 In execute_operations() actionid:42
 14341:20120607:205729.375 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=42]
 14341:20120607:205729.376 In op_template_add()
 14341:20120607:205729.376 In add_discovered_host() eventid:2248794
 14341:20120607:205729.376 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]
 14341:20120607:205729.376 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=1 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205729.376 In DBget_nextid() tablename:'hosts'
 14341:20120607:205729.376 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.376 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.376 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.377 End of DBget_nextid():10174 table:'hosts' recid:'hostid'
 14341:20120607:205729.377 In DBget_unique_hostname_by_sample() sample:'it0'
 14341:20120607:205729.377 query [txnlev:1] [select host from hosts where host like 'it0%' escape '!' and hostid between 0 and 99999999999999]
 14341:20120607:205729.377 End of DBget_unique_hostname_by_sample():'it0'
 14341:20120607:205729.377 query [txnlev:1] [insert into hosts (hostid,proxy_hostid,host,name) values (10174,null,'it0','it0')]
 14341:20120607:205729.377 In DBadd_interface()
 14341:20120607:205729.377 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10174 and type=1]
 14341:20120607:205729.377 In DBget_nextid() tablename:'interface'
 14341:20120607:205729.377 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.377 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.378 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.378 End of DBget_nextid():30338 table:'interface' recid:'interfaceid'
 14341:20120607:205729.378 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (30338,10174,1,1,1,'10.20.0.10','it0',10050)]
 14341:20120607:205729.378 End of DBadd_interface():30338
 14341:20120607:205729.378 In add_discovered_host_groups()
 14341:20120607:205729.378 query [txnlev:1] [select groupid from hosts_groups where hostid=10174 and groupid=5]
 14341:20120607:205729.378 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205729.378 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.378 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.378 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.384 End of DBget_nextid():435 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205729.384 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (435,10174,5);
 14341:20120607:205729.384 End of add_discovered_host_groups()
 14341:20120607:205729.384 End of add_discovered_host()
 14341:20120607:205729.384 In DBcopy_template_elements()
 14341:20120607:205729.384 query [txnlev:1] [select templateid from hosts_templates where hostid=10174]
 14341:20120607:205729.385 In validate_linked_templates()
 14341:20120607:205729.385 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=10161 and not i2.hostid=10161 limit 1]
 14341:20120607:205729.385 query [txnlev:1] [select t1.description,h1.host,t2.description,h2.host 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=10161 and not i2.hostid=10161 and h2.status=3 limit 1]
 14341:20120607:205729.385 End of validate_linked_templates():SUCCEED
 14341:20120607:205729.385 In validate_host()
 14341:20120607:205729.385 In validate_inventory_links()
 14341:20120607:205729.385 query [txnlev:1] [select inventory_link,count(*) from items where inventory_link<>0 and hostid=10161 group by inventory_link having count(*)>1 limit 1]
 14341:20120607:205729.385 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=10161 and i.hostid=10174 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10161 and items.key_=i.key_) limit 1]
 14341:20120607:205729.386 End of validate_inventory_links():SUCCEED
 14341:20120607:205729.386 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=10161]
 14341:20120607:205729.386 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10174 and t.hostid=10161 limit 1]
 14341:20120607:205729.386 query [txnlev:1] [select type,interfaceid from interface where hostid=10174 and type in (1,2,3,4) and main=1 and interfaceid between 0 and 99999999999999]
 14341:20120607:205729.386 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,11,15) and hostid=10161]
 14341:20120607:205729.386 In validate_host():SUCCEED
 14341:20120607:205729.387 In DBget_nextid() tablename:'hosts_templates'
 14341:20120607:205729.387 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.387 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.387 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.387 End of DBget_nextid():293 table:'hosts_templates' recid:'hosttemplateid'
 14341:20120607:205729.387 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (293,10174,10161)]
 14341:20120607:205729.387 In DBcopy_template_applications()
 14341:20120607:205729.387 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=10174 where ta.hostid=10161 order by ha.applicationid]
 14341:20120607:205729.387 In DBget_nextid() tablename:'applications'
 14341:20120607:205729.387 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.387 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.388 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.388 End of DBget_nextid():585 table:'applications' recid:'applicationid'
 14341:20120607:205729.388 query [txnlev:1] [insert into applications (applicationid,hostid,name,templateid) values (585,10174,'Filesystems',548);
 14341:20120607:205729.388 End of DBcopy_template_applications()
 14341:20120607:205729.388 In DBcopy_template_items()
 14341:20120607:205729.388 query [txnlev:1] [select type,interfaceid from interface where hostid=10174 and type in (1,2,3,4) and main=1]
 14341:20120607:205729.388 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,hi.itemid from items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10174 where ti.hostid=10161 order by hi.itemid]
 14341:20120607:205729.389 In DBget_nextid() tablename:'items'
 14341:20120607:205729.389 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.389 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.389 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.389 End of DBget_nextid():26574 table:'items' recid:'itemid'
 14341:20120607:205729.389 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) values (26574,'Mounted filesystem discovery','vfs.fs.discovery',10174,0,4,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26479,1,'{#FSTYPE}:@File systems for discovery','Discovery of file systems of different types as defined in global regular expression "File systems for discovery".',0,30338),(26575,'Free disk space on $1 (percentage)','vfs.fs.size[{#FSNAME},pfree]',10174,0,0,0,600,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26481,2,'','',0,30338);
 14341:20120607:205729.389 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid between 26574 and 26575 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]
 14341:20120607:205729.390 In DBget_nextid() tablename:'items_applications'
 14341:20120607:205729.390 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.390 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.390 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.390 End of DBget_nextid():8758 table:'items_applications' recid:'itemappid'
 14341:20120607:205729.390 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (8758,26575,585);
 14341:20120607:205729.390 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 i.itemid=26575]
 14341:20120607:205729.390 In DBget_nextid() tablename:'item_discovery'
 14341:20120607:205729.390 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.391 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.391 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.391 End of DBget_nextid():1061 table:'item_discovery' recid:'itemdiscoveryid'
 14341:20120607:205729.391 query [txnlev:1] [insert into item_discovery (itemdiscoveryid,itemid,parent_itemid) values (1061,26575,26572),(1062,26575,26574);
 14341:20120607:205729.391 End of DBcopy_template_items()
 14341:20120607:205729.391 In DBcopy_template_triggers()
 14341:20120607:205729.391 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=10161]
 14341:20120607:205729.391 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=10174 and t.description='Free disk space is less than 10% on volume {#FSNAME}']
 14341:20120607:205729.392 In DBget_nextid() tablename:'triggers'
 14341:20120607:205729.392 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.392 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.392 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.392 End of DBget_nextid():220971 table:'triggers' recid:'triggerid'
 14341:20120607:205729.392 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=10174 where tf.itemid=ti.itemid and tf.triggerid=220637]
 14341:20120607:205729.392 In DBget_nextid() tablename:'functions'
 14341:20120607:205729.392 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.392 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.395 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.395 End of DBget_nextid():14880 table:'functions' recid:'functionid'
 14341:20120607:205729.395 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (220971,'Free disk space is less than 10% on volume {#FSNAME}',2,0,'','',0,0,1,220637,2);
 14341:20120607:205729.395 query [txnlev:1] [select triggerid,templateid from triggers where triggerid=220971]
 14341:20120607:205729.396 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=220971]
 14341:20120607:205729.396 End of DBcopy_template_triggers():SUCCEED
 14341:20120607:205729.396 In DBcopy_template_graphs()
 14341:20120607:205729.396 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=10161]
 14341:20120607:205729.396 End of DBcopy_template_graphs():SUCCEED
 14341:20120607:205729.396 End of DBcopy_template_elements():SUCCEED
 14341:20120607:205729.396 End of op_template_add()
 14341:20120607:205729.396 In op_groups_add()
 14341:20120607:205729.396 In add_discovered_host() eventid:2248794
 14341:20120607:205729.396 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]
 14341:20120607:205729.397 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=1 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205729.397 In DBadd_interface()
 14341:20120607:205729.397 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10174 and type=1]
 14341:20120607:205729.397 In substitute_simple_macros() data:'10050'
 14341:20120607:205729.397 End of DBadd_interface():30338
 14341:20120607:205729.397 End of add_discovered_host()
 14341:20120607:205729.397 In add_discovered_host_groups()
 14341:20120607:205729.397 query [txnlev:1] [select groupid from hosts_groups where hostid=10174 and groupid=21]
 14341:20120607:205729.397 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205729.397 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.397 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.397 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.398 End of DBget_nextid():436 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205729.398 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (436,10174,21);
 14341:20120607:205729.398 End of add_discovered_host_groups()
 14341:20120607:205729.398 End of op_groups_add()
 14341:20120607:205729.398 End of execute_operations()
 14341:20120607:205729.398 End of process_actions()
 14341:20120607:205729.398 End of process_event():SUCCEED
 14341:20120607:205729.398 In process_event() eventid:0 object:2 objectid:1 value:0 value_changed:0
 14341:20120607:205729.398 In add_trigger_info()
 14341:20120607:205729.398 End of add_trigger_info():SUCCEED
 14341:20120607:205729.398 In DBget_nextid() tablename:'events'
 14341:20120607:205729.398 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.398 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.398 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.398 End of DBget_nextid():2248795 table:'events' recid:'eventid'
 14341:20120607:205729.398 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248795,1,2,1,1339091849,0,0,0)]
 14341:20120607:205729.398 In process_actions() eventid:2248795
 14341:20120607:205729.398 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.398 In check_action_conditions() actionid:42
 14341:20120607:205729.398 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.399 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.399 In check_discovery_condition()
 14341:20120607:205729.399 End of check_discovery_condition():FAIL
 14341:20120607:205729.399 End of check_action_condition():FAIL
 14341:20120607:205729.399 End of check_action_conditions():FAIL
 14341:20120607:205729.399 End of process_actions()
 14341:20120607:205729.399 End of process_event():SUCCEED
 14341:20120607:205729.399 End of discovery_update_service()
 14341:20120607:205729.399 query [txnlev:1] [commit;]
 14341:20120607:205729.408 End of process_check()
 14341:20120607:205729.408 query [txnlev:1] [begin;]
 14341:20120607:205729.408 In discovery_update_host()
 14341:20120607:205729.408 query [txnlev:1] [update dhosts set status=0,lastup=1339091849,lastdown=0 where dhostid=1]
 14341:20120607:205729.408 In process_event() eventid:0 object:1 objectid:1 value:2 value_changed:0
 14341:20120607:205729.408 In add_trigger_info()
 14341:20120607:205729.408 End of add_trigger_info():SUCCEED
 14341:20120607:205729.408 In DBget_nextid() tablename:'events'
 14341:20120607:205729.408 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.409 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.409 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.409 End of DBget_nextid():2248796 table:'events' recid:'eventid'
 14341:20120607:205729.409 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248796,1,1,1,1339091849,0,2,0)]
 14341:20120607:205729.409 In process_actions() eventid:2248796
 14341:20120607:205729.409 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.409 In check_action_conditions() actionid:42
 14341:20120607:205729.409 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.409 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.409 In check_discovery_condition()
 14341:20120607:205729.409 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.409 End of check_action_condition():SUCCEED
 14341:20120607:205729.409 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205729.409 In check_discovery_condition()
 14341:20120607:205729.409 End of check_discovery_condition():FAIL
 14341:20120607:205729.409 End of check_action_condition():FAIL
 14341:20120607:205729.409 End of check_action_conditions():FAIL
 14341:20120607:205729.409 End of process_actions()
 14341:20120607:205729.409 End of process_event():SUCCEED
 14341:20120607:205729.409 In process_event() eventid:0 object:1 objectid:1 value:0 value_changed:0
 14341:20120607:205729.409 In add_trigger_info()
 14341:20120607:205729.410 End of add_trigger_info():SUCCEED
 14341:20120607:205729.410 In DBget_nextid() tablename:'events'
 14341:20120607:205729.410 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.410 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.410 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.410 End of DBget_nextid():2248797 table:'events' recid:'eventid'
 14341:20120607:205729.410 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248797,1,1,1,1339091849,0,0,0)]
 14341:20120607:205729.410 In process_actions() eventid:2248797
 14341:20120607:205729.410 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.410 In check_action_conditions() actionid:42
 14341:20120607:205729.410 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.410 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.410 In check_discovery_condition()
 14341:20120607:205729.410 End of check_discovery_condition():FAIL
 14341:20120607:205729.410 End of check_action_condition():FAIL
 14341:20120607:205729.410 End of check_action_conditions():FAIL
 14341:20120607:205729.410 End of process_actions()
 14341:20120607:205729.410 End of process_event():SUCCEED
 14341:20120607:205729.410 End of discovery_update_host()
 14341:20120607:205729.410 query [txnlev:1] [commit;]
 14341:20120607:205729.411 process_rule() IP:'10.20.0.11'
 14341:20120607:205729.411 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205729.411 In process_check()
 14341:20120607:205729.411 process_check() port:10050
 14341:20120607:205729.411 In discover_service()
 14341:20120607:205729.411 In get_value_agent() host:'' addr:'10.20.0.11' key:'system.uname'
 14341:20120607:205729.413 Sending [system.uname
 14341:20120607:205729.414 get value from agent result: 'Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205729.414 End of discover_service():SUCCEED
 14341:20120607:205729.414 query [txnlev:1] [begin;]
 14341:20120607:205729.414 In discovery_update_service() ip:'10.20.0.11' port:10050 status:0
 14341:20120607:205729.414 In discovery_register_host() ip:'10.20.0.11' status:0 value:'Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205729.414 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=8 and ds.ip='10.20.0.11' order by dh.dhostid]
 14341:20120607:205729.415 new host discovered at 10.20.0.11
 14341:20120607:205729.415 In DCget_nextid() table:'dhosts' num:1
 14341:20120607:205729.415 End of DCget_nextid() table:'dhosts' [2:2]
 14341:20120607:205729.415 query [txnlev:1] [insert into dhosts (dhostid,druleid) values (2,8)]
 14341:20120607:205729.415 End of discovery_register_host()
 14341:20120607:205729.415 In discovery_register_service() ip:'10.20.0.11' port:10050 key:'system.uname'
 14341:20120607:205729.415 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.11' and port=10050]
 14341:20120607:205729.415 new service discovered on port 10050
 14341:20120607:205729.415 In DCget_nextid() table:'dservices' num:1
 14341:20120607:205729.415 End of DCget_nextid() table:'dservices' [2:2]
 14341:20120607:205729.415 query [txnlev:1] [insert into dservices (dserviceid,dhostid,dcheckid,type,key_,ip,dns,port,status) values (2,2,39,9,'system.uname','10.20.0.11','it4',10050,1)]
 14341:20120607:205729.415 End of discovery_register_service()
 14341:20120607:205729.415 query [txnlev:1] [update dservices set status=0,lastup=1339091849,lastdown=0,value='Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32' where dserviceid=2]
 14341:20120607:205729.415 In process_event() eventid:0 object:2 objectid:2 value:2 value_changed:0
 14341:20120607:205729.415 In add_trigger_info()
 14341:20120607:205729.415 End of add_trigger_info():SUCCEED
 14341:20120607:205729.415 In DBget_nextid() tablename:'events'
 14341:20120607:205729.415 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.416 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.416 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.416 End of DBget_nextid():2248798 table:'events' recid:'eventid'
 14341:20120607:205729.416 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248798,1,2,2,1339091849,0,2,0)]
 14341:20120607:205729.416 In process_actions() eventid:2248798
 14341:20120607:205729.416 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.416 In check_action_conditions() actionid:42
 14341:20120607:205729.416 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.416 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.416 In check_discovery_condition()
 14341:20120607:205729.416 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.416 End of check_action_condition():SUCCEED
 14341:20120607:205729.416 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205729.416 In check_discovery_condition()
 14341:20120607:205729.416 query [txnlev:1] [select value from dservices where dserviceid=2]
 14341:20120607:205729.416 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.417 End of check_action_condition():SUCCEED
 14341:20120607:205729.417 In check_action_condition() actionid:42 conditionid:463 cond.value:'8'
 14341:20120607:205729.417 In check_discovery_condition()
 14341:20120607:205729.417 query [txnlev:1] [select h.druleid from dhosts h,dservices s where h.dhostid=s.dhostid and h.druleid=8 and s.dserviceid=2]
 14341:20120607:205729.417 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.417 End of check_action_condition():SUCCEED
 14341:20120607:205729.417 End of check_action_conditions():SUCCEED
 14341:20120607:205729.417 In DBstart_escalation()
 14341:20120607:205729.417 In DCget_nextid() table:'escalations' num:1
 14341:20120607:205729.417 End of DCget_nextid() table:'escalations' [2:2]
 14341:20120607:205729.417 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (2,42,null,2248798,0)]
 14341:20120607:205729.417 End of DBstart_escalation()
 14341:20120607:205729.417 In execute_operations() actionid:42
 14341:20120607:205729.417 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=42]
 14341:20120607:205729.417 In op_template_add()
 14341:20120607:205729.417 In add_discovered_host() eventid:2248798
 14341:20120607:205729.417 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=2 order by ds.dserviceid]
 14341:20120607:205729.417 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=2 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205729.417 In DBget_nextid() tablename:'hosts'
 14341:20120607:205729.418 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.418 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.418 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.418 End of DBget_nextid():10175 table:'hosts' recid:'hostid'
 14341:20120607:205729.418 In DBget_unique_hostname_by_sample() sample:'it4'
 14341:20120607:205729.418 query [txnlev:1] [select host from hosts where host like 'it4%' escape '!' and hostid between 0 and 99999999999999]
 14341:20120607:205729.418 End of DBget_unique_hostname_by_sample():'it4'
 14341:20120607:205729.418 query [txnlev:1] [insert into hosts (hostid,proxy_hostid,host,name) values (10175,null,'it4','it4')]
 14341:20120607:205729.418 In DBadd_interface()
 14341:20120607:205729.418 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10175 and type=1]
 14341:20120607:205729.418 In DBget_nextid() tablename:'interface'
 14341:20120607:205729.418 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.419 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.419 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.419 End of DBget_nextid():30339 table:'interface' recid:'interfaceid'
 14341:20120607:205729.419 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (30339,10175,1,1,1,'10.20.0.11','it4',10050)]
 14341:20120607:205729.419 End of DBadd_interface():30339
 14341:20120607:205729.419 In add_discovered_host_groups()
 14341:20120607:205729.419 query [txnlev:1] [select groupid from hosts_groups where hostid=10175 and groupid=5]
 14341:20120607:205729.419 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205729.419 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.419 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.419 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.419 End of DBget_nextid():437 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205729.419 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (437,10175,5);
 14341:20120607:205729.420 End of add_discovered_host_groups()
 14341:20120607:205729.420 End of add_discovered_host()
 14341:20120607:205729.420 In DBcopy_template_elements()
 14341:20120607:205729.420 query [txnlev:1] [select templateid from hosts_templates where hostid=10175]
 14341:20120607:205729.420 In validate_linked_templates()
 14341:20120607:205729.420 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=10161 and not i2.hostid=10161 limit 1]
 14341:20120607:205729.420 query [txnlev:1] [select t1.description,h1.host,t2.description,h2.host 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=10161 and not i2.hostid=10161 and h2.status=3 limit 1]
 14341:20120607:205729.420 End of validate_linked_templates():SUCCEED
 14341:20120607:205729.420 In validate_host()
 14341:20120607:205729.420 In validate_inventory_links()
 14341:20120607:205729.420 query [txnlev:1] [select inventory_link,count(*) from items where inventory_link<>0 and hostid=10161 group by inventory_link having count(*)>1 limit 1]
 14341:20120607:205729.421 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=10161 and i.hostid=10175 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10161 and items.key_=i.key_) limit 1]
 14341:20120607:205729.421 End of validate_inventory_links():SUCCEED
 14341:20120607:205729.421 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=10161]
 14341:20120607:205729.421 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10175 and t.hostid=10161 limit 1]
 14341:20120607:205729.421 query [txnlev:1] [select type,interfaceid from interface where hostid=10175 and type in (1,2,3,4) and main=1 and interfaceid between 0 and 99999999999999]
 14341:20120607:205729.421 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,11,15) and hostid=10161]
 14341:20120607:205729.422 In validate_host():SUCCEED
 14341:20120607:205729.422 In DBget_nextid() tablename:'hosts_templates'
 14341:20120607:205729.422 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.422 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.422 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.422 End of DBget_nextid():294 table:'hosts_templates' recid:'hosttemplateid'
 14341:20120607:205729.422 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (294,10175,10161)]
 14341:20120607:205729.422 In DBcopy_template_applications()
 14341:20120607:205729.422 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=10175 where ta.hostid=10161 order by ha.applicationid]
 14341:20120607:205729.422 In DBget_nextid() tablename:'applications'
 14341:20120607:205729.422 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.423 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.423 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.423 End of DBget_nextid():586 table:'applications' recid:'applicationid'
 14341:20120607:205729.423 query [txnlev:1] [insert into applications (applicationid,hostid,name,templateid) values (586,10175,'Filesystems',548);
 14341:20120607:205729.423 End of DBcopy_template_applications()
 14341:20120607:205729.423 In DBcopy_template_items()
 14341:20120607:205729.423 query [txnlev:1] [select type,interfaceid from interface where hostid=10175 and type in (1,2,3,4) and main=1]
 14341:20120607:205729.423 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,hi.itemid from items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10175 where ti.hostid=10161 order by hi.itemid]
 14341:20120607:205729.424 In DBget_nextid() tablename:'items'
 14341:20120607:205729.424 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.424 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.424 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.424 End of DBget_nextid():26576 table:'items' recid:'itemid'
 14341:20120607:205729.424 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) values (26576,'Mounted filesystem discovery','vfs.fs.discovery',10175,0,4,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26479,1,'{#FSTYPE}:@File systems for discovery','Discovery of file systems of different types as defined in global regular expression "File systems for discovery".',0,30339),(26577,'Free disk space on $1 (percentage)','vfs.fs.size[{#FSNAME},pfree]',10175,0,0,0,600,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26481,2,'','',0,30339);
 14341:20120607:205729.424 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid between 26576 and 26577 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]
 14341:20120607:205729.424 In DBget_nextid() tablename:'items_applications'
 14341:20120607:205729.425 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.425 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.425 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.425 End of DBget_nextid():8759 table:'items_applications' recid:'itemappid'
 14341:20120607:205729.425 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (8759,26577,586);
 14341:20120607:205729.425 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 i.itemid=26577]
 14341:20120607:205729.425 In DBget_nextid() tablename:'item_discovery'
 14341:20120607:205729.425 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.425 query [txnlev:1] [update ids set nextid=nextid+3 where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.425 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.426 End of DBget_nextid():1063 table:'item_discovery' recid:'itemdiscoveryid'
 14341:20120607:205729.426 query [txnlev:1] [insert into item_discovery (itemdiscoveryid,itemid,parent_itemid) values (1063,26577,26572),(1064,26577,26574),(1065,26577,26576);
 14341:20120607:205729.426 End of DBcopy_template_items()
 14341:20120607:205729.426 In DBcopy_template_triggers()
 14341:20120607:205729.426 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=10161]
 14341:20120607:205729.426 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=10175 and t.description='Free disk space is less than 10% on volume {#FSNAME}']
 14341:20120607:205729.426 In DBget_nextid() tablename:'triggers'
 14341:20120607:205729.426 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.426 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.426 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.427 End of DBget_nextid():220972 table:'triggers' recid:'triggerid'
 14341:20120607:205729.427 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=10175 where tf.itemid=ti.itemid and tf.triggerid=220637]
 14341:20120607:205729.427 In DBget_nextid() tablename:'functions'
 14341:20120607:205729.427 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.427 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.427 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.427 End of DBget_nextid():14881 table:'functions' recid:'functionid'
 14341:20120607:205729.427 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (220972,'Free disk space is less than 10% on volume {#FSNAME}',2,0,'','',0,0,1,220637,2);
 14341:20120607:205729.427 query [txnlev:1] [select triggerid,templateid from triggers where triggerid=220972]
 14341:20120607:205729.428 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=220972]
 14341:20120607:205729.428 End of DBcopy_template_triggers():SUCCEED
 14341:20120607:205729.428 In DBcopy_template_graphs()
 14341:20120607:205729.428 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=10161]
 14341:20120607:205729.428 End of DBcopy_template_graphs():SUCCEED
 14341:20120607:205729.428 End of DBcopy_template_elements():SUCCEED
 14341:20120607:205729.428 End of op_template_add()
 14341:20120607:205729.428 In op_groups_add()
 14341:20120607:205729.428 In add_discovered_host() eventid:2248798
 14341:20120607:205729.428 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=2 order by ds.dserviceid]
 14341:20120607:205729.428 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=2 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205729.428 In DBadd_interface()
 14341:20120607:205729.428 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10175 and type=1]
 14341:20120607:205729.429 In substitute_simple_macros() data:'10050'
 14341:20120607:205729.429 End of DBadd_interface():30339
 14341:20120607:205729.429 End of add_discovered_host()
 14341:20120607:205729.429 In add_discovered_host_groups()
 14341:20120607:205729.429 query [txnlev:1] [select groupid from hosts_groups where hostid=10175 and groupid=21]
 14341:20120607:205729.429 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205729.429 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.429 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.429 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.429 End of DBget_nextid():438 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205729.429 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (438,10175,21);
 14341:20120607:205729.429 End of add_discovered_host_groups()
 14341:20120607:205729.429 End of op_groups_add()
 14341:20120607:205729.429 End of execute_operations()
 14341:20120607:205729.429 End of process_actions()
 14341:20120607:205729.429 End of process_event():SUCCEED
 14341:20120607:205729.429 In process_event() eventid:0 object:2 objectid:2 value:0 value_changed:0
 14341:20120607:205729.429 In add_trigger_info()
 14341:20120607:205729.429 End of add_trigger_info():SUCCEED
 14341:20120607:205729.429 In DBget_nextid() tablename:'events'
 14341:20120607:205729.429 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.429 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.430 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.430 End of DBget_nextid():2248799 table:'events' recid:'eventid'
 14341:20120607:205729.430 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248799,1,2,2,1339091849,0,0,0)]
 14341:20120607:205729.430 In process_actions() eventid:2248799
 14341:20120607:205729.430 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.430 In check_action_conditions() actionid:42
 14341:20120607:205729.430 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.430 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.430 In check_discovery_condition()
 14341:20120607:205729.430 End of check_discovery_condition():FAIL
 14341:20120607:205729.430 End of check_action_condition():FAIL
 14341:20120607:205729.430 End of check_action_conditions():FAIL
 14341:20120607:205729.430 End of process_actions()
 14341:20120607:205729.430 End of process_event():SUCCEED
 14341:20120607:205729.430 End of discovery_update_service()
 14341:20120607:205729.430 query [txnlev:1] [commit;]
 14341:20120607:205729.450 End of process_check()
 14341:20120607:205729.450 query [txnlev:1] [begin;]
 14341:20120607:205729.450 In discovery_update_host()
 14341:20120607:205729.450 query [txnlev:1] [update dhosts set status=0,lastup=1339091849,lastdown=0 where dhostid=2]
 14341:20120607:205729.451 In process_event() eventid:0 object:1 objectid:2 value:2 value_changed:0
 14341:20120607:205729.451 In add_trigger_info()
 14341:20120607:205729.451 End of add_trigger_info():SUCCEED
 14341:20120607:205729.451 In DBget_nextid() tablename:'events'
 14341:20120607:205729.451 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.451 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.451 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.452 End of DBget_nextid():2248800 table:'events' recid:'eventid'
 14341:20120607:205729.452 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248800,1,1,2,1339091849,0,2,0)]
 14341:20120607:205729.452 In process_actions() eventid:2248800
 14341:20120607:205729.452 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.452 In check_action_conditions() actionid:42
 14341:20120607:205729.452 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.452 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.452 In check_discovery_condition()
 14341:20120607:205729.452 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.452 End of check_action_condition():SUCCEED
 14341:20120607:205729.452 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205729.452 In check_discovery_condition()
 14341:20120607:205729.452 End of check_discovery_condition():FAIL
 14341:20120607:205729.452 End of check_action_condition():FAIL
 14341:20120607:205729.452 End of check_action_conditions():FAIL
 14341:20120607:205729.453 End of process_actions()
 14341:20120607:205729.453 End of process_event():SUCCEED
 14341:20120607:205729.453 In process_event() eventid:0 object:1 objectid:2 value:0 value_changed:0
 14341:20120607:205729.453 In add_trigger_info()
 14341:20120607:205729.453 End of add_trigger_info():SUCCEED
 14341:20120607:205729.453 In DBget_nextid() tablename:'events'
 14341:20120607:205729.453 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.453 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.453 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.453 End of DBget_nextid():2248801 table:'events' recid:'eventid'
 14341:20120607:205729.453 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248801,1,1,2,1339091849,0,0,0)]
 14341:20120607:205729.453 In process_actions() eventid:2248801
 14341:20120607:205729.453 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.453 In check_action_conditions() actionid:42
 14341:20120607:205729.453 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.453 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.453 In check_discovery_condition()
 14341:20120607:205729.453 End of check_discovery_condition():FAIL
 14341:20120607:205729.453 End of check_action_condition():FAIL
 14341:20120607:205729.453 End of check_action_conditions():FAIL
 14341:20120607:205729.453 End of process_actions()
 14341:20120607:205729.453 End of process_event():SUCCEED
 14341:20120607:205729.453 End of discovery_update_host()
 14341:20120607:205729.453 query [txnlev:1] [commit;]
 14341:20120607:205729.454 process_rule() IP:'10.20.0.12'
 14341:20120607:205729.454 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205729.454 In process_check()
 14341:20120607:205729.454 process_check() port:10050
 14341:20120607:205729.454 In discover_service()
 14341:20120607:205729.454 In get_value_agent() host:'' addr:'10.20.0.12' key:'system.uname'
 14341:20120607:205729.456 Sending [system.uname
 14341:20120607:205729.457 get value from agent result: 'Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205729.457 End of discover_service():SUCCEED
 14341:20120607:205729.457 query [txnlev:1] [begin;]
 14341:20120607:205729.457 In discovery_update_service() ip:'10.20.0.12' port:10050 status:0
 14341:20120607:205729.457 In discovery_register_host() ip:'10.20.0.12' status:0 value:'Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205729.457 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=8 and ds.ip='10.20.0.12' order by dh.dhostid]
 14341:20120607:205729.458 new host discovered at 10.20.0.12
 14341:20120607:205729.458 In DCget_nextid() table:'dhosts' num:1
 14341:20120607:205729.458 End of DCget_nextid() table:'dhosts' [3:3]
 14341:20120607:205729.458 query [txnlev:1] [insert into dhosts (dhostid,druleid) values (3,8)]
 14341:20120607:205729.458 End of discovery_register_host()
 14341:20120607:205729.458 In discovery_register_service() ip:'10.20.0.12' port:10050 key:'system.uname'
 14341:20120607:205729.458 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.12' and port=10050]
 14341:20120607:205729.458 new service discovered on port 10050
 14341:20120607:205729.459 In DCget_nextid() table:'dservices' num:1
 14341:20120607:205729.459 End of DCget_nextid() table:'dservices' [3:3]
 14341:20120607:205729.459 query [txnlev:1] [insert into dservices (dserviceid,dhostid,dcheckid,type,key_,ip,dns,port,status) values (3,3,39,9,'system.uname','10.20.0.12','it3',10050,1)]
 14341:20120607:205729.459 End of discovery_register_service()
 14341:20120607:205729.459 query [txnlev:1] [update dservices set status=0,lastup=1339091849,lastdown=0,value='Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32' where dserviceid=3]
 14341:20120607:205729.459 In process_event() eventid:0 object:2 objectid:3 value:2 value_changed:0
 14341:20120607:205729.459 In add_trigger_info()
 14341:20120607:205729.459 End of add_trigger_info():SUCCEED
 14341:20120607:205729.459 In DBget_nextid() tablename:'events'
 14341:20120607:205729.460 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.460 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.460 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.460 End of DBget_nextid():2248802 table:'events' recid:'eventid'
 14341:20120607:205729.461 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248802,1,2,3,1339091849,0,2,0)]
 14341:20120607:205729.461 In process_actions() eventid:2248802
 14341:20120607:205729.461 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.461 In check_action_conditions() actionid:42
 14341:20120607:205729.461 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.461 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.461 In check_discovery_condition()
 14341:20120607:205729.461 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.461 End of check_action_condition():SUCCEED
 14341:20120607:205729.461 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205729.461 In check_discovery_condition()
 14341:20120607:205729.461 query [txnlev:1] [select value from dservices where dserviceid=3]
 14341:20120607:205729.462 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.462 End of check_action_condition():SUCCEED
 14341:20120607:205729.462 In check_action_condition() actionid:42 conditionid:463 cond.value:'8'
 14341:20120607:205729.462 In check_discovery_condition()
 14341:20120607:205729.462 query [txnlev:1] [select h.druleid from dhosts h,dservices s where h.dhostid=s.dhostid and h.druleid=8 and s.dserviceid=3]
 14341:20120607:205729.462 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.462 End of check_action_condition():SUCCEED
 14341:20120607:205729.462 End of check_action_conditions():SUCCEED
 14341:20120607:205729.462 In DBstart_escalation()
 14341:20120607:205729.462 In DCget_nextid() table:'escalations' num:1
 14341:20120607:205729.462 End of DCget_nextid() table:'escalations' [3:3]
 14341:20120607:205729.462 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (3,42,null,2248802,0)]
 14341:20120607:205729.462 End of DBstart_escalation()
 14341:20120607:205729.463 In execute_operations() actionid:42
 14341:20120607:205729.463 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=42]
 14341:20120607:205729.463 In op_template_add()
 14341:20120607:205729.463 In add_discovered_host() eventid:2248802
 14341:20120607:205729.463 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=3 order by ds.dserviceid]
 14341:20120607:205729.463 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=3 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205729.464 In DBget_nextid() tablename:'hosts'
 14341:20120607:205729.464 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.464 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.464 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205729.465 End of DBget_nextid():10176 table:'hosts' recid:'hostid'
 14341:20120607:205729.465 In DBget_unique_hostname_by_sample() sample:'it3'
 14341:20120607:205729.465 query [txnlev:1] [select host from hosts where host like 'it3%' escape '!' and hostid between 0 and 99999999999999]
 14341:20120607:205729.465 End of DBget_unique_hostname_by_sample():'it3'
 14341:20120607:205729.465 query [txnlev:1] [insert into hosts (hostid,proxy_hostid,host,name) values (10176,null,'it3','it3')]
 14341:20120607:205729.465 In DBadd_interface()
 14341:20120607:205729.465 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10176 and type=1]
 14341:20120607:205729.466 In DBget_nextid() tablename:'interface'
 14341:20120607:205729.466 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.466 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.466 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205729.466 End of DBget_nextid():30340 table:'interface' recid:'interfaceid'
 14341:20120607:205729.466 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (30340,10176,1,1,1,'10.20.0.12','it3',10050)]
 14341:20120607:205729.467 End of DBadd_interface():30340
 14341:20120607:205729.467 In add_discovered_host_groups()
 14341:20120607:205729.467 query [txnlev:1] [select groupid from hosts_groups where hostid=10176 and groupid=5]
 14341:20120607:205729.467 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205729.467 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.467 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.467 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.468 End of DBget_nextid():439 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205729.468 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (439,10176,5);
 14341:20120607:205729.468 End of add_discovered_host_groups()
 14341:20120607:205729.468 End of add_discovered_host()
 14341:20120607:205729.468 In DBcopy_template_elements()
 14341:20120607:205729.468 query [txnlev:1] [select templateid from hosts_templates where hostid=10176]
 14341:20120607:205729.468 In validate_linked_templates()
 14341:20120607:205729.468 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=10161 and not i2.hostid=10161 limit 1]
 14341:20120607:205729.469 query [txnlev:1] [select t1.description,h1.host,t2.description,h2.host 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=10161 and not i2.hostid=10161 and h2.status=3 limit 1]
 14341:20120607:205729.469 End of validate_linked_templates():SUCCEED
 14341:20120607:205729.470 In validate_host()
 14341:20120607:205729.470 In validate_inventory_links()
 14341:20120607:205729.470 query [txnlev:1] [select inventory_link,count(*) from items where inventory_link<>0 and hostid=10161 group by inventory_link having count(*)>1 limit 1]
 14341:20120607:205729.470 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=10161 and i.hostid=10176 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10161 and items.key_=i.key_) limit 1]
 14341:20120607:205729.470 End of validate_inventory_links():SUCCEED
 14341:20120607:205729.470 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=10161]
 14341:20120607:205729.471 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10176 and t.hostid=10161 limit 1]
 14341:20120607:205729.471 query [txnlev:1] [select type,interfaceid from interface where hostid=10176 and type in (1,2,3,4) and main=1 and interfaceid between 0 and 99999999999999]
 14341:20120607:205729.471 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,11,15) and hostid=10161]
 14341:20120607:205729.472 In validate_host():SUCCEED
 14341:20120607:205729.472 In DBget_nextid() tablename:'hosts_templates'
 14341:20120607:205729.472 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.472 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.472 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205729.473 End of DBget_nextid():295 table:'hosts_templates' recid:'hosttemplateid'
 14341:20120607:205729.473 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (295,10176,10161)]
 14341:20120607:205729.473 In DBcopy_template_applications()
 14341:20120607:205729.473 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=10176 where ta.hostid=10161 order by ha.applicationid]
 14341:20120607:205729.474 In DBget_nextid() tablename:'applications'
 14341:20120607:205729.474 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.474 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.474 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205729.474 End of DBget_nextid():587 table:'applications' recid:'applicationid'
 14341:20120607:205729.474 query [txnlev:1] [insert into applications (applicationid,hostid,name,templateid) values (587,10176,'Filesystems',548);
 14341:20120607:205729.475 End of DBcopy_template_applications()
 14341:20120607:205729.475 In DBcopy_template_items()
 14341:20120607:205729.475 query [txnlev:1] [select type,interfaceid from interface where hostid=10176 and type in (1,2,3,4) and main=1]
 14341:20120607:205729.475 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,hi.itemid from items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10176 where ti.hostid=10161 order by hi.itemid]
 14341:20120607:205729.476 In DBget_nextid() tablename:'items'
 14341:20120607:205729.476 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.476 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.477 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205729.477 End of DBget_nextid():26578 table:'items' recid:'itemid'
 14341:20120607:205729.477 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) values (26578,'Mounted filesystem discovery','vfs.fs.discovery',10176,0,4,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26479,1,'{#FSTYPE}:@File systems for discovery','Discovery of file systems of different types as defined in global regular expression "File systems for discovery".',0,30340),(26579,'Free disk space on $1 (percentage)','vfs.fs.size[{#FSNAME},pfree]',10176,0,0,0,600,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26481,2,'','',0,30340);
 14341:20120607:205729.478 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid between 26578 and 26579 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]
 14341:20120607:205729.478 In DBget_nextid() tablename:'items_applications'
 14341:20120607:205729.478 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.478 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.479 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205729.479 End of DBget_nextid():8760 table:'items_applications' recid:'itemappid'
 14341:20120607:205729.479 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (8760,26579,587);
 14341:20120607:205729.479 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 i.itemid=26579]
 14341:20120607:205729.480 In DBget_nextid() tablename:'item_discovery'
 14341:20120607:205729.480 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.480 query [txnlev:1] [update ids set nextid=nextid+4 where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.480 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205729.481 End of DBget_nextid():1066 table:'item_discovery' recid:'itemdiscoveryid'
 14341:20120607:205729.481 query [txnlev:1] [insert into item_discovery (itemdiscoveryid,itemid,parent_itemid) values (1066,26579,26572),(1067,26579,26574),(1068,26579,26576),(1069,26579,26578);
 14341:20120607:205729.481 End of DBcopy_template_items()
 14341:20120607:205729.481 In DBcopy_template_triggers()
 14341:20120607:205729.481 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=10161]
 14341:20120607:205729.482 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=10176 and t.description='Free disk space is less than 10% on volume {#FSNAME}']
 14341:20120607:205729.482 In DBget_nextid() tablename:'triggers'
 14341:20120607:205729.482 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.482 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.483 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205729.483 End of DBget_nextid():220973 table:'triggers' recid:'triggerid'
 14341:20120607:205729.483 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=10176 where tf.itemid=ti.itemid and tf.triggerid=220637]
 14341:20120607:205729.483 In DBget_nextid() tablename:'functions'
 14341:20120607:205729.483 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.484 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.484 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205729.484 End of DBget_nextid():14882 table:'functions' recid:'functionid'
 14341:20120607:205729.484 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (220973,'Free disk space is less than 10% on volume {#FSNAME}',2,0,'','',0,0,1,220637,2);
 14341:20120607:205729.485 query [txnlev:1] [select triggerid,templateid from triggers where triggerid=220973]
 14341:20120607:205729.485 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=220973]
 14341:20120607:205729.485 End of DBcopy_template_triggers():SUCCEED
 14341:20120607:205729.485 In DBcopy_template_graphs()
 14341:20120607:205729.486 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=10161]
 14341:20120607:205729.486 End of DBcopy_template_graphs():SUCCEED
 14341:20120607:205729.486 End of DBcopy_template_elements():SUCCEED
 14341:20120607:205729.486 End of op_template_add()
 14341:20120607:205729.486 In op_groups_add()
 14341:20120607:205729.486 In add_discovered_host() eventid:2248802
 14341:20120607:205729.486 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=3 order by ds.dserviceid]
 14341:20120607:205729.487 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=3 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205729.487 In DBadd_interface()
 14341:20120607:205729.487 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10176 and type=1]
 14341:20120607:205729.487 In substitute_simple_macros() data:'10050'
 14341:20120607:205729.487 End of DBadd_interface():30340
 14341:20120607:205729.488 End of add_discovered_host()
 14341:20120607:205729.488 In add_discovered_host_groups()
 14341:20120607:205729.488 query [txnlev:1] [select groupid from hosts_groups where hostid=10176 and groupid=21]
 14341:20120607:205729.488 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205729.488 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.488 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.489 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205729.489 End of DBget_nextid():440 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205729.489 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (440,10176,21);
 14341:20120607:205729.489 End of add_discovered_host_groups()
 14341:20120607:205729.489 End of op_groups_add()
 14341:20120607:205729.489 End of execute_operations()
 14341:20120607:205729.489 End of process_actions()
 14341:20120607:205729.490 End of process_event():SUCCEED
 14341:20120607:205729.490 In process_event() eventid:0 object:2 objectid:3 value:0 value_changed:0
 14341:20120607:205729.490 In add_trigger_info()
 14341:20120607:205729.490 End of add_trigger_info():SUCCEED
 14341:20120607:205729.490 In DBget_nextid() tablename:'events'
 14341:20120607:205729.490 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.490 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.490 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.490 End of DBget_nextid():2248803 table:'events' recid:'eventid'
 14341:20120607:205729.490 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248803,1,2,3,1339091849,0,0,0)]
 14341:20120607:205729.491 In process_actions() eventid:2248803
 14341:20120607:205729.491 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.491 In check_action_conditions() actionid:42
 14341:20120607:205729.491 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.491 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.491 In check_discovery_condition()
 14341:20120607:205729.491 End of check_discovery_condition():FAIL
 14341:20120607:205729.491 End of check_action_condition():FAIL
 14341:20120607:205729.491 End of check_action_conditions():FAIL
 14341:20120607:205729.491 End of process_actions()
 14341:20120607:205729.491 End of process_event():SUCCEED
 14341:20120607:205729.491 End of discovery_update_service()
 14341:20120607:205729.491 query [txnlev:1] [commit;]
 14341:20120607:205729.492 End of process_check()
 14341:20120607:205729.492 query [txnlev:1] [begin;]
 14341:20120607:205729.492 In discovery_update_host()
 14341:20120607:205729.492 query [txnlev:1] [update dhosts set status=0,lastup=1339091849,lastdown=0 where dhostid=3]
 14341:20120607:205729.492 In process_event() eventid:0 object:1 objectid:3 value:2 value_changed:0
 14341:20120607:205729.492 In add_trigger_info()
 14341:20120607:205729.492 End of add_trigger_info():SUCCEED
 14341:20120607:205729.492 In DBget_nextid() tablename:'events'
 14341:20120607:205729.492 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.493 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.493 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.493 End of DBget_nextid():2248804 table:'events' recid:'eventid'
 14341:20120607:205729.493 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248804,1,1,3,1339091849,0,2,0)]
 14341:20120607:205729.493 In process_actions() eventid:2248804
 14341:20120607:205729.493 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.494 In check_action_conditions() actionid:42
 14341:20120607:205729.494 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.494 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.494 In check_discovery_condition()
 14341:20120607:205729.494 End of check_discovery_condition():SUCCEED
 14341:20120607:205729.494 End of check_action_condition():SUCCEED
 14341:20120607:205729.494 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205729.494 In check_discovery_condition()
 14341:20120607:205729.494 End of check_discovery_condition():FAIL
 14341:20120607:205729.494 End of check_action_condition():FAIL
 14341:20120607:205729.494 End of check_action_conditions():FAIL
 14341:20120607:205729.494 End of process_actions()
 14341:20120607:205729.494 End of process_event():SUCCEED
 14341:20120607:205729.494 In process_event() eventid:0 object:1 objectid:3 value:0 value_changed:0
 14341:20120607:205729.494 In add_trigger_info()
 14341:20120607:205729.494 End of add_trigger_info():SUCCEED
 14341:20120607:205729.494 In DBget_nextid() tablename:'events'
 14341:20120607:205729.494 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.495 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.495 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205729.495 End of DBget_nextid():2248805 table:'events' recid:'eventid'
 14341:20120607:205729.495 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248805,1,1,3,1339091849,0,0,0)]
 14341:20120607:205729.495 In process_actions() eventid:2248805
 14341:20120607:205729.495 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205729.495 In check_action_conditions() actionid:42
 14341:20120607:205729.495 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205729.495 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205729.496 In check_discovery_condition()
 14341:20120607:205729.496 End of check_discovery_condition():FAIL
 14341:20120607:205729.496 End of check_action_condition():FAIL
 14341:20120607:205729.496 End of check_action_conditions():FAIL
 14341:20120607:205729.496 End of process_actions()
 14341:20120607:205729.496 End of process_event():SUCCEED
 14341:20120607:205729.496 End of discovery_update_host()
 14341:20120607:205729.496 query [txnlev:1] [commit;]
 14341:20120607:205729.500 process_rule() IP:'10.20.0.13'
 14341:20120607:205732.500 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205732.500 In process_check()
 14341:20120607:205732.500 process_check() port:10050
 14341:20120607:205732.500 In discover_service()
 14341:20120607:205732.501 In get_value_agent() host:'' addr:'10.20.0.13' key:'system.uname'
 14341:20120607:205735.501 discovery: item [system.uname] error: Get value from agent failed: cannot connect to [[10.20.0.13]:10050]: [4] Interrupted system call
 14341:20120607:205735.501 End of discover_service():FAIL
 14341:20120607:205735.501 query [txnlev:1] [begin;]
 14341:20120607:205735.501 In discovery_update_service() ip:'10.20.0.13' port:10050 status:1
 14341:20120607:205735.501 In discovery_register_host() ip:'10.20.0.13' status:1 value:''
 14341:20120607:205735.501 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=8 and ds.ip='10.20.0.13' order by dh.dhostid]
 14341:20120607:205735.501 End of discovery_register_host()
 14341:20120607:205735.502 End of discovery_update_service()
 14341:20120607:205735.502 query [txnlev:1] [commit;]
 14341:20120607:205735.502 End of process_check()
 14341:20120607:205735.502 query [txnlev:1] [begin;]
 14341:20120607:205735.502 In discovery_update_host()
 14341:20120607:205735.502 End of discovery_update_host()
 14341:20120607:205735.502 query [txnlev:1] [commit;]
 14341:20120607:205735.502 process_rule() IP:'10.20.0.14'
 14341:20120607:205738.502 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205738.502 In process_check()
 14341:20120607:205738.503 process_check() port:10050
 14341:20120607:205738.503 In discover_service()
 14341:20120607:205738.503 In get_value_agent() host:'' addr:'10.20.0.14' key:'system.uname'
 14341:20120607:205741.503 discovery: item [system.uname] error: Get value from agent failed: cannot connect to [[10.20.0.14]:10050]: [4] Interrupted system call
 14341:20120607:205741.503 End of discover_service():FAIL
 14341:20120607:205741.503 query [txnlev:1] [begin;]
 14341:20120607:205741.503 In discovery_update_service() ip:'10.20.0.14' port:10050 status:1
 14341:20120607:205741.503 In discovery_register_host() ip:'10.20.0.14' status:1 value:''
 14341:20120607:205741.503 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=8 and ds.ip='10.20.0.14' order by dh.dhostid]
 14341:20120607:205741.504 End of discovery_register_host()
 14341:20120607:205741.504 End of discovery_update_service()
 14341:20120607:205741.504 query [txnlev:1] [commit;]
 14341:20120607:205741.504 End of process_check()
 14341:20120607:205741.504 query [txnlev:1] [begin;]
 14341:20120607:205741.504 In discovery_update_host()
 14341:20120607:205741.504 End of discovery_update_host()
 14341:20120607:205741.504 query [txnlev:1] [commit;]
 14341:20120607:205741.504 process_rule() IP:'10.20.0.15'
 14341:20120607:205741.505 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205741.505 In process_check()
 14341:20120607:205741.505 process_check() port:10050
 14341:20120607:205741.505 In discover_service()
 14341:20120607:205741.505 In get_value_agent() host:'' addr:'10.20.0.15' key:'system.uname'
 14341:20120607:205741.512 Sending [system.uname
 14341:20120607:205741.513 get value from agent result: 'Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205741.513 End of discover_service():SUCCEED
 14341:20120607:205741.513 query [txnlev:1] [begin;]
 14341:20120607:205741.513 In discovery_update_service() ip:'10.20.0.15' port:10050 status:0
 14341:20120607:205741.513 In discovery_register_host() ip:'10.20.0.15' status:0 value:'Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205741.513 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=8 and ds.ip='10.20.0.15' order by dh.dhostid]
 14341:20120607:205741.513 new host discovered at 10.20.0.15
 14341:20120607:205741.514 In DCget_nextid() table:'dhosts' num:1
 14341:20120607:205741.514 End of DCget_nextid() table:'dhosts' [4:4]
 14341:20120607:205741.514 query [txnlev:1] [insert into dhosts (dhostid,druleid) values (4,8)]
 14341:20120607:205741.514 End of discovery_register_host()
 14341:20120607:205741.514 In discovery_register_service() ip:'10.20.0.15' port:10050 key:'system.uname'
 14341:20120607:205741.514 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.15' and port=10050]
 14341:20120607:205741.514 new service discovered on port 10050
 14341:20120607:205741.514 In DCget_nextid() table:'dservices' num:1
 14341:20120607:205741.514 End of DCget_nextid() table:'dservices' [4:4]
 14341:20120607:205741.514 query [txnlev:1] [insert into dservices (dserviceid,dhostid,dcheckid,type,key_,ip,dns,port,status) values (4,4,39,9,'system.uname','10.20.0.15','sskd',10050,1)]
 14341:20120607:205741.514 End of discovery_register_service()
 14341:20120607:205741.514 query [txnlev:1] [update dservices set status=0,lastup=1339091861,lastdown=0,value='Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32' where dserviceid=4]
 14341:20120607:205741.514 In process_event() eventid:0 object:2 objectid:4 value:2 value_changed:0
 14341:20120607:205741.514 In add_trigger_info()
 14341:20120607:205741.515 End of add_trigger_info():SUCCEED
 14341:20120607:205741.515 In DBget_nextid() tablename:'events'
 14341:20120607:205741.515 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.515 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.515 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.515 End of DBget_nextid():2248814 table:'events' recid:'eventid'
 14341:20120607:205741.515 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248814,1,2,4,1339091861,0,2,0)]
 14341:20120607:205741.515 In process_actions() eventid:2248814
 14341:20120607:205741.515 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205741.515 In check_action_conditions() actionid:42
 14341:20120607:205741.515 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205741.515 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205741.515 In check_discovery_condition()
 14341:20120607:205741.515 End of check_discovery_condition():SUCCEED
 14341:20120607:205741.515 End of check_action_condition():SUCCEED
 14341:20120607:205741.515 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205741.515 In check_discovery_condition()
 14341:20120607:205741.515 query [txnlev:1] [select value from dservices where dserviceid=4]
 14341:20120607:205741.516 End of check_discovery_condition():SUCCEED
 14341:20120607:205741.516 End of check_action_condition():SUCCEED
 14341:20120607:205741.516 In check_action_condition() actionid:42 conditionid:463 cond.value:'8'
 14341:20120607:205741.516 In check_discovery_condition()
 14341:20120607:205741.516 query [txnlev:1] [select h.druleid from dhosts h,dservices s where h.dhostid=s.dhostid and h.druleid=8 and s.dserviceid=4]
 14341:20120607:205741.516 End of check_discovery_condition():SUCCEED
 14341:20120607:205741.516 End of check_action_condition():SUCCEED
 14341:20120607:205741.516 End of check_action_conditions():SUCCEED
 14341:20120607:205741.516 In DBstart_escalation()
 14341:20120607:205741.516 In DCget_nextid() table:'escalations' num:1
 14341:20120607:205741.516 End of DCget_nextid() table:'escalations' [4:4]
 14341:20120607:205741.516 query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (4,42,null,2248814,0)]
 14341:20120607:205741.516 End of DBstart_escalation()
 14341:20120607:205741.516 In execute_operations() actionid:42
 14341:20120607:205741.516 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=42]
 14341:20120607:205741.516 In op_template_add()
 14341:20120607:205741.516 In add_discovered_host() eventid:2248814
 14341:20120607:205741.516 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=4 order by ds.dserviceid]
 14341:20120607:205741.516 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=4 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205741.517 In DBget_nextid() tablename:'hosts'
 14341:20120607:205741.517 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205741.517 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205741.517 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
 14341:20120607:205741.517 End of DBget_nextid():10177 table:'hosts' recid:'hostid'
 14341:20120607:205741.517 In DBget_unique_hostname_by_sample() sample:'sskd'
 14341:20120607:205741.517 query [txnlev:1] [select host from hosts where host like 'sskd%' escape '!' and hostid between 0 and 99999999999999]
 14341:20120607:205741.517 End of DBget_unique_hostname_by_sample():'sskd'
 14341:20120607:205741.517 query [txnlev:1] [insert into hosts (hostid,proxy_hostid,host,name) values (10177,null,'sskd','sskd')]
 14341:20120607:205741.517 In DBadd_interface()
 14341:20120607:205741.517 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10177 and type=1]
 14341:20120607:205741.517 In DBget_nextid() tablename:'interface'
 14341:20120607:205741.517 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205741.518 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205741.518 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='interface' and field_name='interfaceid']
 14341:20120607:205741.518 End of DBget_nextid():30341 table:'interface' recid:'interfaceid'
 14341:20120607:205741.518 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (30341,10177,1,1,1,'10.20.0.15','sskd',10050)]
 14341:20120607:205741.518 End of DBadd_interface():30341
 14341:20120607:205741.518 In add_discovered_host_groups()
 14341:20120607:205741.518 query [txnlev:1] [select groupid from hosts_groups where hostid=10177 and groupid=5]
 14341:20120607:205741.518 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205741.518 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205741.518 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205741.518 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205741.518 End of DBget_nextid():441 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205741.518 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (441,10177,5);
 14341:20120607:205741.518 End of add_discovered_host_groups()
 14341:20120607:205741.518 End of add_discovered_host()
 14341:20120607:205741.518 In DBcopy_template_elements()
 14341:20120607:205741.519 query [txnlev:1] [select templateid from hosts_templates where hostid=10177]
 14341:20120607:205741.519 In validate_linked_templates()
 14341:20120607:205741.519 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=10161 and not i2.hostid=10161 limit 1]
 14341:20120607:205741.519 query [txnlev:1] [select t1.description,h1.host,t2.description,h2.host 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=10161 and not i2.hostid=10161 and h2.status=3 limit 1]
 14341:20120607:205741.520 End of validate_linked_templates():SUCCEED
 14341:20120607:205741.520 In validate_host()
 14341:20120607:205741.520 In validate_inventory_links()
 14341:20120607:205741.520 query [txnlev:1] [select inventory_link,count(*) from items where inventory_link<>0 and hostid=10161 group by inventory_link having count(*)>1 limit 1]
 14341:20120607:205741.520 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=10161 and i.hostid=10177 and ti.inventory_link<>0 and not exists (select * from items where items.hostid=10161 and items.key_=i.key_) limit 1]
 14341:20120607:205741.520 End of validate_inventory_links():SUCCEED
 14341:20120607:205741.520 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=10161]
 14341:20120607:205741.520 query [txnlev:1] [select i.key_ from items i,items t where i.key_=t.key_ and i.flags<>t.flags and i.hostid=10177 and t.hostid=10161 limit 1]
 14341:20120607:205741.520 query [txnlev:1] [select type,interfaceid from interface where hostid=10177 and type in (1,2,3,4) and main=1 and interfaceid between 0 and 99999999999999]
 14341:20120607:205741.521 query [txnlev:1] [select distinct type from items where type not in (2,5,7,8,11,15) and hostid=10161]
 14341:20120607:205741.521 In validate_host():SUCCEED
 14341:20120607:205741.521 In DBget_nextid() tablename:'hosts_templates'
 14341:20120607:205741.521 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205741.521 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205741.521 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
 14341:20120607:205741.521 End of DBget_nextid():296 table:'hosts_templates' recid:'hosttemplateid'
 14341:20120607:205741.521 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (296,10177,10161)]
 14341:20120607:205741.521 In DBcopy_template_applications()
 14341:20120607:205741.521 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=10177 where ta.hostid=10161 order by ha.applicationid]
 14341:20120607:205741.522 In DBget_nextid() tablename:'applications'
 14341:20120607:205741.522 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205741.522 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205741.522 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='applications' and field_name='applicationid']
 14341:20120607:205741.522 End of DBget_nextid():588 table:'applications' recid:'applicationid'
 14341:20120607:205741.522 query [txnlev:1] [insert into applications (applicationid,hostid,name,templateid) values (588,10177,'Filesystems',548);
 14341:20120607:205741.522 End of DBcopy_template_applications()
 14341:20120607:205741.522 In DBcopy_template_items()
 14341:20120607:205741.522 query [txnlev:1] [select type,interfaceid from interface where hostid=10177 and type in (1,2,3,4) and main=1]
 14341:20120607:205741.522 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,hi.itemid from items ti left join items hi on hi.key_=ti.key_ and hi.hostid=10177 where ti.hostid=10161 order by hi.itemid]
 14341:20120607:205741.523 In DBget_nextid() tablename:'items'
 14341:20120607:205741.523 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205741.523 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205741.523 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items' and field_name='itemid']
 14341:20120607:205741.523 End of DBget_nextid():26580 table:'items' recid:'itemid'
 14341:20120607:205741.523 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) values (26580,'Mounted filesystem discovery','vfs.fs.discovery',10177,0,4,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26479,1,'{#FSTYPE}:@File systems for discovery','Discovery of file systems of different types as defined in global regular expression "File systems for discovery".',0,30341),(26581,'Free disk space on $1 (percentage)','vfs.fs.size[{#FSNAME},pfree]',10177,0,0,0,600,'',7,365,0,'','%',0,0,'1','',null,'','','','','',0,'','',0,'','','','',26481,2,'','',0,30341);
 14341:20120607:205741.524 query [txnlev:1] [select hi.itemid,ha.applicationid from items_applications tia join items hi on hi.templateid=tia.itemid and hi.itemid between 26580 and 26581 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]
 14341:20120607:205741.524 In DBget_nextid() tablename:'items_applications'
 14341:20120607:205741.524 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205741.524 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205741.524 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='items_applications' and field_name='itemappid']
 14341:20120607:205741.524 End of DBget_nextid():8761 table:'items_applications' recid:'itemappid'
 14341:20120607:205741.524 query [txnlev:1] [insert into items_applications (itemappid,itemid,applicationid) values (8761,26581,588);
 14341:20120607:205741.525 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 i.itemid=26581]
 14341:20120607:205741.525 In DBget_nextid() tablename:'item_discovery'
 14341:20120607:205741.525 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205741.525 query [txnlev:1] [update ids set nextid=nextid+5 where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205741.525 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='item_discovery' and field_name='itemdiscoveryid']
 14341:20120607:205741.525 End of DBget_nextid():1070 table:'item_discovery' recid:'itemdiscoveryid'
 14341:20120607:205741.525 query [txnlev:1] [insert into item_discovery (itemdiscoveryid,itemid,parent_itemid) values (1070,26581,26572),(1071,26581,26574),(1072,26581,26576),(1073,26581,26578),(1074,26581,26580);
 14341:20120607:205741.525 End of DBcopy_template_items()
 14341:20120607:205741.525 In DBcopy_template_triggers()
 14341:20120607:205741.525 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=10161]
 14341:20120607:205741.526 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=10177 and t.description='Free disk space is less than 10% on volume {#FSNAME}']
 14341:20120607:205741.526 In DBget_nextid() tablename:'triggers'
 14341:20120607:205741.526 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205741.526 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205741.526 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid']
 14341:20120607:205741.526 End of DBget_nextid():220974 table:'triggers' recid:'triggerid'
 14341:20120607:205741.526 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=10177 where tf.itemid=ti.itemid and tf.triggerid=220637]
 14341:20120607:205741.527 In DBget_nextid() tablename:'functions'
 14341:20120607:205741.527 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205741.527 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205741.527 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid']
 14341:20120607:205741.527 End of DBget_nextid():14883 table:'functions' recid:'functionid'
 14341:20120607:205741.527 query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,templateid,flags) values (220974,'Free disk space is less than 10% on volume {#FSNAME}',2,0,'','',0,0,1,220637,2);
 14341:20120607:205741.527 query [txnlev:1] [select triggerid,templateid from triggers where triggerid=220974]
 14341:20120607:205741.527 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=220974]
 14341:20120607:205741.527 End of DBcopy_template_triggers():SUCCEED
 14341:20120607:205741.527 In DBcopy_template_graphs()
 14341:20120607:205741.527 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=10161]
 14341:20120607:205741.528 End of DBcopy_template_graphs():SUCCEED
 14341:20120607:205741.528 End of DBcopy_template_elements():SUCCEED
 14341:20120607:205741.528 End of op_template_add()
 14341:20120607:205741.528 In op_groups_add()
 14341:20120607:205741.528 In add_discovered_host() eventid:2248814
 14341:20120607:205741.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,dservices ds1 where dc.druleid=dr.druleid and ds.dcheckid=dc.dcheckid and ds1.dhostid=ds.dhostid and ds1.dserviceid=4 order by ds.dserviceid]
 14341:20120607:205741.528 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=4 and h.hostid between 0 and 99999999999999 order by h.hostid]
 14341:20120607:205741.528 In DBadd_interface()
 14341:20120607:205741.528 query [txnlev:1] [select interfaceid,useip,ip,dns,port,main from interface where hostid=10177 and type=1]
 14341:20120607:205741.528 In substitute_simple_macros() data:'10050'
 14341:20120607:205741.528 End of DBadd_interface():30341
 14341:20120607:205741.528 End of add_discovered_host()
 14341:20120607:205741.528 In add_discovered_host_groups()
 14341:20120607:205741.528 query [txnlev:1] [select groupid from hosts_groups where hostid=10177 and groupid=21]
 14341:20120607:205741.529 In DBget_nextid() tablename:'hosts_groups'
 14341:20120607:205741.529 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205741.529 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205741.529 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='hosts_groups' and field_name='hostgroupid']
 14341:20120607:205741.529 End of DBget_nextid():442 table:'hosts_groups' recid:'hostgroupid'
 14341:20120607:205741.529 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (442,10177,21);
 14341:20120607:205741.529 End of add_discovered_host_groups()
 14341:20120607:205741.529 End of op_groups_add()
 14341:20120607:205741.529 End of execute_operations()
 14341:20120607:205741.529 End of process_actions()
 14341:20120607:205741.529 End of process_event():SUCCEED
 14341:20120607:205741.529 In process_event() eventid:0 object:2 objectid:4 value:0 value_changed:0
 14341:20120607:205741.529 In add_trigger_info()
 14341:20120607:205741.529 End of add_trigger_info():SUCCEED
 14341:20120607:205741.529 In DBget_nextid() tablename:'events'
 14341:20120607:205741.529 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.529 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.529 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.529 End of DBget_nextid():2248815 table:'events' recid:'eventid'
 14341:20120607:205741.530 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248815,1,2,4,1339091861,0,0,0)]
 14341:20120607:205741.530 In process_actions() eventid:2248815
 14341:20120607:205741.530 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205741.530 In check_action_conditions() actionid:42
 14341:20120607:205741.530 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205741.530 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205741.530 In check_discovery_condition()
 14341:20120607:205741.530 End of check_discovery_condition():FAIL
 14341:20120607:205741.530 End of check_action_condition():FAIL
 14341:20120607:205741.530 End of check_action_conditions():FAIL
 14341:20120607:205741.530 End of process_actions()
 14341:20120607:205741.530 End of process_event():SUCCEED
 14341:20120607:205741.530 End of discovery_update_service()
 14341:20120607:205741.530 query [txnlev:1] [commit;]
 14341:20120607:205741.530 End of process_check()
 14341:20120607:205741.530 query [txnlev:1] [begin;]
 14341:20120607:205741.531 In discovery_update_host()
 14341:20120607:205741.531 query [txnlev:1] [update dhosts set status=0,lastup=1339091861,lastdown=0 where dhostid=4]
 14341:20120607:205741.531 In process_event() eventid:0 object:1 objectid:4 value:2 value_changed:0
 14341:20120607:205741.531 In add_trigger_info()
 14341:20120607:205741.531 End of add_trigger_info():SUCCEED
 14341:20120607:205741.531 In DBget_nextid() tablename:'events'
 14341:20120607:205741.531 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.531 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.531 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.531 End of DBget_nextid():2248816 table:'events' recid:'eventid'
 14341:20120607:205741.531 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248816,1,1,4,1339091861,0,2,0)]
 14341:20120607:205741.531 In process_actions() eventid:2248816
 14341:20120607:205741.531 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205741.531 In check_action_conditions() actionid:42
 14341:20120607:205741.531 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205741.531 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205741.531 In check_discovery_condition()
 14341:20120607:205741.531 End of check_discovery_condition():SUCCEED
 14341:20120607:205741.531 End of check_action_condition():SUCCEED
 14341:20120607:205741.531 In check_action_condition() actionid:42 conditionid:464 cond.value:'Windows'
 14341:20120607:205741.531 In check_discovery_condition()
 14341:20120607:205741.531 End of check_discovery_condition():FAIL
 14341:20120607:205741.531 End of check_action_condition():FAIL
 14341:20120607:205741.531 End of check_action_conditions():FAIL
 14341:20120607:205741.531 End of process_actions()
 14341:20120607:205741.532 End of process_event():SUCCEED
 14341:20120607:205741.532 In process_event() eventid:0 object:1 objectid:4 value:0 value_changed:0
 14341:20120607:205741.532 In add_trigger_info()
 14341:20120607:205741.532 End of add_trigger_info():SUCCEED
 14341:20120607:205741.532 In DBget_nextid() tablename:'events'
 14341:20120607:205741.532 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.532 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.532 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205741.532 End of DBget_nextid():2248817 table:'events' recid:'eventid'
 14341:20120607:205741.532 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248817,1,1,4,1339091861,0,0,0)]
 14341:20120607:205741.532 In process_actions() eventid:2248817
 14341:20120607:205741.532 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205741.532 In check_action_conditions() actionid:42
 14341:20120607:205741.532 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205741.532 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205741.532 In check_discovery_condition()
 14341:20120607:205741.532 End of check_discovery_condition():FAIL
 14341:20120607:205741.532 End of check_action_condition():FAIL
 14341:20120607:205741.532 End of check_action_conditions():FAIL
 14341:20120607:205741.532 End of process_actions()
 14341:20120607:205741.532 End of process_event():SUCCEED
 14341:20120607:205741.532 End of discovery_update_host()
 14341:20120607:205741.532 query [txnlev:1] [commit;]
 14341:20120607:205741.543 End of process_rule()
 14341:20120607:205741.543 query without transaction detected
 14341:20120607:205741.543 query [txnlev:0] [update drules set nextcheck=1339091849+delay where druleid=8]
 14341:20120607:205741.544 discoverer #1 spent 12.176200 seconds while processing rules
 14341:20120607:205741.544 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]
 14341:20120607:205741.544 sleeping for 48 seconds
 14341:20120607:205829.549 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<=1339091909 or r.nextcheck>1339091909+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999]
 14341:20120607:205829.550 In process_rule() rule:'Test Discovery LLD' range:'10.20.0.10-15'
 14341:20120607:205829.550 process_rule() '10.20.0.10-15'
 14341:20120607:205829.550 process_rule() IPv4 Range:'10.20.0.10' - '10.20.0.15'
 14341:20120607:205829.550 process_rule() IP:'10.20.0.10'
 14341:20120607:205829.550 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205829.550 In process_check()
 14341:20120607:205829.550 process_check() port:10050
 14341:20120607:205829.550 In discover_service()
 14341:20120607:205829.550 In get_value_agent() host:'' addr:'10.20.0.10' key:'system.uname'
 14341:20120607:205829.551 Sending [system.uname
 14341:20120607:205829.551 get value from agent result: 'Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205829.551 End of discover_service():SUCCEED
 14341:20120607:205829.551 query [txnlev:1] [begin;]
 14341:20120607:205829.551 In discovery_update_service() ip:'10.20.0.10' port:10050 status:0
 14341:20120607:205829.551 In discovery_register_host() ip:'10.20.0.10' status:0 value:'Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205829.551 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=8 and ds.ip='10.20.0.10' order by dh.dhostid]
 14341:20120607:205829.551 host at 10.20.0.10 is already in database
 14341:20120607:205829.551 In discovery_separate_host() ip:'10.20.0.10'
 14341:20120607:205829.551 query [txnlev:1] [select dserviceid from dservices where dhostid=1 and ip<>'10.20.0.10' limit 1]
 14341:20120607:205829.552 End of discovery_separate_host()
 14341:20120607:205829.552 End of discovery_register_host()
 14341:20120607:205829.552 In discovery_register_service() ip:'10.20.0.10' port:10050 key:'system.uname'
 14341:20120607:205829.552 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.10' and port=10050]
 14341:20120607:205829.552 service is already in database
 14341:20120607:205829.552 End of discovery_register_service()
 14341:20120607:205829.552 In process_event() eventid:0 object:2 objectid:1 value:0 value_changed:0
 14341:20120607:205829.552 In add_trigger_info()
 14341:20120607:205829.552 End of add_trigger_info():SUCCEED
 14341:20120607:205829.552 In DBget_nextid() tablename:'events'
 14341:20120607:205829.552 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.552 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.552 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.552 End of DBget_nextid():2248831 table:'events' recid:'eventid'
 14341:20120607:205829.552 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248831,1,2,1,1339091909,0,0,0)]
 14341:20120607:205829.553 In process_actions() eventid:2248831
 14341:20120607:205829.553 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205829.553 In check_action_conditions() actionid:42
 14341:20120607:205829.553 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205829.553 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205829.553 In check_discovery_condition()
 14341:20120607:205829.553 End of check_discovery_condition():FAIL
 14341:20120607:205829.553 End of check_action_condition():FAIL
 14341:20120607:205829.553 End of check_action_conditions():FAIL
 14341:20120607:205829.553 End of process_actions()
 14341:20120607:205829.553 End of process_event():SUCCEED
 14341:20120607:205829.553 End of discovery_update_service()
 14341:20120607:205829.553 query [txnlev:1] [commit;]
 14341:20120607:205829.553 End of process_check()
 14341:20120607:205829.553 query [txnlev:1] [begin;]
 14341:20120607:205829.553 In discovery_update_host()
 14341:20120607:205829.554 In process_event() eventid:0 object:1 objectid:1 value:0 value_changed:0
 14341:20120607:205829.554 In add_trigger_info()
 14341:20120607:205829.554 End of add_trigger_info():SUCCEED
 14341:20120607:205829.554 In DBget_nextid() tablename:'events'
 14341:20120607:205829.554 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.554 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.554 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.554 End of DBget_nextid():2248832 table:'events' recid:'eventid'
 14341:20120607:205829.554 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248832,1,1,1,1339091909,0,0,0)]
 14341:20120607:205829.554 In process_actions() eventid:2248832
 14341:20120607:205829.554 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205829.554 In check_action_conditions() actionid:42
 14341:20120607:205829.554 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205829.554 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205829.554 In check_discovery_condition()
 14341:20120607:205829.554 End of check_discovery_condition():FAIL
 14341:20120607:205829.554 End of check_action_condition():FAIL
 14341:20120607:205829.554 End of check_action_conditions():FAIL
 14341:20120607:205829.554 End of process_actions()
 14341:20120607:205829.554 End of process_event():SUCCEED
 14341:20120607:205829.554 End of discovery_update_host()
 14341:20120607:205829.554 query [txnlev:1] [commit;]
 14341:20120607:205829.555 process_rule() IP:'10.20.0.11'
 14341:20120607:205829.555 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205829.555 In process_check()
 14341:20120607:205829.555 process_check() port:10050
 14341:20120607:205829.555 In discover_service()
 14341:20120607:205829.555 In get_value_agent() host:'' addr:'10.20.0.11' key:'system.uname'
 14341:20120607:205829.556 Sending [system.uname
 14341:20120607:205829.557 get value from agent result: 'Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205829.557 End of discover_service():SUCCEED
 14341:20120607:205829.557 query [txnlev:1] [begin;]
 14341:20120607:205829.557 In discovery_update_service() ip:'10.20.0.11' port:10050 status:0
 14341:20120607:205829.557 In discovery_register_host() ip:'10.20.0.11' status:0 value:'Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205829.557 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=8 and ds.ip='10.20.0.11' order by dh.dhostid]
 14341:20120607:205829.557 host at 10.20.0.11 is already in database
 14341:20120607:205829.557 In discovery_separate_host() ip:'10.20.0.11'
 14341:20120607:205829.557 query [txnlev:1] [select dserviceid from dservices where dhostid=2 and ip<>'10.20.0.11' limit 1]
 14341:20120607:205829.558 End of discovery_separate_host()
 14341:20120607:205829.558 End of discovery_register_host()
 14341:20120607:205829.558 In discovery_register_service() ip:'10.20.0.11' port:10050 key:'system.uname'
 14341:20120607:205829.558 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.11' and port=10050]
 14341:20120607:205829.558 service is already in database
 14341:20120607:205829.558 End of discovery_register_service()
 14341:20120607:205829.558 In process_event() eventid:0 object:2 objectid:2 value:0 value_changed:0
 14341:20120607:205829.558 In add_trigger_info()
 14341:20120607:205829.558 End of add_trigger_info():SUCCEED
 14341:20120607:205829.559 In DBget_nextid() tablename:'events'
 14341:20120607:205829.559 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.559 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.559 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.559 End of DBget_nextid():2248833 table:'events' recid:'eventid'
 14341:20120607:205829.560 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248833,1,2,2,1339091909,0,0,0)]
 14341:20120607:205829.560 In process_actions() eventid:2248833
 14341:20120607:205829.560 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205829.560 In check_action_conditions() actionid:42
 14341:20120607:205829.560 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205829.560 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205829.560 In check_discovery_condition()
 14341:20120607:205829.560 End of check_discovery_condition():FAIL
 14341:20120607:205829.560 End of check_action_condition():FAIL
 14341:20120607:205829.560 End of check_action_conditions():FAIL
 14341:20120607:205829.560 End of process_actions()
 14341:20120607:205829.560 End of process_event():SUCCEED
 14341:20120607:205829.560 End of discovery_update_service()
 14341:20120607:205829.560 query [txnlev:1] [commit;]
 14341:20120607:205829.561 End of process_check()
 14341:20120607:205829.561 query [txnlev:1] [begin;]
 14341:20120607:205829.561 In discovery_update_host()
 14341:20120607:205829.561 In process_event() eventid:0 object:1 objectid:2 value:0 value_changed:0
 14341:20120607:205829.561 In add_trigger_info()
 14341:20120607:205829.561 End of add_trigger_info():SUCCEED
 14341:20120607:205829.561 In DBget_nextid() tablename:'events'
 14341:20120607:205829.561 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.561 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.561 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.561 End of DBget_nextid():2248834 table:'events' recid:'eventid'
 14341:20120607:205829.561 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248834,1,1,2,1339091909,0,0,0)]
 14341:20120607:205829.561 In process_actions() eventid:2248834
 14341:20120607:205829.561 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205829.562 In check_action_conditions() actionid:42
 14341:20120607:205829.562 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205829.562 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205829.562 In check_discovery_condition()
 14341:20120607:205829.562 End of check_discovery_condition():FAIL
 14341:20120607:205829.562 End of check_action_condition():FAIL
 14341:20120607:205829.562 End of check_action_conditions():FAIL
 14341:20120607:205829.562 End of process_actions()
 14341:20120607:205829.562 End of process_event():SUCCEED
 14341:20120607:205829.562 End of discovery_update_host()
 14341:20120607:205829.562 query [txnlev:1] [commit;]
 14341:20120607:205829.562 process_rule() IP:'10.20.0.12'
 14341:20120607:205829.562 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205829.562 In process_check()
 14341:20120607:205829.562 process_check() port:10050
 14341:20120607:205829.562 In discover_service()
 14341:20120607:205829.562 In get_value_agent() host:'' addr:'10.20.0.12' key:'system.uname'
 14341:20120607:205829.563 Sending [system.uname
 14341:20120607:205829.563 get value from agent result: 'Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205829.564 End of discover_service():SUCCEED
 14341:20120607:205829.564 query [txnlev:1] [begin;]
 14341:20120607:205829.564 In discovery_update_service() ip:'10.20.0.12' port:10050 status:0
 14341:20120607:205829.564 In discovery_register_host() ip:'10.20.0.12' status:0 value:'Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205829.564 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=8 and ds.ip='10.20.0.12' order by dh.dhostid]
 14341:20120607:205829.564 host at 10.20.0.12 is already in database
 14341:20120607:205829.564 In discovery_separate_host() ip:'10.20.0.12'
 14341:20120607:205829.564 query [txnlev:1] [select dserviceid from dservices where dhostid=3 and ip<>'10.20.0.12' limit 1]
 14341:20120607:205829.564 End of discovery_separate_host()
 14341:20120607:205829.564 End of discovery_register_host()
 14341:20120607:205829.565 In discovery_register_service() ip:'10.20.0.12' port:10050 key:'system.uname'
 14341:20120607:205829.565 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.12' and port=10050]
 14341:20120607:205829.565 service is already in database
 14341:20120607:205829.565 End of discovery_register_service()
 14341:20120607:205829.565 In process_event() eventid:0 object:2 objectid:3 value:0 value_changed:0
 14341:20120607:205829.565 In add_trigger_info()
 14341:20120607:205829.565 End of add_trigger_info():SUCCEED
 14341:20120607:205829.565 In DBget_nextid() tablename:'events'
 14341:20120607:205829.565 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.565 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.565 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.565 End of DBget_nextid():2248835 table:'events' recid:'eventid'
 14341:20120607:205829.565 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248835,1,2,3,1339091909,0,0,0)]
 14341:20120607:205829.566 In process_actions() eventid:2248835
 14341:20120607:205829.566 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205829.566 In check_action_conditions() actionid:42
 14341:20120607:205829.566 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205829.566 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205829.566 In check_discovery_condition()
 14341:20120607:205829.566 End of check_discovery_condition():FAIL
 14341:20120607:205829.566 End of check_action_condition():FAIL
 14341:20120607:205829.566 End of check_action_conditions():FAIL
 14341:20120607:205829.566 End of process_actions()
 14341:20120607:205829.566 End of process_event():SUCCEED
 14341:20120607:205829.566 End of discovery_update_service()
 14341:20120607:205829.566 query [txnlev:1] [commit;]
 14341:20120607:205829.568 End of process_check()
 14341:20120607:205829.568 query [txnlev:1] [begin;]
 14341:20120607:205829.568 In discovery_update_host()
 14341:20120607:205829.568 In process_event() eventid:0 object:1 objectid:3 value:0 value_changed:0
 14341:20120607:205829.568 In add_trigger_info()
 14341:20120607:205829.568 End of add_trigger_info():SUCCEED
 14341:20120607:205829.568 In DBget_nextid() tablename:'events'
 14341:20120607:205829.568 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.568 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.568 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205829.568 End of DBget_nextid():2248836 table:'events' recid:'eventid'
 14341:20120607:205829.568 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248836,1,1,3,1339091909,0,0,0)]
 14341:20120607:205829.569 In process_actions() eventid:2248836
 14341:20120607:205829.569 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205829.569 In check_action_conditions() actionid:42
 14341:20120607:205829.569 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205829.569 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205829.569 In check_discovery_condition()
 14341:20120607:205829.569 End of check_discovery_condition():FAIL
 14341:20120607:205829.569 End of check_action_condition():FAIL
 14341:20120607:205829.569 End of check_action_conditions():FAIL
 14341:20120607:205829.569 End of process_actions()
 14341:20120607:205829.569 End of process_event():SUCCEED
 14341:20120607:205829.569 End of discovery_update_host()
 14341:20120607:205829.569 query [txnlev:1] [commit;]
 14341:20120607:205829.569 process_rule() IP:'10.20.0.13'
 14341:20120607:205832.569 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205832.570 In process_check()
 14341:20120607:205832.570 process_check() port:10050
 14341:20120607:205832.570 In discover_service()
 14341:20120607:205832.570 In get_value_agent() host:'' addr:'10.20.0.13' key:'system.uname'
 14341:20120607:205835.570 discovery: item [system.uname] error: Get value from agent failed: cannot connect to [[10.20.0.13]:10050]: [4] Interrupted system call
 14341:20120607:205835.570 End of discover_service():FAIL
 14341:20120607:205835.570 query [txnlev:1] [begin;]
 14341:20120607:205835.570 In discovery_update_service() ip:'10.20.0.13' port:10050 status:1
 14341:20120607:205835.570 In discovery_register_host() ip:'10.20.0.13' status:1 value:''
 14341:20120607:205835.570 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=8 and ds.ip='10.20.0.13' order by dh.dhostid]
 14341:20120607:205835.571 End of discovery_register_host()
 14341:20120607:205835.571 End of discovery_update_service()
 14341:20120607:205835.571 query [txnlev:1] [commit;]
 14341:20120607:205835.571 End of process_check()
 14341:20120607:205835.571 query [txnlev:1] [begin;]
 14341:20120607:205835.571 In discovery_update_host()
 14341:20120607:205835.571 End of discovery_update_host()
 14341:20120607:205835.571 query [txnlev:1] [commit;]
 14341:20120607:205835.571 process_rule() IP:'10.20.0.14'
 14341:20120607:205838.572 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205838.572 In process_check()
 14341:20120607:205838.572 process_check() port:10050
 14341:20120607:205838.572 In discover_service()
 14341:20120607:205838.572 In get_value_agent() host:'' addr:'10.20.0.14' key:'system.uname'
 14341:20120607:205841.572 discovery: item [system.uname] error: Get value from agent failed: cannot connect to [[10.20.0.14]:10050]: [4] Interrupted system call
 14341:20120607:205841.572 End of discover_service():FAIL
 14341:20120607:205841.572 query [txnlev:1] [begin;]
 14341:20120607:205841.572 In discovery_update_service() ip:'10.20.0.14' port:10050 status:1
 14341:20120607:205841.573 In discovery_register_host() ip:'10.20.0.14' status:1 value:''
 14341:20120607:205841.573 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=8 and ds.ip='10.20.0.14' order by dh.dhostid]
 14341:20120607:205841.573 End of discovery_register_host()
 14341:20120607:205841.573 End of discovery_update_service()
 14341:20120607:205841.573 query [txnlev:1] [commit;]
 14341:20120607:205841.573 End of process_check()
 14341:20120607:205841.573 query [txnlev:1] [begin;]
 14341:20120607:205841.574 In discovery_update_host()
 14341:20120607:205841.574 End of discovery_update_host()
 14341:20120607:205841.574 query [txnlev:1] [commit;]
 14341:20120607:205841.574 process_rule() IP:'10.20.0.15'
 14341:20120607:205841.574 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205841.574 In process_check()
 14341:20120607:205841.575 process_check() port:10050
 14341:20120607:205841.575 In discover_service()
 14341:20120607:205841.575 In get_value_agent() host:'' addr:'10.20.0.15' key:'system.uname'
 14341:20120607:205841.575 Sending [system.uname
 14341:20120607:205841.575 get value from agent result: 'Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205841.575 End of discover_service():SUCCEED
 14341:20120607:205841.575 query [txnlev:1] [begin;]
 14341:20120607:205841.576 In discovery_update_service() ip:'10.20.0.15' port:10050 status:0
 14341:20120607:205841.576 In discovery_register_host() ip:'10.20.0.15' status:0 value:'Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205841.576 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=8 and ds.ip='10.20.0.15' order by dh.dhostid]
 14341:20120607:205841.576 host at 10.20.0.15 is already in database
 14341:20120607:205841.576 In discovery_separate_host() ip:'10.20.0.15'
 14341:20120607:205841.576 query [txnlev:1] [select dserviceid from dservices where dhostid=4 and ip<>'10.20.0.15' limit 1]
 14341:20120607:205841.577 End of discovery_separate_host()
 14341:20120607:205841.577 End of discovery_register_host()
 14341:20120607:205841.577 In discovery_register_service() ip:'10.20.0.15' port:10050 key:'system.uname'
 14341:20120607:205841.577 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.15' and port=10050]
 14341:20120607:205841.577 service is already in database
 14341:20120607:205841.577 End of discovery_register_service()
 14341:20120607:205841.577 In process_event() eventid:0 object:2 objectid:4 value:0 value_changed:0
 14341:20120607:205841.577 In add_trigger_info()
 14341:20120607:205841.577 End of add_trigger_info():SUCCEED
 14341:20120607:205841.577 In DBget_nextid() tablename:'events'
 14341:20120607:205841.577 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205841.578 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205841.578 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205841.578 End of DBget_nextid():2248838 table:'events' recid:'eventid'
 14341:20120607:205841.578 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248838,1,2,4,1339091921,0,0,0)]
 14341:20120607:205841.578 In process_actions() eventid:2248838
 14341:20120607:205841.578 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205841.578 In check_action_conditions() actionid:42
 14341:20120607:205841.579 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205841.579 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205841.579 In check_discovery_condition()
 14341:20120607:205841.579 End of check_discovery_condition():FAIL
 14341:20120607:205841.579 End of check_action_condition():FAIL
 14341:20120607:205841.579 End of check_action_conditions():FAIL
 14341:20120607:205841.579 End of process_actions()
 14341:20120607:205841.579 End of process_event():SUCCEED
 14341:20120607:205841.579 End of discovery_update_service()
 14341:20120607:205841.579 query [txnlev:1] [commit;]
 14341:20120607:205841.580 End of process_check()
 14341:20120607:205841.580 query [txnlev:1] [begin;]
 14341:20120607:205841.580 In discovery_update_host()
 14341:20120607:205841.580 In process_event() eventid:0 object:1 objectid:4 value:0 value_changed:0
 14341:20120607:205841.581 In add_trigger_info()
 14341:20120607:205841.581 End of add_trigger_info():SUCCEED
 14341:20120607:205841.581 In DBget_nextid() tablename:'events'
 14341:20120607:205841.581 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205841.581 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205841.581 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205841.582 End of DBget_nextid():2248839 table:'events' recid:'eventid'
 14341:20120607:205841.582 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248839,1,1,4,1339091921,0,0,0)]
 14341:20120607:205841.582 In process_actions() eventid:2248839
 14341:20120607:205841.582 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205841.582 In check_action_conditions() actionid:42
 14341:20120607:205841.582 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205841.582 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205841.582 In check_discovery_condition()
 14341:20120607:205841.582 End of check_discovery_condition():FAIL
 14341:20120607:205841.582 End of check_action_condition():FAIL
 14341:20120607:205841.583 End of check_action_conditions():FAIL
 14341:20120607:205841.583 End of process_actions()
 14341:20120607:205841.583 End of process_event():SUCCEED
 14341:20120607:205841.583 End of discovery_update_host()
 14341:20120607:205841.583 query [txnlev:1] [commit;]
 14341:20120607:205841.583 End of process_rule()
 14341:20120607:205841.583 query without transaction detected
 14341:20120607:205841.583 query [txnlev:0] [update drules set nextcheck=1339091909+delay where druleid=8]
 14341:20120607:205841.584 discoverer #1 spent 12.034287 seconds while processing rules
 14341:20120607:205841.584 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]
 14341:20120607:205841.584 sleeping for 48 seconds
 14341:20120607:205929.589 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<=1339091969 or r.nextcheck>1339091969+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999]
 14341:20120607:205929.589 In process_rule() rule:'Test Discovery LLD' range:'10.20.0.10-15'
 14341:20120607:205929.590 process_rule() '10.20.0.10-15'
 14341:20120607:205929.590 process_rule() IPv4 Range:'10.20.0.10' - '10.20.0.15'
 14341:20120607:205929.590 process_rule() IP:'10.20.0.10'
 14341:20120607:205929.590 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205929.590 In process_check()
 14341:20120607:205929.590 process_check() port:10050
 14341:20120607:205929.590 In discover_service()
 14341:20120607:205929.591 In get_value_agent() host:'' addr:'10.20.0.10' key:'system.uname'
 14341:20120607:205929.591 Sending [system.uname
 14341:20120607:205929.591 get value from agent result: 'Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205929.591 End of discover_service():SUCCEED
 14341:20120607:205929.591 query [txnlev:1] [begin;]
 14341:20120607:205929.591 In discovery_update_service() ip:'10.20.0.10' port:10050 status:0
 14341:20120607:205929.591 In discovery_register_host() ip:'10.20.0.10' status:0 value:'Windows IT0 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205929.592 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=8 and ds.ip='10.20.0.10' order by dh.dhostid]
 14341:20120607:205929.592 host at 10.20.0.10 is already in database
 14341:20120607:205929.592 In discovery_separate_host() ip:'10.20.0.10'
 14341:20120607:205929.592 query [txnlev:1] [select dserviceid from dservices where dhostid=1 and ip<>'10.20.0.10' limit 1]
 14341:20120607:205929.592 End of discovery_separate_host()
 14341:20120607:205929.592 End of discovery_register_host()
 14341:20120607:205929.592 In discovery_register_service() ip:'10.20.0.10' port:10050 key:'system.uname'
 14341:20120607:205929.592 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.10' and port=10050]
 14341:20120607:205929.592 service is already in database
 14341:20120607:205929.592 End of discovery_register_service()
 14341:20120607:205929.592 In process_event() eventid:0 object:2 objectid:1 value:0 value_changed:0
 14341:20120607:205929.592 In add_trigger_info()
 14341:20120607:205929.592 End of add_trigger_info():SUCCEED
 14341:20120607:205929.592 In DBget_nextid() tablename:'events'
 14341:20120607:205929.592 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.593 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.593 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.593 End of DBget_nextid():2248841 table:'events' recid:'eventid'
 14341:20120607:205929.593 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248841,1,2,1,1339091969,0,0,0)]
 14341:20120607:205929.594 In process_actions() eventid:2248841
 14341:20120607:205929.594 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205929.594 In check_action_conditions() actionid:42
 14341:20120607:205929.594 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205929.594 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205929.594 In check_discovery_condition()
 14341:20120607:205929.594 End of check_discovery_condition():FAIL
 14341:20120607:205929.594 End of check_action_condition():FAIL
 14341:20120607:205929.594 End of check_action_conditions():FAIL
 14341:20120607:205929.594 End of process_actions()
 14341:20120607:205929.594 End of process_event():SUCCEED
 14341:20120607:205929.594 End of discovery_update_service()
 14341:20120607:205929.594 query [txnlev:1] [commit;]
 14341:20120607:205929.595 End of process_check()
 14341:20120607:205929.595 query [txnlev:1] [begin;]
 14341:20120607:205929.596 In discovery_update_host()
 14341:20120607:205929.596 In process_event() eventid:0 object:1 objectid:1 value:0 value_changed:0
 14341:20120607:205929.596 In add_trigger_info()
 14341:20120607:205929.596 End of add_trigger_info():SUCCEED
 14341:20120607:205929.596 In DBget_nextid() tablename:'events'
 14341:20120607:205929.596 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.596 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.596 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.597 End of DBget_nextid():2248842 table:'events' recid:'eventid'
 14341:20120607:205929.597 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248842,1,1,1,1339091969,0,0,0)]
 14341:20120607:205929.597 In process_actions() eventid:2248842
 14341:20120607:205929.597 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205929.597 In check_action_conditions() actionid:42
 14341:20120607:205929.597 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205929.597 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205929.597 In check_discovery_condition()
 14341:20120607:205929.597 End of check_discovery_condition():FAIL
 14341:20120607:205929.597 End of check_action_condition():FAIL
 14341:20120607:205929.598 End of check_action_conditions():FAIL
 14341:20120607:205929.598 End of process_actions()
 14341:20120607:205929.598 End of process_event():SUCCEED
 14341:20120607:205929.598 End of discovery_update_host()
 14341:20120607:205929.598 query [txnlev:1] [commit;]
 14341:20120607:205929.643 process_rule() IP:'10.20.0.11'
 14341:20120607:205929.643 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205929.644 In process_check()
 14341:20120607:205929.644 process_check() port:10050
 14341:20120607:205929.644 In discover_service()
 14341:20120607:205929.644 In get_value_agent() host:'' addr:'10.20.0.11' key:'system.uname'
 14341:20120607:205929.644 Sending [system.uname
 14341:20120607:205929.645 get value from agent result: 'Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205929.645 End of discover_service():SUCCEED
 14341:20120607:205929.645 query [txnlev:1] [begin;]
 14341:20120607:205929.646 In discovery_update_service() ip:'10.20.0.11' port:10050 status:0
 14341:20120607:205929.646 In discovery_register_host() ip:'10.20.0.11' status:0 value:'Windows IT4 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205929.646 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=8 and ds.ip='10.20.0.11' order by dh.dhostid]
 14341:20120607:205929.646 host at 10.20.0.11 is already in database
 14341:20120607:205929.646 In discovery_separate_host() ip:'10.20.0.11'
 14341:20120607:205929.646 query [txnlev:1] [select dserviceid from dservices where dhostid=2 and ip<>'10.20.0.11' limit 1]
 14341:20120607:205929.646 End of discovery_separate_host()
 14341:20120607:205929.646 End of discovery_register_host()
 14341:20120607:205929.646 In discovery_register_service() ip:'10.20.0.11' port:10050 key:'system.uname'
 14341:20120607:205929.646 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.11' and port=10050]
 14341:20120607:205929.646 service is already in database
 14341:20120607:205929.647 End of discovery_register_service()
 14341:20120607:205929.647 In process_event() eventid:0 object:2 objectid:2 value:0 value_changed:0
 14341:20120607:205929.647 In add_trigger_info()
 14341:20120607:205929.647 End of add_trigger_info():SUCCEED
 14341:20120607:205929.647 In DBget_nextid() tablename:'events'
 14341:20120607:205929.647 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.647 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.647 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.648 End of DBget_nextid():2248843 table:'events' recid:'eventid'
 14341:20120607:205929.648 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248843,1,2,2,1339091969,0,0,0)]
 14341:20120607:205929.648 In process_actions() eventid:2248843
 14341:20120607:205929.648 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205929.648 In check_action_conditions() actionid:42
 14341:20120607:205929.648 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205929.648 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205929.648 In check_discovery_condition()
 14341:20120607:205929.649 End of check_discovery_condition():FAIL
 14341:20120607:205929.649 End of check_action_condition():FAIL
 14341:20120607:205929.649 End of check_action_conditions():FAIL
 14341:20120607:205929.649 End of process_actions()
 14341:20120607:205929.649 End of process_event():SUCCEED
 14341:20120607:205929.649 End of discovery_update_service()
 14341:20120607:205929.649 query [txnlev:1] [commit;]
 14341:20120607:205929.668 End of process_check()
 14341:20120607:205929.668 query [txnlev:1] [begin;]
 14341:20120607:205929.668 In discovery_update_host()
 14341:20120607:205929.668 In process_event() eventid:0 object:1 objectid:2 value:0 value_changed:0
 14341:20120607:205929.668 In add_trigger_info()
 14341:20120607:205929.668 End of add_trigger_info():SUCCEED
 14341:20120607:205929.668 In DBget_nextid() tablename:'events'
 14341:20120607:205929.668 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.668 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.669 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.670 End of DBget_nextid():2248844 table:'events' recid:'eventid'
 14341:20120607:205929.670 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248844,1,1,2,1339091969,0,0,0)]
 14341:20120607:205929.670 In process_actions() eventid:2248844
 14341:20120607:205929.670 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205929.670 In check_action_conditions() actionid:42
 14341:20120607:205929.670 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205929.671 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205929.671 In check_discovery_condition()
 14341:20120607:205929.671 End of check_discovery_condition():FAIL
 14341:20120607:205929.671 End of check_action_condition():FAIL
 14341:20120607:205929.671 End of check_action_conditions():FAIL
 14341:20120607:205929.671 End of process_actions()
 14341:20120607:205929.671 End of process_event():SUCCEED
 14341:20120607:205929.671 End of discovery_update_host()
 14341:20120607:205929.671 query [txnlev:1] [commit;]
 14341:20120607:205929.672 process_rule() IP:'10.20.0.12'
 14341:20120607:205929.672 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205929.672 In process_check()
 14341:20120607:205929.672 process_check() port:10050
 14341:20120607:205929.672 In discover_service()
 14341:20120607:205929.672 In get_value_agent() host:'' addr:'10.20.0.12' key:'system.uname'
 14341:20120607:205929.673 Sending [system.uname
 14341:20120607:205929.673 get value from agent result: 'Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205929.673 End of discover_service():SUCCEED
 14341:20120607:205929.673 query [txnlev:1] [begin;]
 14341:20120607:205929.673 In discovery_update_service() ip:'10.20.0.12' port:10050 status:0
 14341:20120607:205929.673 In discovery_register_host() ip:'10.20.0.12' status:0 value:'Windows IT3 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205929.673 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=8 and ds.ip='10.20.0.12' order by dh.dhostid]
 14341:20120607:205929.674 host at 10.20.0.12 is already in database
 14341:20120607:205929.674 In discovery_separate_host() ip:'10.20.0.12'
 14341:20120607:205929.674 query [txnlev:1] [select dserviceid from dservices where dhostid=3 and ip<>'10.20.0.12' limit 1]
 14341:20120607:205929.674 End of discovery_separate_host()
 14341:20120607:205929.674 End of discovery_register_host()
 14341:20120607:205929.674 In discovery_register_service() ip:'10.20.0.12' port:10050 key:'system.uname'
 14341:20120607:205929.674 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.12' and port=10050]
 14341:20120607:205929.674 service is already in database
 14341:20120607:205929.674 End of discovery_register_service()
 14341:20120607:205929.674 In process_event() eventid:0 object:2 objectid:3 value:0 value_changed:0
 14341:20120607:205929.674 In add_trigger_info()
 14341:20120607:205929.674 End of add_trigger_info():SUCCEED
 14341:20120607:205929.674 In DBget_nextid() tablename:'events'
 14341:20120607:205929.674 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.674 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.675 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.675 End of DBget_nextid():2248845 table:'events' recid:'eventid'
 14341:20120607:205929.675 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248845,1,2,3,1339091969,0,0,0)]
 14341:20120607:205929.675 In process_actions() eventid:2248845
 14341:20120607:205929.675 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205929.675 In check_action_conditions() actionid:42
 14341:20120607:205929.676 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205929.676 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205929.676 In check_discovery_condition()
 14341:20120607:205929.676 End of check_discovery_condition():FAIL
 14341:20120607:205929.676 End of check_action_condition():FAIL
 14341:20120607:205929.676 End of check_action_conditions():FAIL
 14341:20120607:205929.676 End of process_actions()
 14341:20120607:205929.676 End of process_event():SUCCEED
 14341:20120607:205929.676 End of discovery_update_service()
 14341:20120607:205929.676 query [txnlev:1] [commit;]
 14341:20120607:205929.676 End of process_check()
 14341:20120607:205929.676 query [txnlev:1] [begin;]
 14341:20120607:205929.677 In discovery_update_host()
 14341:20120607:205929.677 In process_event() eventid:0 object:1 objectid:3 value:0 value_changed:0
 14341:20120607:205929.677 In add_trigger_info()
 14341:20120607:205929.677 End of add_trigger_info():SUCCEED
 14341:20120607:205929.677 In DBget_nextid() tablename:'events'
 14341:20120607:205929.677 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.677 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.677 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205929.678 End of DBget_nextid():2248846 table:'events' recid:'eventid'
 14341:20120607:205929.678 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248846,1,1,3,1339091969,0,0,0)]
 14341:20120607:205929.678 In process_actions() eventid:2248846
 14341:20120607:205929.678 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205929.678 In check_action_conditions() actionid:42
 14341:20120607:205929.678 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205929.678 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205929.678 In check_discovery_condition()
 14341:20120607:205929.678 End of check_discovery_condition():FAIL
 14341:20120607:205929.678 End of check_action_condition():FAIL
 14341:20120607:205929.678 End of check_action_conditions():FAIL
 14341:20120607:205929.678 End of process_actions()
 14341:20120607:205929.678 End of process_event():SUCCEED
 14341:20120607:205929.679 End of discovery_update_host()
 14341:20120607:205929.679 query [txnlev:1] [commit;]
 14341:20120607:205929.679 process_rule() IP:'10.20.0.13'
 14341:20120607:205932.679 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205932.679 In process_check()
 14341:20120607:205932.679 process_check() port:10050
 14341:20120607:205932.679 In discover_service()
 14341:20120607:205932.679 In get_value_agent() host:'' addr:'10.20.0.13' key:'system.uname'
 14341:20120607:205935.679 discovery: item [system.uname] error: Get value from agent failed: cannot connect to [[10.20.0.13]:10050]: [4] Interrupted system call
 14341:20120607:205935.680 End of discover_service():FAIL
 14341:20120607:205935.680 query [txnlev:1] [begin;]
 14341:20120607:205935.690 In discovery_update_service() ip:'10.20.0.13' port:10050 status:1
 14341:20120607:205935.690 In discovery_register_host() ip:'10.20.0.13' status:1 value:''
 14341:20120607:205935.690 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=8 and ds.ip='10.20.0.13' order by dh.dhostid]
 14341:20120607:205935.690 End of discovery_register_host()
 14341:20120607:205935.690 End of discovery_update_service()
 14341:20120607:205935.690 query [txnlev:1] [commit;]
 14341:20120607:205935.690 End of process_check()
 14341:20120607:205935.690 query [txnlev:1] [begin;]
 14341:20120607:205935.691 In discovery_update_host()
 14341:20120607:205935.691 End of discovery_update_host()
 14341:20120607:205935.691 query [txnlev:1] [commit;]
 14341:20120607:205935.691 process_rule() IP:'10.20.0.14'
 14341:20120607:205938.691 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205938.691 In process_check()
 14341:20120607:205938.691 process_check() port:10050
 14341:20120607:205938.691 In discover_service()
 14341:20120607:205938.691 In get_value_agent() host:'' addr:'10.20.0.14' key:'system.uname'
 14341:20120607:205941.692 discovery: item [system.uname] error: Get value from agent failed: cannot connect to [[10.20.0.14]:10050]: [4] Interrupted system call
 14341:20120607:205941.692 End of discover_service():FAIL
 14341:20120607:205941.692 query [txnlev:1] [begin;]
 14341:20120607:205941.692 In discovery_update_service() ip:'10.20.0.14' port:10050 status:1
 14341:20120607:205941.692 In discovery_register_host() ip:'10.20.0.14' status:1 value:''
 14341:20120607:205941.692 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=8 and ds.ip='10.20.0.14' order by dh.dhostid]
 14341:20120607:205941.692 End of discovery_register_host()
 14341:20120607:205941.692 End of discovery_update_service()
 14341:20120607:205941.692 query [txnlev:1] [commit;]
 14341:20120607:205941.692 End of process_check()
 14341:20120607:205941.692 query [txnlev:1] [begin;]
 14341:20120607:205941.693 In discovery_update_host()
 14341:20120607:205941.693 End of discovery_update_host()
 14341:20120607:205941.693 query [txnlev:1] [commit;]
 14341:20120607:205941.693 process_rule() IP:'10.20.0.15'
 14341:20120607:205941.693 query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=8 order by dcheckid]
 14341:20120607:205941.694 In process_check()
 14341:20120607:205941.694 process_check() port:10050
 14341:20120607:205941.694 In discover_service()
 14341:20120607:205941.694 In get_value_agent() host:'' addr:'10.20.0.15' key:'system.uname'
 14341:20120607:205941.694 Sending [system.uname
 14341:20120607:205941.694 get value from agent result: 'Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205941.695 End of discover_service():SUCCEED
 14341:20120607:205941.695 query [txnlev:1] [begin;]
 14341:20120607:205941.695 In discovery_update_service() ip:'10.20.0.15' port:10050 status:0
 14341:20120607:205941.695 In discovery_register_host() ip:'10.20.0.15' status:0 value:'Windows SSKD 5.2.3790 Windows Server 2003 Service Pack 2 Intel IA-32'
 14341:20120607:205941.695 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=8 and ds.ip='10.20.0.15' order by dh.dhostid]
 14341:20120607:205941.695 host at 10.20.0.15 is already in database
 14341:20120607:205941.695 In discovery_separate_host() ip:'10.20.0.15'
 14341:20120607:205941.695 query [txnlev:1] [select dserviceid from dservices where dhostid=4 and ip<>'10.20.0.15' limit 1]
 14341:20120607:205941.695 End of discovery_separate_host()
 14341:20120607:205941.695 End of discovery_register_host()
 14341:20120607:205941.695 In discovery_register_service() ip:'10.20.0.15' port:10050 key:'system.uname'
 14341:20120607:205941.695 query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value,dns from dservices where dcheckid=39 and type=9 and key_='system.uname' and ip='10.20.0.15' and port=10050]
 14341:20120607:205941.696 service is already in database
 14341:20120607:205941.696 End of discovery_register_service()
 14341:20120607:205941.696 In process_event() eventid:0 object:2 objectid:4 value:0 value_changed:0
 14341:20120607:205941.696 In add_trigger_info()
 14341:20120607:205941.696 End of add_trigger_info():SUCCEED
 14341:20120607:205941.696 In DBget_nextid() tablename:'events'
 14341:20120607:205941.696 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205941.696 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205941.697 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205941.697 End of DBget_nextid():2248847 table:'events' recid:'eventid'
 14341:20120607:205941.697 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248847,1,2,4,1339091981,0,0,0)]
 14341:20120607:205941.697 In process_actions() eventid:2248847
 14341:20120607:205941.697 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205941.698 In check_action_conditions() actionid:42
 14341:20120607:205941.698 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205941.698 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205941.698 In check_discovery_condition()
 14341:20120607:205941.698 End of check_discovery_condition():FAIL
 14341:20120607:205941.698 End of check_action_condition():FAIL
 14341:20120607:205941.698 End of check_action_conditions():FAIL
 14341:20120607:205941.698 End of process_actions()
 14341:20120607:205941.698 End of process_event():SUCCEED
 14341:20120607:205941.698 End of discovery_update_service()
 14341:20120607:205941.698 query [txnlev:1] [commit;]
 14341:20120607:205941.699 End of process_check()
 14341:20120607:205941.699 query [txnlev:1] [begin;]
 14341:20120607:205941.699 In discovery_update_host()
 14341:20120607:205941.699 In process_event() eventid:0 object:1 objectid:4 value:0 value_changed:0
 14341:20120607:205941.699 In add_trigger_info()
 14341:20120607:205941.699 End of add_trigger_info():SUCCEED
 14341:20120607:205941.699 In DBget_nextid() tablename:'events'
 14341:20120607:205941.699 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205941.700 query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205941.700 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
 14341:20120607:205941.701 End of DBget_nextid():2248848 table:'events' recid:'eventid'
 14341:20120607:205941.701 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,value_changed) values (2248848,1,1,4,1339091981,0,0,0)]
 14341:20120607:205941.701 In process_actions() eventid:2248848
 14341:20120607:205941.701 query [txnlev:1] [select actionid,evaltype from actions where status=0 and eventsource=1 and actionid between 0 and 99999999999999]
 14341:20120607:205941.701 In check_action_conditions() actionid:42
 14341:20120607:205941.701 query [txnlev:1] [select conditionid,conditiontype,operator,value from conditions where actionid=42 order by conditiontype]
 14341:20120607:205941.701 In check_action_condition() actionid:42 conditionid:465 cond.value:'2'
 14341:20120607:205941.701 In check_discovery_condition()
 14341:20120607:205941.701 End of check_discovery_condition():FAIL
 14341:20120607:205941.701 End of check_action_condition():FAIL
 14341:20120607:205941.701 End of check_action_conditions():FAIL
 14341:20120607:205941.702 End of process_actions()
 14341:20120607:205941.702 End of process_event():SUCCEED
 14341:20120607:205941.702 End of discovery_update_host()
 14341:20120607:205941.702 query [txnlev:1] [commit;]
 14341:20120607:205941.702 End of process_rule()
 14341:20120607:205941.702 query without transaction detected
 14341:20120607:205941.702 query [txnlev:0] [update drules set nextcheck=1339091969+delay where druleid=8]
 14341:20120607:205941.703 discoverer #1 spent 12.113779 seconds while processing rules
 14341:20120607:205941.703 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]
 14341:20120607:205941.703 sleeping for 48 seconds
 14341:20120607:210017.416 Got signal [signal:15(SIGTERM),sender_pid:14490,sender_uid:0,reason:0]. Exiting ...