Ad Widget

Collapse

No Data In Zabbix ( MySQL server has gone away )

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rewilliamscpro
    Junior Member
    • Dec 2015
    • 8

    #1

    No Data In Zabbix ( MySQL server has gone away )

    All, I was setting up SSL on zabbix server and after that started working, data is not being populated.

    zabbix_server.log
    2635:20160315:104643.617 [Z3005] query failed: [2006] MySQL server has gone away [begin;]
    2457:20160315:105228.080 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=28348]
    2274:20160315:105235.304 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=24755]
    2435:20160315:105236.303 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=24756]
    2400:20160315:105308.003 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=28388]
    mysqld logs
    160315 10:46:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    160315 10:46:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    160315 10:46:35 InnoDB: Initializing buffer pool, size = 8.0M
    160315 10:46:35 InnoDB: Completed initialization of buffer pool
    160315 10:46:35 InnoDB: Started; log sequence number 26 2130662082
    160315 10:46:35 [Note] Event Scheduler: Loaded 0 events
    160315 10:46:35 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

    mysql conf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    max_connections=1000
    max_allowed_packet=512M
    wait_timeout=50000
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0

    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    Any help is appreciated. Thanks
    Last edited by rewilliamscpro; 15-03-2016, 18:54.
  • rewilliamscpro
    Junior Member
    • Dec 2015
    • 8

    #2
    Same

    The data is populating but I am still getting the error. Any help is appreciated

    Comment

    Working...