I just noted, that zabbix_server is running, but it stopped polling...
instead it tries to resync to his other nodes (which do not exist)
this is the logfile:
9561:20070305:091932 Executing 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.multiplier,i.snmpv3_securityname,i.snmpv3_securi tylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassp hrase,i.formula,h.available,i.status,i.trapper
_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dn s from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.ip='172.17.8.11' and i.key_
='icmpping' and i.status=0 and i.type=3 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)
9561:20070305:091932 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.hostid,h.st atus,i.value_type,h.errors_from,i.snmp_port,i.delt a,i.prevorgvalue,i.lastclock,i.units,i.multipl
ier,i.snmpv3_securityname,i.snmpv3_securitylevel,i .snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.f ormula,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 h.ip='172.17.8.11' and i.key_='icmppin
g' and i.status=0 and i.type=3 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)
9561:20070305:091932 Query failed:Unknown column 'h.dns' in 'field list' [1054]
9571:20070305:091941 Starting sync with nodes
9571:20070305:091941 In main_eventsender()
9571:20070305:091941 Executing query:begin;
9571:20070305:091941 In get_master_node(0)
9571:20070305:091941 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091941 In main_historysender()
9571:20070305:091941 Executing query:begin;
9571:20070305:091941 In get_master_node(0)
9571:20070305:091941 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091941 Sleeping 5 seconds
9571:20070305:091951 Starting sync with nodes
9571:20070305:091951 In main_eventsender()
9571:20070305:091951 Executing query:begin;
9571:20070305:091951 In get_master_node(0)
9571:20070305:091951 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091951 In main_historysender()
9571:20070305:091951 Executing query:begin;
9571:20070305:091951 In get_master_node(0)
9571:20070305:091951 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091951 Sleeping 5 seconds
9571:20070305:092001 Starting sync with nodes
9571:20070305:092001 In main_eventsender()
[...]
9571:20070305:104012 In get_master_node(0)
9571:20070305:104012 Executing query:select masterid from nodes where nodeid=0
9571:20070305:104012 In main_historysender()
9571:20070305:104012 Executing query:begin;
9571:20070305:104012 In get_master_node(0)
9571:20070305:104012 Executing query:select masterid from nodes where nodeid=0
instead it tries to resync to his other nodes (which do not exist)
this is the logfile:
9561:20070305:091932 Executing 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.multiplier,i.snmpv3_securityname,i.snmpv3_securi tylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassp hrase,i.formula,h.available,i.status,i.trapper
_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dn s from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.ip='172.17.8.11' and i.key_
='icmpping' and i.status=0 and i.type=3 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)
9561:20070305:091932 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.hostid,h.st atus,i.value_type,h.errors_from,i.snmp_port,i.delt a,i.prevorgvalue,i.lastclock,i.units,i.multipl
ier,i.snmpv3_securityname,i.snmpv3_securitylevel,i .snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.f ormula,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 h.ip='172.17.8.11' and i.key_='icmppin
g' and i.status=0 and i.type=3 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)
9561:20070305:091932 Query failed:Unknown column 'h.dns' in 'field list' [1054]
9571:20070305:091941 Starting sync with nodes
9571:20070305:091941 In main_eventsender()
9571:20070305:091941 Executing query:begin;
9571:20070305:091941 In get_master_node(0)
9571:20070305:091941 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091941 In main_historysender()
9571:20070305:091941 Executing query:begin;
9571:20070305:091941 In get_master_node(0)
9571:20070305:091941 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091941 Sleeping 5 seconds
9571:20070305:091951 Starting sync with nodes
9571:20070305:091951 In main_eventsender()
9571:20070305:091951 Executing query:begin;
9571:20070305:091951 In get_master_node(0)
9571:20070305:091951 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091951 In main_historysender()
9571:20070305:091951 Executing query:begin;
9571:20070305:091951 In get_master_node(0)
9571:20070305:091951 Executing query:select masterid from nodes where nodeid=0
9571:20070305:091951 Sleeping 5 seconds
9571:20070305:092001 Starting sync with nodes
9571:20070305:092001 In main_eventsender()
[...]
9571:20070305:104012 In get_master_node(0)
9571:20070305:104012 Executing query:select masterid from nodes where nodeid=0
9571:20070305:104012 In main_historysender()
9571:20070305:104012 Executing query:begin;
9571:20070305:104012 In get_master_node(0)
9571:20070305:104012 Executing query:select masterid from nodes where nodeid=0
Comment