Problem: 1.3.2 server dies constantly

[clahti]

Here are the last few log entries in /var/log/zabbix/zabbix_server.log just before it dies:

 31716:20070207:201240 Query failed:Duplicate entry '0' for key 1 [1062]
 31726:20070207:201242 Query::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_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='it.matissenetworks.com' and i.key_='io_rrqms[sda]' and i.status=0 and i.type in (2,7) and hostid>=100000000000000*0 and hostid<=(100000000000000*0+99999999999999)
 31726:20070207:201242 Query failed:Column 'hostid' in where clause is ambiguous [1052]
 31728:20070207:201242 Query::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_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='it.matissenetworks.com' and i.key_='io_wrqms[sda]' and i.status=0 and i.type in (2,7) and hostid>=100000000000000*0 and hostid<=(100000000000000*0+99999999999999)
 31728:20070207:201242 Query failed:Column 'hostid' in where clause is ambiguous [1052]
 31722:20070207:201242 Query::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_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='it.matissenetworks.com' and i.key_='io_writes[sda]' and i.status=0 and i.type in (2,7) and hostid>=100000000000000*0 and hostid<=(100000000000000*0+99999999999999)
 31722:20070207:201242 Query failed:Column 'hostid' in where clause is ambiguous [1052]
 31724:20070207:201242 Query::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_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='it.matissenetworks.com' and i.key_='io_rd_sects[sda]' and i.status=0 and i.type in (2,7) and hostid>=100000000000000*0 and hostid<=(100000000000000*0+99999999999999)
 31724:20070207:201242 Query failed:Column 'hostid' in where clause is ambiguous [1052]
 31713:20070207:201242 One child process died. Exiting ...
 31713:20070207:201244 ZABBIX Server stopped

[clahti]

I think the problem is related to a zabbix_sender script I am trying to write. Although I don't believe an incorrect MySql select statement should cause the server to die this seems to be the case. At any rate please disregard

[Alexei]

Thanks for reporting this. Fixed.