Hi , could someone explain me what's wrong ? how to fix it ? Everything seems to be working and monitoring correctly, but i dont like this logs in my zabbix_server.log
Zabbix Server Node 1 - 1.8.9 , Distributed setup , Zabbix is on dedicated machine with MySQL
Machines below are checked via Node1
Mysql Show status:
http://pastebin.com/e35Br10X
Mysql my.cnf
http://pastebin.com/agbcUj3V
Best Regards.
Thanks.
Zabbix Server Node 1 - 1.8.9 , Distributed setup , Zabbix is on dedicated machine with MySQL
Machines below are checked via Node1
Code:
1230:20111216:095152.784 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='sappsm.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1229:20111216:095200.184 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='esx05.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1296:20111216:095200.396 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='esx03.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1239:20111216:095211.063 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='fsnit.domain.krakow' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1227:20111216:095227.593 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='fgusapwiki.domain.krakow' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1242:20111216:095235.573 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='debianpptpd.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999]
Code:
1245:20111216:095528.645 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='sapcsp.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1247:20111216:095547.586 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='sappwp.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1215:20111216:095552.938 [Z3005] query failed: [2006] MySQL server has gone away [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='db01.domain.local' and i.key_='NetOut02')) and h.hostid between 100000000000000 and 199999999999999] 1252:20111216:095605.130 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='db01.domain.local' and status in (0,1) and proxy_hostid=0 and hostid between 100000000000000 and 199999999999999] 1207:20111216:095610.069 [Z3005] query failed: [2006] MySQL server has gone away [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='dc01.domain.local' and i.key_='NetOut01')) and h.hostid between 100000000000000 and 199999999999999]
Code:
1222:20111216:095649.028 [Z3005] query failed: [2006] MySQL server has gone away [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='dc01.domain.local' and i.key_='NetIn01')) and h.hostid between 100000000000000 and 199999999999999] 1144:20111216:095651.006 [Z3005] query failed: [2006] MySQL server has gone away [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='dc01.domain.local' and i.key_='NetIn01')) and h.hostid between 100000000000000 and 199999999999999]
Mysql Show status:
http://pastebin.com/e35Br10X
Mysql my.cnf
http://pastebin.com/agbcUj3V
Best Regards.
Thanks.