MySQL-Server gone away

[macindy]

HI everybody!

I always get this error:

18292:20091130:180431 [Z3005] Query failed: [2006] MySQL server has gone away [select druleid,iprange,delay,nextcheck,name,status from drules where proxy_hostid=0 and status=0 and (nextcheck<=1259600671 or nextcheck>1259600671+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
18292:20091130:180431 Database is down. Retrying in 10 seconds

What could it be? My MySQL-DB works well and is running...

[macindy]

well - i just reconfigured my zabbix_agent.conf and put the listen-ip in it. now seems working...

[Floppe]

How can an agent config file make diffrence in how server uses mysql connection.

My server spits out mysql server gone away too after upgrading to 1.8. I would file this as a bug cause I don't believe zabbix could be idle so long that mysql goes away when mysql is installed on localhost.

// Floppe

[rrr]

I have the same problem, in sporadic intervals I've got this message too.

[nmail_uk]

I've had this in other applications - Zabbix could be hitting a bug in MySQL which is causing it (mysql) to crash.

If possible and you're MySQL is fairly low-traffic, set up query logging, then the next time you get a message like that in your Zabbix log, compare the timestamp with your MySQL query log and see what the last query was to run before the crash.