MySQL server has gone away - Zabbix Server

[ariatti]

Hey Guys!

In recent days i have been checking on the zabbix server log the message: MySQL server has gone away. I performed some adjustments in MySQL database (it is a dedicated server) and decreased the some of the messages, but not disappear completely.

Looking a little better, now I found that the error happens in the same query:

[Z3005] query failed: [2006] MySQL server has gone away [select i.itemid, i.type, i.delay, i.delay_flex, i.lastclock, i.interfaceid, h.proxy_hostid from items i, hosts where h i.hostid = h.hostid and h.status = 0 and = 0 and i.status i.value_type not in (2) and (i.lastclock is not null and i.lastclock <1349269991) and (i.type in (7,13,14,3,5,11,8,10,15) or (h.available <> 2 and in i.type (0)) or (h.snmp_available <> 2 and i.type in (1 , 4.6)) or (h.ipmi_available <> 2 and i.type in (12)) or (h.jmx_available <> 2 and i.type in (16))) and not in i.flags (2) and i.itemid between 0 and 99,999,999,999,999]

I ran this query manually and found that the items listed have the check interval equal to and above 1800 seconds.

Anyone have any idea why this is happening only in those cases?

I have a dedicated MySQL server running other databases where no problem. Processing and memory are OK. I have a massive monitoring of MySQL with http://www.fromdual.com/mysql-performance-monitor and have nothing apparently wrong.

Sorry by my bad english

Thank's in advance!

Sincerely,

Marcelo Ariatti

[ariatti]

anyone?

[LenR]

I had this on the it services config, increase max_packet_size in mysql fixed it.

[ariatti]

what value you put it?

mine is in 512 MB.

[ariatti]

it's max_packet_size or max_allowed_packet?

[LenR]

Sorry, I replied from memory, it's the parm for the max SQL "statemnt" size accepted. My error, pasted into a txt file was 3.5M (mostly the sql statement, but some message text also), my old value was 1M, so I set it to 4M.

[ariatti]

OK!

So is the max_allowed_packet

But I believe this is not my problem because I configured to 1GB and the errors keep popping up.

Any idea?