Any idea why I see this at different times once a day?
-----
016704:20060811:220000 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oi
d,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.las
tclock,i.units,i.multiplier,i.snmpv3_securityname, i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.s nmpv3_privpassphrase,i.formula,h.a
vailable,i.status,i.trapper_hosts,i.logtimefmt,i.v aluemapid from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='s
nmptraps' and i.key_='snmptraps' and i.status=0 and i.type in (2,7)
016704:20060811:220000 Query failed:MySQL server has gone away [2006]
016693:20060811:220000 One server process died. Shutting down...
016693:20060811:220000 ZABBIX server is down.
-----
FWIW:
# mysql -V
mysql Ver 14.12 Distrib 5.0.18, for suse-linux (i686) using readline 5.1
TIA!
-----
016704:20060811:220000 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oi
d,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.las
tclock,i.units,i.multiplier,i.snmpv3_securityname, i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.s nmpv3_privpassphrase,i.formula,h.a
vailable,i.status,i.trapper_hosts,i.logtimefmt,i.v aluemapid from hosts h, items i where h.status=0 and h.hostid=i.hostid and h.host='s
nmptraps' and i.key_='snmptraps' and i.status=0 and i.type in (2,7)
016704:20060811:220000 Query failed:MySQL server has gone away [2006]
016693:20060811:220000 One server process died. Shutting down...
016693:20060811:220000 ZABBIX server is down.
-----
FWIW:
# mysql -V
mysql Ver 14.12 Distrib 5.0.18, for suse-linux (i686) using readline 5.1
TIA!