this continues to be a problem for us on suse 10.2......
4997:20070522:175848 End substitute_simple_macros (result:{12226}<1)
4997:20070522:175848 In substitute_functions({12226}<1)
4997:20070522:175848 Query [select 0,lastvalue from functions where functionid=12226]
5018:20070522:175848 In delete_history(history_log,30064781141,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from history_log where itemid=5067507908254639957]
4997:20070522:175848 End substitute_functions [0<1]
4997:20070522:175848 In evaluate(0<1)
4997:20070522:175848 In evaluate_simple(0<1)
5018:20070522:175848 In delete_history(trends,1567663073109,1179871128,-1210266544)
4997:20070522:175848 In evaluate_simple(0)
5018:20070522:175848 Query [select min(clock) from trends where itemid=5067507908254639957]
4997:20070522:175848 In evaluate_simple(1)
4997:20070522:175848 Result [1.000000]
4997:20070522:175848 End evaluate(result:1.000000)
4997:20070522:175848 End evaluate_expression(result:1)
5018:20070522:175848 In delete_history(history,30064781142,1179871128,-1210266544)
4997:20070522:175848 In update_trigger_value(triggerid:13137,old:2,new:1,1 179871128)
4997:20070522:175848 In latest_event()
5018:20070522:175848 Query [select min(clock) from history where itemid=5067507908254639958]
4997:20070522:175848 Query [select eventid,value,clock from events where source=0 and object=0 and objectid=13137 order by clock limit 20]
5018:20070522:175848 In delete_history(history_uint,30064781142,1179871128 ,-1210266544)
5018:20070522:175848 Query [select min(clock) from history_uint where itemid=5067507908254639958]
5018:20070522:175848 In delete_history(history_str,30064781142,1179871128,-1210266544)
4997:20070522:175848 tr value [2] event_prev_value [1] event_last_status [2] new_value [1]
5018:20070522:175848 Query [select min(clock) from history_str where itemid=5067507908254639958]
4997:20070522:175848 Updating trigger
4997:20070522:175848 Query [update triggers set value=1,lastchange=1179871128,error='' where triggerid=13137]
5018:20070522:175848 In delete_history(history_str,30064781142,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from history_str where itemid=5067507908254639958]
5018:20070522:175848 In delete_history(history_log,30064781142,1179871128,-1210266544)
4997:20070522:175848 In process_event(eventid:0,object:0,objectid:13137)
5018:20070522:175848 Query [select min(clock) from history_log where itemid=5067507908254639958]
4997:20070522:175848 Query [select description,priority,comments,url from triggers where triggerid=13137]
5018:20070522:175848 In delete_history(trends,1567663073110,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from trends where itemid=5067507908254639958]
4997:20070522:175848 In latest_event()
4997:20070522:175848 Query [select eventid,value,clock from events where source=0 and object=0 and objectid=13137 order by clock limit 20]
5018:20070522:175848 In delete_history(history,30064781143,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from history where itemid=5067507908254639959]
5018:20070522:175848 In delete_history(history_uint,30064781143,1179871128 ,-1210266544)
4997:20070522:175848 In DBget_maxid(events,eventid)
5018:20070522:175848 Query [select min(clock) from history_uint where itemid=5067507908254639959]
4995:20070522:175848 Query [update trends set num=353, value_min=1047.144600, value_avg=2691.866375, value_max=129214.800000 where itemid=19296 and clock=1179867600]
4996:20070522:175848 In get_value()
4997:20070522:175848 Query [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
4998:20070522:175848 In get_value()
4998:20070522:175848 In get_value_agent(host:appP1.nyc1.xxxxxx.com,ip:01.0 1.1.65,key:vfs.fs.size[/var,free]
5000:20070522:175848 In get_value()
5000:20070522:175848 In get_value_agent(host:webI1.nyc1.xxxxxx.com,ip:01.0 1.1.153,key:vfs.fs.size[/opt,free]
4996:20070522:175848 In get_value_agent(host:appP1.nyc1.xxxxxx.com,ip:01.0 1.1.65,key:vfs.file.cksum[/etc/passwd]
5018:20070522:175848 In delete_history(history_str,30064781143,1179871128,-1210266544)
5001:20070522:175848 Query [select description,priority,comments,url from triggers where triggerid=13005]
5034:20070522:175848 End process_value()
5034:20070522:175848 End process_step_data()
5034:20070522:175848 out of memory. requested '-1211387583' bytes.
5001:20070522:175848 In latest_event()
5001:20070522:175848 Query [select eventid,value,clock from events where source=0 and object=0 and objectid=13005 order by clock limit 20]
4998:20070522:175848 Sending [vfs.fs.size[/var,free]
]
4998:20070522:175848 Before read
5036:20070522:175848 End process_value()
5036:20070522:175848 In process_value(itemid:19415)
5036:20070522:175848 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where h.status=0 and h.hostid=i.hostid and i.status=0 and i.type=9 and i.itemid=19415 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
4997:20070522:175848 Query [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
4997:20070522:175848 Query [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
4996:20070522:175848 Sending [vfs.file.cksum[/etc/passwd]
]
4996:20070522:175848 Before read
4992:20070522:175848 One child process died. Exiting ...
4997:20070522:175848 Got signal. Exiting ...
5007:20070522:175848 Got signal. Exiting ...
5005:20070522:175848 Got signal. Exiting ...
4995:20070522:175848 Got signal. Exiting ...
5009:20070522:175848 Got signal. Exiting ...
5011:20070522:175848 Got signal. Exiting ...
5002:20070522:175848 Got signal. Exiting ...
5013:20070522:175848 Got signal. Exiting ...
5036:20070522:175848 Query [begin;]
5036:20070522:175848 In process_new_value(web.test.time[Zabbix,zabbix-server,resp])
5036:20070522:175848 In add_history(web.test.time[Zabbix,zabbix-server,resp],,0,2)
5016:20070522:175848 Got signal. Exiting ...
5036:20070522:175848 In add_history(19415,DOUBLE:-0.000000)
5036:20070522:175848 In add_history()
5036:20070522:175848 Query [insert into history (clock,itemid,value) values (1179871128,19415,0.134034)]
5036:20070522:175848 In add_trend()
5036:20070522:175848 Query [select num,value_min,value_avg,value_max from trends where itemid=19415 and clock=1179867600]
4998:20070522:175848 Got signal. Exiting ...
5020:20070522:175848 Got signal. Exiting ...
5032:20070522:175848 Got signal. Exiting ...
4996:20070522:175848 Got signal. Exiting ...
5023:20070522:175848 Got signal. Exiting ...
5028:20070522:175848 Got signal. Exiting ...
5024:20070522:175848 Got signal. Exiting ...
5036:20070522:175848 Got signal. Exiting ...
5030:20070522:175848 Got signal. Exiting ...
5037:20070522:175848 Got signal. Exiting ...
5001:20070522:175848 Got signal. Exiting ...
5000:20070522:175848 Got signal. Exiting ...
5018:20070522:175848 Got signal. Exiting ...
4992:20070522:175850 ZABBIX Server stopped
4997:20070522:175848 End substitute_simple_macros (result:{12226}<1)
4997:20070522:175848 In substitute_functions({12226}<1)
4997:20070522:175848 Query [select 0,lastvalue from functions where functionid=12226]
5018:20070522:175848 In delete_history(history_log,30064781141,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from history_log where itemid=5067507908254639957]
4997:20070522:175848 End substitute_functions [0<1]
4997:20070522:175848 In evaluate(0<1)
4997:20070522:175848 In evaluate_simple(0<1)
5018:20070522:175848 In delete_history(trends,1567663073109,1179871128,-1210266544)
4997:20070522:175848 In evaluate_simple(0)
5018:20070522:175848 Query [select min(clock) from trends where itemid=5067507908254639957]
4997:20070522:175848 In evaluate_simple(1)
4997:20070522:175848 Result [1.000000]
4997:20070522:175848 End evaluate(result:1.000000)
4997:20070522:175848 End evaluate_expression(result:1)
5018:20070522:175848 In delete_history(history,30064781142,1179871128,-1210266544)
4997:20070522:175848 In update_trigger_value(triggerid:13137,old:2,new:1,1 179871128)
4997:20070522:175848 In latest_event()
5018:20070522:175848 Query [select min(clock) from history where itemid=5067507908254639958]
4997:20070522:175848 Query [select eventid,value,clock from events where source=0 and object=0 and objectid=13137 order by clock limit 20]
5018:20070522:175848 In delete_history(history_uint,30064781142,1179871128 ,-1210266544)
5018:20070522:175848 Query [select min(clock) from history_uint where itemid=5067507908254639958]
5018:20070522:175848 In delete_history(history_str,30064781142,1179871128,-1210266544)
4997:20070522:175848 tr value [2] event_prev_value [1] event_last_status [2] new_value [1]
5018:20070522:175848 Query [select min(clock) from history_str where itemid=5067507908254639958]
4997:20070522:175848 Updating trigger
4997:20070522:175848 Query [update triggers set value=1,lastchange=1179871128,error='' where triggerid=13137]
5018:20070522:175848 In delete_history(history_str,30064781142,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from history_str where itemid=5067507908254639958]
5018:20070522:175848 In delete_history(history_log,30064781142,1179871128,-1210266544)
4997:20070522:175848 In process_event(eventid:0,object:0,objectid:13137)
5018:20070522:175848 Query [select min(clock) from history_log where itemid=5067507908254639958]
4997:20070522:175848 Query [select description,priority,comments,url from triggers where triggerid=13137]
5018:20070522:175848 In delete_history(trends,1567663073110,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from trends where itemid=5067507908254639958]
4997:20070522:175848 In latest_event()
4997:20070522:175848 Query [select eventid,value,clock from events where source=0 and object=0 and objectid=13137 order by clock limit 20]
5018:20070522:175848 In delete_history(history,30064781143,1179871128,-1210266544)
5018:20070522:175848 Query [select min(clock) from history where itemid=5067507908254639959]
5018:20070522:175848 In delete_history(history_uint,30064781143,1179871128 ,-1210266544)
4997:20070522:175848 In DBget_maxid(events,eventid)
5018:20070522:175848 Query [select min(clock) from history_uint where itemid=5067507908254639959]
4995:20070522:175848 Query [update trends set num=353, value_min=1047.144600, value_avg=2691.866375, value_max=129214.800000 where itemid=19296 and clock=1179867600]
4996:20070522:175848 In get_value()
4997:20070522:175848 Query [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
4998:20070522:175848 In get_value()
4998:20070522:175848 In get_value_agent(host:appP1.nyc1.xxxxxx.com,ip:01.0 1.1.65,key:vfs.fs.size[/var,free]
5000:20070522:175848 In get_value()
5000:20070522:175848 In get_value_agent(host:webI1.nyc1.xxxxxx.com,ip:01.0 1.1.153,key:vfs.fs.size[/opt,free]
4996:20070522:175848 In get_value_agent(host:appP1.nyc1.xxxxxx.com,ip:01.0 1.1.65,key:vfs.file.cksum[/etc/passwd]
5018:20070522:175848 In delete_history(history_str,30064781143,1179871128,-1210266544)
5001:20070522:175848 Query [select description,priority,comments,url from triggers where triggerid=13005]
5034:20070522:175848 End process_value()
5034:20070522:175848 End process_step_data()
5034:20070522:175848 out of memory. requested '-1211387583' bytes.
5001:20070522:175848 In latest_event()
5001:20070522:175848 Query [select eventid,value,clock from events where source=0 and object=0 and objectid=13005 order by clock limit 20]
4998:20070522:175848 Sending [vfs.fs.size[/var,free]
]
4998:20070522:175848 Before read
5036:20070522:175848 End process_value()
5036:20070522:175848 In process_value(itemid:19415)
5036:20070522:175848 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where h.status=0 and h.hostid=i.hostid and i.status=0 and i.type=9 and i.itemid=19415 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
4997:20070522:175848 Query [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
4997:20070522:175848 Query [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
4996:20070522:175848 Sending [vfs.file.cksum[/etc/passwd]
]
4996:20070522:175848 Before read
4992:20070522:175848 One child process died. Exiting ...
4997:20070522:175848 Got signal. Exiting ...
5007:20070522:175848 Got signal. Exiting ...
5005:20070522:175848 Got signal. Exiting ...
4995:20070522:175848 Got signal. Exiting ...
5009:20070522:175848 Got signal. Exiting ...
5011:20070522:175848 Got signal. Exiting ...
5002:20070522:175848 Got signal. Exiting ...
5013:20070522:175848 Got signal. Exiting ...
5036:20070522:175848 Query [begin;]
5036:20070522:175848 In process_new_value(web.test.time[Zabbix,zabbix-server,resp])
5036:20070522:175848 In add_history(web.test.time[Zabbix,zabbix-server,resp],,0,2)
5016:20070522:175848 Got signal. Exiting ...
5036:20070522:175848 In add_history(19415,DOUBLE:-0.000000)
5036:20070522:175848 In add_history()
5036:20070522:175848 Query [insert into history (clock,itemid,value) values (1179871128,19415,0.134034)]
5036:20070522:175848 In add_trend()
5036:20070522:175848 Query [select num,value_min,value_avg,value_max from trends where itemid=19415 and clock=1179867600]
4998:20070522:175848 Got signal. Exiting ...
5020:20070522:175848 Got signal. Exiting ...
5032:20070522:175848 Got signal. Exiting ...
4996:20070522:175848 Got signal. Exiting ...
5023:20070522:175848 Got signal. Exiting ...
5028:20070522:175848 Got signal. Exiting ...
5024:20070522:175848 Got signal. Exiting ...
5036:20070522:175848 Got signal. Exiting ...
5030:20070522:175848 Got signal. Exiting ...
5037:20070522:175848 Got signal. Exiting ...
5001:20070522:175848 Got signal. Exiting ...
5000:20070522:175848 Got signal. Exiting ...
5018:20070522:175848 Got signal. Exiting ...
4992:20070522:175850 ZABBIX Server stopped
Comment