Hi,
i have a fresh Zabbix 2.0.2 installation running (Debian6).
But i cannot read any data from the hosts (zabbix_agent is running), an older Zabbix installation is monitoring the hosts, so it's defenitly running.
I also dropped the databasea and recreated it with the schema.sql, but it won't help.
Maybe someone can help me with this problem, here is also the logfile, at least it seems to be something with the database.
But i have no solution for this.
Logfile:
Best regards
Zabbbix
i have a fresh Zabbix 2.0.2 installation running (Debian6).
But i cannot read any data from the hosts (zabbix_agent is running), an older Zabbix installation is monitoring the hosts, so it's defenitly running.
I also dropped the databasea and recreated it with the schema.sql, but it won't help.
Maybe someone can help me with this problem, here is also the logfile, at least it seems to be something with the database.
But i have no solution for this.
Logfile:
Code:
29995:20120821:101049.932 [Z3005] Query failed: [1054] Unknown column 'unique_dcheckid' in 'field list' [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1345536649 or nextcheck>1345536649+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
29978:20120821:101049.932 [Z3005] Query failed: [1054] Unknown column 'useip' in 'field list' [select hostid,proxy_hostid,host,useip,ip,dns,port,status,useipmi,ipmi_ip,ipmi_port,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until from hosts where status in (0) and hostid between 000000000000000 and 099999999999999 order by hostid]
29978:20120821:101049.933 [Z3005] Query failed: [1054] Unknown column 'i.snmp_port' in 'field list' [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.snmp_port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.status,i.authtype,i.username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999 order by i.itemid]
29992:20120821:101100.497 [Z3005] Query failed: [1054] Unknown column 'h.port' in 'field list' [select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i, functions f where h.hostid=i.hostid and h.status=0 and i.status=0 and f.function in ('nodata','date','dayofweek','time','now') and i.itemid=f.itemid and (h.maintenance_status=0 or h.maintenance_type=0) and h.hostid between 000000000000000 and 099999999999999]
29988:20120821:101104.002 [Z3005] Query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`autoreg_host`, CONSTRAINT `c_autoreg_host_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into autoreg_host (autoreg_hostid,proxy_hostid,host) values (52,0,'localhost')]
29988:20120821:101104.031 Sending list of active checks to [127.0.0.1] failed: host [localhost] not found
Zabbbix