Zabbix Server Shutdown

[Villain]

Hello all,

I'm getting the following information in my logs, each morning and I have to restart the zabbix server. Is there something in particular that would cause this problem?

023453:20060828:122608 Evaluation of expression [{11514}>150000] failed [Unable to get value for functionid [11514]]
023453:20060828:122608 Expression [{11514}>150000] cannot be evaluated [Unable to get value for functionid [11514]]
023451:20060828:122659 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 i.nextcheck<=1156793219 and i.status in (0) and i.type not in (2,7) and h.status=0 and h.disable_until<=1156793219 and h.errors_from!=0 and h.hostid=i.hostid and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
023451:20060828:122659 Query failed:Lost connection to MySQL server during query [2013]
023443:20060828:122659 One server process died. Shutting down...
023443:20060828:122659 ZABBIX server is down.

Thanks

[Villain]

I came in this morning, and here are the logs for today:

004327:20060829:202905 Expression [{11450}>150000] cannot be evaluated [Unable to get value for functionid [11450]]
004327:20060829:202905 Evaluation of expression [{11485}>150000] failed [Unable to get value for functionid [11485]]
004327:20060829:202905 Expression [{11485}>150000] cannot be evaluated [Unable to get value for functionid [11485]]
004327:20060829:202905 Query::insert into history (clock,itemid,value) values (1156908545,17712,0.000000)
004327:20060829:202905 Query failed:Lost connection to MySQL server during query [2013]
004327:20060829:202905 Query::select num,value_min,value_avg,value_max from trends where itemid=17712 and clock=1156906800
004327:20060829:202905 Query failed:Can't connect to MySQL server on '10.1.1.80' (111) [2003]
004319:20060829:202905 One server process died. Shutting down...
004319:20060829:202905 ZABBIX server is down.


Is there some reason why Zabbix would continually lose its connection to the database? I have done some checking, and I can't find a problem with MySQL at all. We're running 5.0.22 of mysql for the Zabbix db, if that helps.

Thanks!

[Alexei]

I'm 100% sure this is MySQL related issue. Isn't it the same MySQL 5.x issue already discussed here when MySQL (or a periodic script) deleted everything in /tmp where MySQL for some reason keeps connection related files?

[raminix]

This is definitely something going on with MySQL. Have you checked your MySQL server logs for anything unusual? You're dumping your connection to the Zabbix server, and as soon as that happens the Zabbix server will shutdown.