"MySQL server has gone away" - Backend on MySQL Galera via HAProxy
We are installing a new Zabbix (2.0.6 on Debian Wheezy from wheezy-backports repo) and with the backend DB hosted by a 2-node MySQL Galera cluster which the Zabbix server accesses via HAProxy (HAProxy on the same server as Zabbix, the Galera cluster hosted separately).
Our log level is currently at DEBUG during the installation & configuration and we are getting a lot of the below errors in the Zabbix Server log:
This was with a very simply HAProxy config with roundrobin balancing. When we marked one of the Galera servers as 'backup' only, it massively reduced the errors, but didn't solve the issue altogether.
Does anyone have experience with this issue and any ideas for us to try and solve it, or is it safe to ignore in that when Zabbix fails with this error, it tries the MySQL connection again?
Many thanks.
Our log level is currently at DEBUG during the installation & configuration and we are getting a lot of the below errors in the Zabbix Server log:
Code:
23570:20130711:214200.284 [Z3005] query failed: [2006] MySQL server has gone away [select m.maintenanceid,m.maintenance_type,m.active_since,tp.timeperiod_type,tp.every,tp.month,tp.dayofweek,tp.day,tp.start_time,tp.period,tp.start_date from maintenances m,maintenances_windows mw,timeperiods tp where m.maintenanceid=mw.maintenanceid and mw.timeperiodid=tp.timeperiodid and m.active_since<=1373571720 and m.active_till>1373571720] 23572:20130711:214226.714 [Z3005] query failed: [2006] MySQL server has gone away [select distinct r.druleid,r.iprange,r.name,c.dcheckid from drules r left join dchecks c on c.druleid=r.druleid and uniq=1 where r.proxy_hostid is null and r.status=0 and (r.nextcheck<=1373571746 or r.nextcheck>1373571746+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999] 23554:20130711:214229.565 [Z3005] query failed: [2006] MySQL server has gone away [select alert_history,event_history,refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5 from config where 1=1 and configid between 0 and 99999999999999] 23570:20130711:214300.290 [Z3005] query failed: [2006] MySQL server has gone away [select m.maintenanceid,m.maintenance_type,m.active_since,tp.timeperiod_type,tp.every,tp.month,tp.dayofweek,tp.day,tp.start_time,tp.period,tp.start_date from maintenances m,maintenances_windows mw,timeperiods tp where m.maintenanceid=mw.maintenanceid and mw.timeperiodid=tp.timeperiodid and m.active_since<=1373571780 and m.active_till>1373571780] 23572:20130711:214326.720 [Z3005] query failed: [2006] MySQL server has gone away [select distinct r.druleid,r.iprange,r.name,c.dcheckid from drules r left join dchecks c on c.druleid=r.druleid and uniq=1 where r.proxy_hostid is null and r.status=0 and (r.nextcheck<=1373571806 or r.nextcheck>1373571806+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999] 23554:20130711:214329.572 [Z3005] query failed: [2006] MySQL server has gone away [select alert_history,event_history,refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5 from config where 1=1 and configid between 0 and 99999999999999] 23570:20130711:214400.296 [Z3005] query failed: [2006] MySQL server has gone away [select m.maintenanceid,m.maintenance_type,m.active_since,tp.timeperiod_type,tp.every,tp.month,tp.dayofweek,tp.day,tp.start_time,tp.period,tp.start_date from maintenances m,maintenances_windows mw,timeperiods tp where m.maintenanceid=mw.maintenanceid and mw.timeperiodid=tp.timeperiodid and m.active_since<=1373571840 and m.active_till>1373571840] 23572:20130711:214426.726 [Z3005] query failed: [2006] MySQL server has gone away [select distinct r.druleid,r.iprange,r.name,c.dcheckid from drules r left join dchecks c on c.druleid=r.druleid and uniq=1 where r.proxy_hostid is null and r.status=0 and (r.nextcheck<=1373571866 or r.nextcheck>1373571866+r.delay) and mod(r.druleid,1)=0 and r.druleid between 0 and 99999999999999] 23554:20130711:214429.580 [Z3005] query failed: [2006] MySQL server has gone away [select alert_history,event_history,refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5 from config where 1=1 and configid between 0 and 99999999999999]
Does anyone have experience with this issue and any ideas for us to try and solve it, or is it safe to ignore in that when Zabbix fails with this error, it tries the MySQL connection again?
Many thanks.
Comment