After upgrading from 1.4 to the latest 1.6 version Zabbix-Server consistently stops working after about two days. Then we get thousands of entries in zabbix_server.log such as
No stats are collected any more. Simply restarting zabbix-server solves the problem until it reappears again. The database logs do not show anything and executing the logged queries by hand DOES return results and not NULL. Has anyone an idea what is wrong here?
Code:
16980:20100118:133114 [Z3005] Query failed: [0] Result is NULL [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.history,i.
lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpas
sphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.params,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype,h.ipmi_privilege
,h.ipmi_username,h.ipmi_password,i.ipmi_sensor,i.lastlogsize from hosts h, items i where i.nextcheck<=1263817879 and h.hostid=i.hostid and h.status=0 and i.status in (0,3) and ((h.disable_until<=1
263817874 and h.errors_from=0 and i.type in (0,1,4,6)) or i.type in (3,5,8,10,11)) and (h.proxy_hostid=0 or i.type in (5,8)) and mod(i.itemid,10)=8 and i.key_ not in ('status','icmpping','icmpping
sec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck]
16980:20100118:133114 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.histor
y,i.lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_aut
hpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.params,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype,h.ipmi_privi
lege,h.ipmi_username,h.ipmi_password,i.ipmi_sensor,i.lastlogsize from hosts h, items i where i.nextcheck<=1263817879 and h.hostid=i.hostid and h.status=0 and i.status in (0,3) and ((h.disable_unti
l<=1263817874 and h.errors_from=0 and i.type in (0,1,4,6)) or i.type in (3,5,8,10,11)) and (h.proxy_hostid=0 or i.type in (5,8)) and mod(i.itemid,10)=8 and i.key_ not in ('status','icmpping','icmp
pingsec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck]