Zabbix_server 1.1 dies with query error
The zabbix_server repeatedly dies after starting, always with the following in the zabbix_server.log:
015598:20060605:131157 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 from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='TRIGGER'] returned empty result
015598:20060605:131157 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 from hosts h, items i where h.host='.com','ZABBI²Tq' and h.hostid=i.hostid and i.key_='TRIGGER'
015598:20060605:131157 Query failed:You have an error in your SQL syntax near ''ZABBI²Tq' and h.hostid=i.hostid and i.key_='TRIGGER'' at line 1 [1064]
015572:20060605:131157 One server process died. Shutting down...
015572:20060605:131157 ZABBIX server is down.
Any ideas?
StanZoid
015598:20060605:131157 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 from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='TRIGGER'] returned empty result
015598:20060605:131157 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 from hosts h, items i where h.host='.com','ZABBI²Tq' and h.hostid=i.hostid and i.key_='TRIGGER'
015598:20060605:131157 Query failed:You have an error in your SQL syntax near ''ZABBI²Tq' and h.hostid=i.hostid and i.key_='TRIGGER'' at line 1 [1064]
015572:20060605:131157 One server process died. Shutting down...
015572:20060605:131157 ZABBIX server is down.
Any ideas?
StanZoid
?
Comment