zabbix 1.3.3 dies after adding a standalone host
i add a stand alone host in zabbix and my server inmediatly died.
i dont know where the column "configid" came from, is not on the php scripts and a can't make this happen again.
any ideas?
25230:20070316:094752 Enabling host [nserver2.calipso.com.co]
25240:20070316:094753 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 h.host='nserver2.calipso.com.co' and i.key_='icmpping' and i.status=0 and i.type=3 and configid>=100000000000000*0 and configid<=(100000000000000*0+99999999999999)
25240:20070316:094753 Query failed:PGRES_FATAL_ERROR:ERROR: column "configid" does not exist
25223:20070316:094753 One child process died. Exiting ...
25223:20070316:094755 ZABBIX Server stopped
other problem that is not fatal is this:
11412:20070316:160054 Query::delete from history where oid in (select oid from history where itemid=17739 limit 500)
11412:20070316:160054 Query failed:PGRES_FATAL_ERROR:ERROR: column "oid" does not exist
how are the querys generated to produce errors like the examples above?
i dont know where the column "configid" came from, is not on the php scripts and a can't make this happen again.
any ideas?
25230:20070316:094752 Enabling host [nserver2.calipso.com.co]
25240:20070316:094753 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 h.host='nserver2.calipso.com.co' and i.key_='icmpping' and i.status=0 and i.type=3 and configid>=100000000000000*0 and configid<=(100000000000000*0+99999999999999)
25240:20070316:094753 Query failed:PGRES_FATAL_ERROR:ERROR: column "configid" does not exist
25223:20070316:094753 One child process died. Exiting ...
25223:20070316:094755 ZABBIX Server stopped
other problem that is not fatal is this:
11412:20070316:160054 Query::delete from history where oid in (select oid from history where itemid=17739 limit 500)
11412:20070316:160054 Query failed:PGRES_FATAL_ERROR:ERROR: column "oid" does not exist
how are the querys generated to produce errors like the examples above?