Ad Widget

Collapse

Failed to connect to database: Error: Lost connection to MySQL server during query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • just2blue4u
    Senior Member
    • Apr 2006
    • 347

    #1

    Failed to connect to database: Error: Lost connection to MySQL server during query

    Hi!

    For the 2nd time, Zabbix server (beta9) simply stops working.
    Here is the last part of the server.log:
    012374:20060530:224619 Failed to connect to database: Error: Lost connection to
    MySQL server during query
    012368:20060530:224619 One server process died. Shutting down...
    012368:20060530:224619 ZABBIX server is down.
    I was able to restart zabbix server again without problems.
    The MySQL database (MyISAM) is @ localhost and works fine (no entry in mysqld.log).
    As a workaround, i think i'll create a cronjop to restart zabbix.

    Please, can anybody tell me why the server stops and what i can do against it?
    Big ZABBIX is watching you!
    (... and my 48 hosts, 4513 items, 1280 triggers via zabbix v1.6 on CentOS 5.0)
  • krusty
    Senior Member
    • Oct 2005
    • 222

    #2
    I have located the same problem a few times ago.

    I made one crontjob which will restarted the zabbix_server process

    Comment

    • just2blue4u
      Senior Member
      • Apr 2006
      • 347

      #3
      This is my cron entry (still testing):

      */5 * * * * test "$(pidof zabbix_server)" || (echo 'ZABBIX Server ist nicht aktiv, versuche neu zu starten...'; /etc/init.d/zabbix_server start && echo 'ZABBIX Server wurde neu gestartet!' || echo 'FEHLER: NEUSTART FEHLGESCHLAGEN!!!')




      Nevertheless, i'm still searching a clean way to PREVENT the stopping of the server...
      Big ZABBIX is watching you!
      (... and my 48 hosts, 4513 items, 1280 triggers via zabbix v1.6 on CentOS 5.0)

      Comment

      Working...