Ad Widget

Collapse

Errors - MySQL - server has gone away Z3005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • buczo
    Junior Member
    • Oct 2011
    • 2

    #1

    Errors - MySQL - server has gone away Z3005

    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

    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.
Working...