24535:20100503:164751.591 server #25 started [Discoverer. SNMP:YES] 24535:20100503:164751.591 In main_discoverer_loop(num:8) 24535:20100503:164751.591 Connect to the database 24535:20100503:164751.592 Query [txnlev:0] [SET NAMES utf8] 24535:20100503:164751.592 Query [txnlev:0] [SET CHARACTER SET utf8] 24535:20100503:164751.592 Query [txnlev:0] [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1272898071 or nextcheck>1272898071+delay) and mod(druleid,8)=7 and druleid between 000000000000000 and 099999999999999] 24535:20100503:164751.593 In process_rule() rule:'Discovery_Rule_2' range:'10.100.216.0-254,10.100.217.0-254,10.100.218.0-254,10.100.219.0-254,10.100.220.0-254,10.100.221.0-254,10.100.222.0-254,10.100.223.0-254' 24535:20100503:164751.593 process_rule() '10.100.216.0-254' 24535:20100503:164751.593 process_rule() IPv4 Range:'10.100.216.0' - '10.100.216.254' 24535:20100503:164751.593 process_rule() IP:'10.100.216.0' 24535:20100503:164751.593 Query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 order by dcheckid] 24535:20100503:164751.593 In process_check() 24535:20100503:164751.593 process_check() port:10500 24535:20100503:164751.593 In discover_service() 24535:20100503:164751.593 In get_value_agent() host:'' addr:'10.100.216.0' key:'system.uname' 24535:20100503:164751.593 Discovery: Item [system.uname] error: Get value from agent failed: Cannot connect to [10.100.216.0:10500] [Network is unreachable] 24535:20100503:164751.593 End of discover_service():FAIL 24535:20100503:164751.593 Query [txnlev:1] [begin;] 24535:20100503:164751.594 In update_service() ip:'10.100.216.0' port:10500 status:1 24535:20100503:164751.594 In register_host() 24535:20100503:164751.594 Query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and dh.druleid=7 and ds.ip='10.100.216.0' order by dh.dhostid] 24535:20100503:164751.595 End of register_host() 24535:20100503:164751.595 End of update_service() 24535:20100503:164751.595 Query [txnlev:1] [commit;] 24535:20100503:164751.595 End of process_check() 24535:20100503:164751.595 Query [txnlev:1] [begin;] 24535:20100503:164751.595 In update_host() 24535:20100503:164751.595 End of update_host() 24535:20100503:164751.595 Query [txnlev:1] [commit;] 24535:20100503:164751.596 process_rule() IP:'10.100.216.1' 24535:20100503:164751.596 Query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 order by dcheckid] 24535:20100503:164751.596 In process_check() 24535:20100503:164751.596 process_check() port:10500 24535:20100503:164751.596 In discover_service() 24535:20100503:164751.596 In get_value_agent() host:'' addr:'10.100.216.1' key:'system.uname' 24535:20100503:164754.555 Discovery: Item [system.uname] error: Get value from agent failed: Cannot connect to [10.100.216.1:10500] [No route to host] 24535:20100503:164754.555 End of discover_service():FAIL 24535:20100503:164754.555 Query [txnlev:1] [begin;] 24535:20100503:164754.555 In update_service() ip:'10.100.216.1' port:10500 status:1 24535:20100503:164754.555 In register_host() 24535:20100503:164754.555 Query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and dh.druleid=7 and ds.ip='10.100.216.1' order by dh.dhostid] 24535:20100503:164754.556 End of register_host() 24535:20100503:164754.556 End of update_service() 24535:20100503:164754.556 Query [txnlev:1] [commit;] 24535:20100503:164754.556 End of process_check() 24535:20100503:164754.556 Query [txnlev:1] [begin;] 24535:20100503:164754.557 In update_host() 24535:20100503:164754.557 End of update_host() 24535:20100503:164754.557 Query [txnlev:1] [commit;] 24535:20100503:164754.557 process_rule() IP:'10.100.216.2' 24535:20100503:164754.557 Query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 order by dcheckid] 24535:20100503:164754.557 In process_check() 24535:20100503:164754.557 process_check() port:10500 24535:20100503:164754.557 In discover_service() 24535:20100503:164754.557 In get_value_agent() host:'' addr:'10.100.216.2' key:'system.uname' 24535:20100503:164757.078 Discovery: Item [system.uname] error: Get value from agent failed: Cannot connect to [10.100.216.2:10500] [No route to host] 24535:20100503:164757.078 End of discover_service():FAIL 24535:20100503:164757.078 Query [txnlev:1] [begin;] 24535:20100503:164757.078 In update_service() ip:'10.100.216.2' port:10500 status:1 24535:20100503:164757.078 In register_host() 24535:20100503:164757.078 Query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and dh.druleid=7 and ds.ip='10.100.216.2' order by dh.dhostid] 24535:20100503:164757.080 End of register_host() 24535:20100503:164757.080 End of update_service() 24535:20100503:164757.080 Query [txnlev:1] [commit;] 24535:20100503:164757.080 End of process_check() 24535:20100503:164757.080 Query [txnlev:1] [begin;] 24535:20100503:164757.080 In update_host() 24535:20100503:164757.080 End of update_host() 24535:20100503:164757.080 Query [txnlev:1] [commit;] 24535:20100503:164757.080 process_rule() IP:'10.100.216.3' 24535:20100503:164757.080 Query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 order by dcheckid] 24535:20100503:164757.080 In process_check() 24535:20100503:164757.080 process_check() port:10500 24535:20100503:164757.080 In discover_service() 24535:20100503:164757.080 In get_value_agent() host:'' addr:'10.100.216.3' key:'system.uname' 24535:20100503:164759.610 Discovery: Item [system.uname] error: Get value from agent failed: Cannot connect to [10.100.216.3:10500] [No route to host] 24535:20100503:164759.610 End of discover_service():FAIL 24535:20100503:164759.610 Query [txnlev:1] [begin;] 24535:20100503:164759.610 In update_service() ip:'10.100.216.3' port:10500 status:1 24535:20100503:164759.610 In register_host() 24535:20100503:164759.610 Query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and dh.druleid=7 and ds.ip='10.100.216.3' order by dh.dhostid] 24535:20100503:164759.611 End of register_host() 24535:20100503:164759.611 End of update_service() 24535:20100503:164759.611 Query [txnlev:1] [commit;] 24535:20100503:164759.612 End of process_check() 24535:20100503:164759.612 Query [txnlev:1] [begin;] 24535:20100503:164759.612 In update_host() 24535:20100503:164759.612 End of update_host() 24535:20100503:164759.612 Query [txnlev:1] [commit;] 24535:20100503:164759.612 process_rule() IP:'10.100.216.4' 24535:20100503:164759.612 Query [txnlev:0] [select dcheckid,type,key_,snmp_community,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,ports from dchecks where druleid=7 order by dcheckid] 24535:20100503:164759.612 In process_check() 24535:20100503:164759.612 process_check() port:10500 24535:20100503:164759.612 In discover_service() 24535:20100503:164759.612 In get_value_agent() host:'' addr:'10.100.216.4' key:'system.uname' 24535:20100503:164759.612 Discovery: Item [system.uname] error: Get value from agent failed: Cannot connect to [10.100.216.4:10500] [Connection refused] 24535:20100503:164759.612 End of discover_service():FAIL 24535:20100503:164759.612 Query [txnlev:1] [begin;] 24535:20100503:164759.612 In update_service() ip:'10.100.216.4' port:10500 status:1 24535:20100503:164759.612 In register_host() 24535:20100503:164759.612 Query [txnlev:1] [select dh.dhostid,dh.status,dh.lastup,dh.lastdown from dhosts dh,dservices ds where ds.dhostid=dh.dhostid and dh.druleid=7 and ds.ip='10.100.216.4' order by dh.dhostid] 24535:20100503:164759.613 Host at 10.100.216.4 is already in database 24535:20100503:164759.613 In separate_host() ip:'10.100.216.4' 24535:20100503:164759.613 Query [txnlev:1] [select dserviceid from dservices where dhostid=403 and ip<>'10.100.216.4' limit 1] 24535:20100503:164759.613 End of separate_host() 24535:20100503:164759.613 End of register_host() 24535:20100503:164759.613 In register_service() ip:'10.100.216.4' port:10500 key:'system.uname' 24535:20100503:164759.614 Query [txnlev:1] [select dserviceid,dhostid,status,lastup,lastdown,value from dservices where dcheckid=36 and type=9 and key_='system.uname' and ip='10.100.216.4' and port=10500] 24535:20100503:164759.616 End of register_service() 24535:20100503:164759.616 End of update_service() 24535:20100503:164759.616 Query [txnlev:1] [commit;] 24535:20100503:164759.616 End of process_check() 24535:20100503:164759.616 Query [txnlev:1] [begin;] 24535:20100503:164759.616 In update_host() 24535:20100503:164759.616 In process_event(eventid:0,object:1,objectid:403) 24535:20100503:164759.616 In DBget_maxid events.eventid 24535:20100503:164759.616 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid'] 24535:20100503:164759.616 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'] 24535:20100503:164759.617 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid'] 24535:20100503:164759.617 End of DBget_maxid "events"."eventid":6309362 24535:20100503:164759.617 Query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,value) values (6309362,1,1,403,1272898079,1)] 24535:20100503:164759.617 In process_actions() eventid:6309362 24535:20100503:164759.617 Query [txnlev:1] [select actionid,evaltype,status,eventsource from actions where status=0 and eventsource=1 and actionid between 000000000000000 and 099999999999999] 24535:20100503:164759.617 In check_action_conditions (actionid:2) 24535:20100503:164759.617 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=2 order by conditiontype] 24535:20100503:164759.618 In check_action_condition() [actionid:2,conditionid:546,cond.value:9] 24535:20100503:164759.618 In check_discovery_condition() 24535:20100503:164759.618 End of check_discovery_condition():FAIL 24535:20100503:164759.618 End of check_action_condition():FAIL 24535:20100503:164759.618 End check_action_conditions (result:FALSE) 24535:20100503:164759.618 In check_action_conditions (actionid:3) 24535:20100503:164759.618 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=3 order by conditiontype] 24535:20100503:164759.618 In check_action_condition() [actionid:3,conditionid:268,cond.value:9] 24535:20100503:164759.618 In check_discovery_condition() 24535:20100503:164759.618 End of check_discovery_condition():FAIL 24535:20100503:164759.618 End of check_action_condition():FAIL 24535:20100503:164759.618 End check_action_conditions (result:FALSE) 24535:20100503:164759.618 In check_action_conditions (actionid:5) 24535:20100503:164759.618 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=5 order by conditiontype] 24535:20100503:164759.618 In check_action_condition() [actionid:5,conditionid:389,cond.value:10.100.196.0-254,10.100.197.0-254] 24535:20100503:164759.618 In check_discovery_condition() 24535:20100503:164759.618 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.618 In ip_in_list(list:10.100.196.0-254,10.100.197.0-254,ip:10.100.216.4) 24535:20100503:164759.618 End of ip_in_list():FAIL 24535:20100503:164759.618 End of check_discovery_condition():FAIL 24535:20100503:164759.618 End of check_action_condition():FAIL 24535:20100503:164759.618 End check_action_conditions (result:FALSE) 24535:20100503:164759.618 In check_action_conditions (actionid:6) 24535:20100503:164759.618 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=6 order by conditiontype] 24535:20100503:164759.619 In check_action_condition() [actionid:6,conditionid:552,cond.value:10.100.194.0-254,10.100.195.0-239] 24535:20100503:164759.619 In check_discovery_condition() 24535:20100503:164759.619 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.619 In ip_in_list(list:10.100.194.0-254,10.100.195.0-239,ip:10.100.216.4) 24535:20100503:164759.619 End of ip_in_list():FAIL 24535:20100503:164759.619 End of check_discovery_condition():FAIL 24535:20100503:164759.619 End of check_action_condition():FAIL 24535:20100503:164759.619 End check_action_conditions (result:FALSE) 24535:20100503:164759.619 In check_action_conditions (actionid:17) 24535:20100503:164759.619 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=17 order by conditiontype] 24535:20100503:164759.619 In check_action_condition() [actionid:17,conditionid:549,cond.value:9] 24535:20100503:164759.619 In check_discovery_condition() 24535:20100503:164759.619 End of check_discovery_condition():FAIL 24535:20100503:164759.619 End of check_action_condition():FAIL 24535:20100503:164759.619 End check_action_conditions (result:FALSE) 24535:20100503:164759.619 In check_action_conditions (actionid:18) 24535:20100503:164759.619 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=18 order by conditiontype] 24535:20100503:164759.619 In check_action_condition() [actionid:18,conditionid:395,cond.value:10.100.192.0-254,10.100.193.0-254] 24535:20100503:164759.619 In check_discovery_condition() 24535:20100503:164759.619 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.619 In ip_in_list(list:10.100.192.0-254,10.100.193.0-254,ip:10.100.216.4) 24535:20100503:164759.619 End of ip_in_list():FAIL 24535:20100503:164759.620 End of check_discovery_condition():FAIL 24535:20100503:164759.620 End of check_action_condition():FAIL 24535:20100503:164759.620 End check_action_conditions (result:FALSE) 24535:20100503:164759.620 In check_action_conditions (actionid:21) 24535:20100503:164759.620 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=21 order by conditiontype] 24535:20100503:164759.620 In check_action_condition() [actionid:21,conditionid:554,cond.value:10.100.198.0-254,10.100.199.64-254] 24535:20100503:164759.620 In check_discovery_condition() 24535:20100503:164759.620 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.620 In ip_in_list(list:10.100.198.0-254,10.100.199.64-254,ip:10.100.216.4) 24535:20100503:164759.620 End of ip_in_list():FAIL 24535:20100503:164759.620 End of check_discovery_condition():FAIL 24535:20100503:164759.620 End of check_action_condition():FAIL 24535:20100503:164759.620 End check_action_conditions (result:FALSE) 24535:20100503:164759.620 In check_action_conditions (actionid:22) 24535:20100503:164759.620 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=22 order by conditiontype] 24535:20100503:164759.620 In check_action_condition() [actionid:22,conditionid:387,cond.value:10.100.199.32-63] 24535:20100503:164759.620 In check_discovery_condition() 24535:20100503:164759.620 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.620 In ip_in_list(list:10.100.199.32-63,ip:10.100.216.4) 24535:20100503:164759.620 End of ip_in_list():FAIL 24535:20100503:164759.620 End of check_discovery_condition():FAIL 24535:20100503:164759.620 End of check_action_condition():FAIL 24535:20100503:164759.620 End check_action_conditions (result:FALSE) 24535:20100503:164759.621 In check_action_conditions (actionid:23) 24535:20100503:164759.621 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=23 order by conditiontype] 24535:20100503:164759.621 In check_action_condition() [actionid:23,conditionid:383,cond.value:10.100.199.1-31] 24535:20100503:164759.621 In check_discovery_condition() 24535:20100503:164759.621 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.621 In ip_in_list(list:10.100.199.1-31,ip:10.100.216.4) 24535:20100503:164759.621 End of ip_in_list():FAIL 24535:20100503:164759.621 End of check_discovery_condition():FAIL 24535:20100503:164759.621 End of check_action_condition():FAIL 24535:20100503:164759.621 End check_action_conditions (result:FALSE) 24535:20100503:164759.621 In check_action_conditions (actionid:28) 24535:20100503:164759.621 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=28 order by conditiontype] 24535:20100503:164759.621 In check_action_condition() [actionid:28,conditionid:409,cond.value:10.100.216.8-15,10.100.216.160-215,10.100.216.232-254,10.100.217.0-254,10.100.220.0-254,10.100.221.0-254] 24535:20100503:164759.621 In check_discovery_condition() 24535:20100503:164759.621 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.621 In ip_in_list(list:10.100.216.8-15,10.100.216.160-215,10.100.216.232-254,10.100.217.0-254,10.100.220.0-254,10.100.221.0-254,ip:10.100.216.4) 24535:20100503:164759.621 End of ip_in_list():FAIL 24535:20100503:164759.621 End of check_discovery_condition():FAIL 24535:20100503:164759.621 End of check_action_condition():FAIL 24535:20100503:164759.621 End check_action_conditions (result:FALSE) 24535:20100503:164759.621 In check_action_conditions (actionid:29) 24535:20100503:164759.621 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=29 order by conditiontype] 24535:20100503:164759.622 In check_action_condition() [actionid:29,conditionid:405,cond.value:10.100.216.96-159] 24535:20100503:164759.622 In check_discovery_condition() 24535:20100503:164759.622 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.622 In ip_in_list(list:10.100.216.96-159,ip:10.100.216.4) 24535:20100503:164759.622 End of ip_in_list():FAIL 24535:20100503:164759.622 End of check_discovery_condition():FAIL 24535:20100503:164759.622 End of check_action_condition():FAIL 24535:20100503:164759.622 End check_action_conditions (result:FALSE) 24535:20100503:164759.622 In check_action_conditions (actionid:30) 24535:20100503:164759.622 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=30 order by conditiontype] 24535:20100503:164759.622 In check_action_condition() [actionid:30,conditionid:397,cond.value:10.100.216.216-231] 24535:20100503:164759.622 In check_discovery_condition() 24535:20100503:164759.622 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.622 In ip_in_list(list:10.100.216.216-231,ip:10.100.216.4) 24535:20100503:164759.622 End of ip_in_list():FAIL 24535:20100503:164759.622 End of check_discovery_condition():FAIL 24535:20100503:164759.622 End of check_action_condition():FAIL 24535:20100503:164759.622 End check_action_conditions (result:FALSE) 24535:20100503:164759.622 In check_action_conditions (actionid:31) 24535:20100503:164759.622 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=31 order by conditiontype] 24535:20100503:164759.622 In check_action_condition() [actionid:31,conditionid:556,cond.value:10.100.216.0-7,10.100.216.16-95,10.100.218.0-254,10.100.219.0-254,10.100.222.0-254,10.100.223.0-239] 24535:20100503:164759.622 In check_discovery_condition() 24535:20100503:164759.622 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.623 In ip_in_list(list:10.100.216.0-7,10.100.216.16-95,10.100.218.0-254,10.100.219.0-254,10.100.222.0-254,10.100.223.0-239,ip:10.100.216.4) 24535:20100503:164759.623 End of ip_in_list():SUCCEED 24535:20100503:164759.623 End of check_discovery_condition():SUCCEED 24535:20100503:164759.623 End of check_action_condition():SUCCEED 24535:20100503:164759.623 In check_action_condition() [actionid:31,conditionid:557,cond.value:0] 24535:20100503:164759.623 In check_discovery_condition() 24535:20100503:164759.623 End of check_discovery_condition():FAIL 24535:20100503:164759.623 End of check_action_condition():FAIL 24535:20100503:164759.623 End check_action_conditions (result:FALSE) 24535:20100503:164759.623 In check_action_conditions (actionid:35) 24535:20100503:164759.623 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=35 order by conditiontype] 24535:20100503:164759.623 In check_action_condition() [actionid:35,conditionid:401,cond.value:10.100.223.240-254] 24535:20100503:164759.623 In check_discovery_condition() 24535:20100503:164759.623 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.623 In ip_in_list(list:10.100.223.240-254,ip:10.100.216.4) 24535:20100503:164759.623 End of ip_in_list():FAIL 24535:20100503:164759.623 End of check_discovery_condition():FAIL 24535:20100503:164759.623 End of check_action_condition():FAIL 24535:20100503:164759.623 End check_action_conditions (result:FALSE) 24535:20100503:164759.623 In check_action_conditions (actionid:38) 24535:20100503:164759.623 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=38 order by conditiontype] 24535:20100503:164759.623 In check_action_condition() [actionid:38,conditionid:393,cond.value:10.100.195.240-254] 24535:20100503:164759.623 In check_discovery_condition() 24535:20100503:164759.623 Query [txnlev:1] [select distinct ip from dservices where dhostid=403] 24535:20100503:164759.624 In ip_in_list(list:10.100.195.240-254,ip:10.100.216.4) 24535:20100503:164759.624 End of ip_in_list():FAIL 24535:20100503:164759.624 End of check_discovery_condition():FAIL 24535:20100503:164759.624 End of check_action_condition():FAIL 24535:20100503:164759.624 End check_action_conditions (result:FALSE) 24535:20100503:164759.624 In check_action_conditions (actionid:39) 24535:20100503:164759.624 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=39 order by conditiontype] 24535:20100503:164759.624 In check_action_condition() [actionid:39,conditionid:523,cond.value:2] 24535:20100503:164759.624 In check_discovery_condition() 24535:20100503:164759.624 End of check_discovery_condition():FAIL 24535:20100503:164759.624 End of check_action_condition():FAIL 24535:20100503:164759.624 End check_action_conditions (result:FALSE) 24535:20100503:164759.624 In check_action_conditions (actionid:40) 24535:20100503:164759.624 Query [txnlev:1] [select conditionid,actionid,conditiontype,operator,value from conditions where actionid=40 order by conditiontype] 24535:20100503:164759.624 In check_action_condition() [actionid:40,conditionid:415,cond.value:1] 24535:20100503:164759.624 In check_discovery_condition() 24535:20100503:164759.624 End of check_discovery_condition():SUCCEED 24535:20100503:164759.624 End of check_action_condition():SUCCEED 24535:20100503:164759.624 In check_action_condition() [actionid:40,conditionid:416,cond.value:86400] 24535:20100503:164759.624 In check_discovery_condition() 24535:20100503:164759.624 Query [txnlev:1] [select status,lastup,lastdown from dhosts where dhostid=403] 24535:20100503:164759.624 End of check_discovery_condition():SUCCEED 24535:20100503:164759.624 End of check_action_condition():SUCCEED 24535:20100503:164759.624 End check_action_conditions (result:TRUE) 24535:20100503:164759.624 Conditions match our event. Execute operations. 24535:20100503:164759.624 Query [txnlev:1] [delete from escalations where actionid=40 and triggerid=0] 24535:20100503:164759.624 In DBget_maxid escalations.escalationid 24535:20100503:164759.625 In DCget_nextid escalations.escalationid [1] 24535:20100503:164759.625 Query [txnlev:1] [select max(escalationid) from escalations where escalationid between 0 and 99999999999999] 24535:20100503:164759.625 End of DCget_nextid escalations.escalationid [5506441:5506441] 24535:20100503:164759.625 Query [txnlev:1] [insert into escalations (escalationid,actionid,triggerid,eventid,status) values (5506441,40,0,6309362,0)] 24535:20100503:164759.625 In execute_operations(actionid:40) 24535:20100503:164759.625 Query [txnlev:1] [select operationid,actionid,operationtype,object,objectid from operations where actionid=40] 24535:20100503:164759.625 In op_host_del() 24535:20100503:164759.625 In select_discovered_host(eventid:6309362) 24535:20100503:164759.625 Query [txnlev:1] [select h.hostid from hosts h,dservices ds where ds.ip=h.ip and ds.dhostid=403] 24535:20100503:164759.626 End select_discovered_host() 24535:20100503:164759.626 In DBdelete_host() 24535:20100503:164759.626 Query [txnlev:1] [select distinct gi.graphid from graphs_items gi,items i where gi.itemid=i.itemid and i.hostid=312712] 24535:20100503:164759.626 Query [txnlev:1] [select distinct ht.httptestid from httptest ht,applications a where ht.applicationid=a.applicationid and a.hostid=312712] 24535:20100503:164759.626 In DBdelete_httptests() htids_num:0 24535:20100503:164759.626 Query [txnlev:1] [select itemid from items where hostid=312712] 24535:20100503:164759.626 In DBdelete_items() itemids_num:1 24535:20100503:164759.626 In DBdelete_triggers_by_itemids() itemids_num:1 24535:20100503:164759.626 Query [txnlev:1] [select distinct triggerid from functions where itemid in (347032)] 24535:20100503:164759.626 Query [txnlev:1] [select serviceid from services where triggerid=328827] 24535:20100503:164759.627 Query [txnlev:1] [SELECT s.serviceid FROM services as s, services_links as sl WHERE s.serviceid = sl.serviceupid AND NOT(s.triggerid IS NULL) GROUP BY s.serviceid] 24535:20100503:164759.627 Query [txnlev:1] [SELECT s.serviceid,s.algorithm,s.triggerid FROM services AS s WHERE s.serviceid NOT IN (SELECT DISTINCT sl.serviceupid FROM services_links AS sl)] 24535:20100503:164759.627 Query [txnlev:1] [select priority from triggers where triggerid=65782 and status=0 and value=1] 24535:20100503:164759.627 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=7 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.627 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=7] 24535:20100503:164759.627 In add_service_alarm() 24535:20100503:164759.627 In latest_service_alarm() 24535:20100503:164759.627 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=7 order by servicealarmid desc limit 1] 24535:20100503:164759.629 Query [txnlev:1] [select priority from triggers where triggerid=109920 and status=0 and value=1] 24535:20100503:164759.629 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=9 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.629 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=9] 24535:20100503:164759.629 In add_service_alarm() 24535:20100503:164759.629 In latest_service_alarm() 24535:20100503:164759.629 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=9 order by servicealarmid desc limit 1] 24535:20100503:164759.629 Query [txnlev:1] [select priority from triggers where triggerid=109970 and status=0 and value=1] 24535:20100503:164759.629 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=11 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.629 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=11] 24535:20100503:164759.629 In add_service_alarm() 24535:20100503:164759.630 In latest_service_alarm() 24535:20100503:164759.630 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=11 order by servicealarmid desc limit 1] 24535:20100503:164759.630 Query [txnlev:1] [select priority from triggers where triggerid=109967 and status=0 and value=1] 24535:20100503:164759.630 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=12 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.630 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=12] 24535:20100503:164759.630 In add_service_alarm() 24535:20100503:164759.630 In latest_service_alarm() 24535:20100503:164759.630 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=12 order by servicealarmid desc limit 1] 24535:20100503:164759.630 Query [txnlev:1] [select priority from triggers where triggerid=109965 and status=0 and value=1] 24535:20100503:164759.630 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=13 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.631 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=13] 24535:20100503:164759.631 In add_service_alarm() 24535:20100503:164759.631 In latest_service_alarm() 24535:20100503:164759.631 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=13 order by servicealarmid desc limit 1] 24535:20100503:164759.631 Query [txnlev:1] [select priority from triggers where triggerid=122561 and status=0 and value=1] 24535:20100503:164759.631 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=19 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.631 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=19] 24535:20100503:164759.631 In add_service_alarm() 24535:20100503:164759.631 In latest_service_alarm() 24535:20100503:164759.631 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=19 order by servicealarmid desc limit 1] 24535:20100503:164759.632 Query [txnlev:1] [select priority from triggers where triggerid=174273 and status=0 and value=1] 24535:20100503:164759.632 Query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=20 and s.serviceid=l.servicedownid order by s.status DESC limit 1] 24535:20100503:164759.632 Query [txnlev:1] [UPDATE services SET status=0 WHERE serviceid=20] 24535:20100503:164759.632 In add_service_alarm() 24535:20100503:164759.632 In latest_service_alarm() 24535:20100503:164759.632 Query [txnlev:1] [select servicealarmid, value from service_alarms where serviceid=20 order by servicealarmid desc limit 1]