30332:20111104:231421.577 escalator #1 spent 0.000580 seconds while processing escalations
 30332:20111104:231421.577 sleeping for 3 seconds
 30332:20111104:231424.577 In process_escalations()
 30332:20111104:231424.578 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1320437664 and escalationid between 000000000000000 and 099999999999999]
 30332:20111104:231424.578 query [txnlev:1] [begin;]
 30332:20111104:231424.578 In execute_escalation()
 30332:20111104:231424.578 query [txnlev:1] [select source from events where eventid=144989]
 30332:20111104:231424.579 query [txnlev:1] [select description,status from triggers where triggerid=13141]
 30332:20111104:231424.579 query [txnlev:1] [select i.description from items i,functions f,triggers t where t.triggerid=13141 and f.triggerid=t.triggerid and i.itemid=f.itemid and i.status=1]
 30332:20111104:231424.579 query [txnlev:1] [select h.host from hosts h,items i,functions f,triggers t where t.triggerid=13141 and t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=h.hostid and h.status=1]
 30332:20111104:231424.580 query [txnlev:1] [select actionid,eventsource,esc_period,def_shortdata,def_longdata,recovery_msg,status,name from actions where actionid=7]
 30332:20111104:231424.580 query [txnlev:1] [select eventid,source,object,objectid,clock,value,acknowledged from events where eventid=144989]
 30332:20111104:231424.580 query [txnlev:1] [select description,expression,priority,comments,url from triggers where triggerid=13141]
 30332:20111104:231424.581 In substitute_simple_macros() data:'{TRIGGER.NAME}: {TRIGGER.STATUS}'
 30332:20111104:231424.581 In substitute_simple_macros() data:'Tests housekepper'
 30332:20111104:231424.581 query [txnlev:1] [select expression from triggers where triggerid=13141]
 30332:20111104:231424.581 End substitute_simple_macros() data:'Tests housekepper: PROBLEM'
 30332:20111104:231424.581 In substitute_simple_macros() data:'{EVENT.ID}
 30332:20111104:231424.581 In substitute_simple_macros() data:'Tests housekepper'
 30332:20111104:231424.581 query [txnlev:1] [select expression from triggers where triggerid=13141]
 30332:20111104:231424.581 In DBget_item_value()
 30332:20111104:231424.581 In trigger_get_N_functionid() expression:'{12422}>0' N_functionid:1
 30332:20111104:231424.581 trigger_get_N_functionid() functionid:12422
 30332:20111104:231424.581 End of trigger_get_N_functionid():SUCCEED
 30332:20111104:231424.581 query [txnlev:1] [select i.itemid,i.value_type,i.valuemapid,i.units from items i,functions f where i.itemid=f.itemid and f.functionid=12422]
 30332:20111104:231424.582 In DBget_history()
 30332:20111104:231424.582 query [txnlev:1] [select value from history where itemid=22585 and clock<=1320437660 order by itemid,clock desc limit 1]
 30332:20111104:231424.582 End of DBget_history()
 30332:20111104:231424.582 In replace_value_by_map()
 30332:20111104:231424.582 End of replace_value_by_map() value:'1'
 30332:20111104:231424.582 In add_value_suffix() value:'1' units:''
 30332:20111104:231424.582 End of add_value_suffix():FAIL value:'1'
 30332:20111104:231424.582 In DBfree_history()
 30332:20111104:231424.582 End of DBfree_history()
 30332:20111104:231424.582 End of DBget_item_value():SUCCEED
 30332:20111104:231424.582 In substitute_simple_macros() data:NULL
 30332:20111104:231424.582 End substitute_simple_macros() data:'144989
 30332:20111104:231424.582 In execute_operations()
 30332:20111104:231424.582 query [txnlev:1] [select operationid,operationtype,object,objectid,default_msg,shortdata,longdata,esc_period,evaltype from operations where actionid=7 and operationtype in (0,1)]
 30332:20111104:231424.583 In check_operation_conditions(): operationid [16]
 30332:20111104:231424.583 query [txnlev:1] [select conditiontype,operator,value from opconditions where operationid=16 order by conditiontype]
 30332:20111104:231424.583 End of check_operation_conditions():SUCCEED
 30332:20111104:231424.583 Conditions match our event. Execute operation.
 30332:20111104:231424.583 In substitute_simple_macros() data:'{TRIGGER.NAME}: {TRIGGER.STATUS}'
 30332:20111104:231424.583 In substitute_simple_macros() data:'Tests housekepper'
 30332:20111104:231424.583 query [txnlev:1] [select expression from triggers where triggerid=13141]
 30332:20111104:231424.583 End substitute_simple_macros() data:'Tests housekepper: PROBLEM'
 30332:20111104:231424.583 In substitute_simple_macros() data:'{TRIGGER.NAME}: {TRIGGER.STATUS}
 30332:20111104:231424.583 In substitute_simple_macros() data:'Tests housekepper'
 30332:20111104:231424.583 query [txnlev:1] [select expression from triggers where triggerid=13141]
 30332:20111104:231424.583 In DBget_item_lastvalue()
 30332:20111104:231424.583 In trigger_get_N_functionid() expression:'{12422}>0' N_functionid:1
 30332:20111104:231424.583 trigger_get_N_functionid() functionid:12422
 30332:20111104:231424.583 End of trigger_get_N_functionid():SUCCEED
 30332:20111104:231424.583 query [txnlev:1] [select i.itemid,i.value_type,i.valuemapid,i.units,i.lastvalue from items i,functions f where i.itemid=f.itemid and f.functionid=12422]
 30332:20111104:231424.584 In replace_value_by_map()
 30332:20111104:231424.584 End of replace_value_by_map() value:'1'
 30332:20111104:231424.584 In add_value_suffix() value:'1' units:''
 30332:20111104:231424.584 End of add_value_suffix():FAIL value:'1'
 30332:20111104:231424.584 End of DBget_item_lastvalue():SUCCEED
 30332:20111104:231424.584 In substitute_simple_macros() data:NULL
 30332:20111104:231424.584 End substitute_simple_macros() data:'Tests housekepper: PROBLEM
 30332:20111104:231424.584 query [txnlev:1] [select mediatypeid from opmediatypes where operationid=16]
 30332:20111104:231424.584 In add_user_msg()
 30332:20111104:231424.584 query [txnlev:1] [select count(*) from usrgrp g,users_groups ug where ug.userid=1 and g.usrgrpid = ug.usrgrpid and g.users_status=1]
 30332:20111104:231424.584 In get_trigger_permission()
 30332:20111104:231424.584 query [txnlev:1] [select distinct i.hostid from items i,functions f where i.itemid=f.itemid and f.triggerid=13141]
 30332:20111104:231424.585 In get_host_permission()
 30332:20111104:231424.585 query [txnlev:1] [select type from users where userid=1]
 30332:20111104:231424.585 End of get_host_permission():rw
 30332:20111104:231424.585 End of get_trigger_permission():rw
 30332:20111104:231424.585 End of add_user_msg()
 30332:20111104:231424.585 In add_message_alert()
 30332:20111104:231424.585 query [txnlev:1] [select mediatypeid,sendto,severity,period from media where active=0 and userid=1 and mediatypeid=4]
 30332:20111104:231424.585 Trigger severity [2] Media severity [63] Period [1-7,00:00-23:59;]
 30332:20111104:231424.585 In check_time_period() period:'1-7,00:00-23:59;'
 30332:20111104:231424.585 5,23:14
 30332:20111104:231424.585 period [1-7,00:00-23:59;]
 30332:20111104:231424.585 1-7,0:0-23:59
 30332:20111104:231424.585 End of check_time_period():SUCCEED
 30332:20111104:231424.585 In DCget_nextid() table:'alerts' num:1
 30332:20111104:231424.585 End of DCget_nextid() table:'alerts' [126481:126481]
 30332:20111104:231424.585 query [txnlev:1] [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (126481,7,144989,1,1320437664,4,'it@domain.com','Tests housekepper: PROBLEM','144989
 30332:20111104:231424.588 End of add_message_alert()
 30332:20111104:231424.588 End of execute_operations()
 30332:20111104:231424.588 End of execute_escalation()
 30332:20111104:231424.588 query [txnlev:1] [update escalations set status=2,esc_step=0,nextcheck=0 where escalationid=2 and status=0]
 30332:20111104:231424.589 query [txnlev:1] [commit;]
 30332:20111104:231424.590 End of process_escalations()
 30332:20111104:231424.590 escalator #1 spent 0.012482 seconds while processing escalations
 30332:20111104:231424.590 sleeping for 3 seconds