Ad Widget

Collapse

Zabbix lose connection with MySql‎

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • UUVtQD
    Junior Member
    • Mar 2009
    • 11

    #1

    Zabbix lose connection with MySql‎

    Hi!
    I'm running Zabbix Server 1.4.7 in a CentOS 5.6 box, and zabbix lose connection with mysql.
    After this Zabbix server shuting down.

    In the Zabbix's log file i can see this:
    Code:
     5016:20110808:104148 Query::select min(clock) from history where itemid=10115
      4999:20110808:104148 Query::select eventid,value,clock from events where source=0 and object=0 and objectid=13917 order by eventid desc limit 2
      5016:20110808:104148 Query failed:Lost connection to MySQL server during query [2013]
      5000:20110808:104148 Query::select eventid,value,clock from events where source=0 and object=0 and objectid=12790 order by eventid desc limit 2
      5002:20110808:104148 Query::select eventid,value,clock from events where source=0 and object=0 and objectid=13780 order by eventid desc limit 2
      5001:20110808:104148 Query::select num,value_min,value_avg,value_max from trends where itemid=24598 and clock=1312786800
      4998:20110808:104148 Query::select eventid,value,clock from events where source=0 and object=0 and objectid=13921 order by eventid desc limit 2
      5002:20110808:104148 Query failed:Lost connection to MySQL server during query [2013]
      4999:20110808:104148 Query failed:Lost connection to MySQL server during query [2013]
      5000:20110808:104148 Query failed:Lost connection to MySQL server during query [2013]
      5001:20110808:104148 Query failed:Lost connection to MySQL server during query [2013]
      4998:20110808:104148 Query failed:Lost connection to MySQL server during query [2013]
      4993:20110808:104148 One child process died. Exiting ...
      4993:20110808:104150 ZABBIX Server stopped
    Mysql version - mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1

    Anyone have any idea on this one?

    Many thanks
    UUVtQD.
  • UUVtQD
    Junior Member
    • Mar 2009
    • 11

    #2
    OK, that seems that problem in mysql database and
    I'm find a solutions there:

    Now all works fine :-)
    Thanks!

    Comment

    Working...