Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-11004

Zabbix exiting when unable to connect to MySQL

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 3.0.3
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Ubuntu 14.04, MariaDB 10.1, Zabbix 3.0.3 from repo.zabbix.com

      Description

      After visiting our Zabbix dashboard it mentioned that "the information may not be accurate because Zabbix-server is not running".

      During an upgrade of MariaDB the mysql-server process was shut down and as a result all Zabbix-server intances died in the process.

      The downtime was less than a minute, it seems like zabbix-server simply exited without retrying.

        7925:20160719:075154.104 [Z3005] query failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") [begin;]
        7925:20160719:075154.113 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
        7925:20160719:075154.128 Cannot connect to the database. Exiting...
        7907:20160719:075154.707 [Z3005] query failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") [select hostid,status,tls_accept,tls_issuer,tls_subject,tls_psk_identity from hosts where host='server.example.com' and status in (0,1) and flags<>2 and proxy_hostid is null]
        7907:20160719:075154.707 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
        7852:20160719:075154.716 One child process died (PID:7925,exitcode/signal:1). Exiting ...
        7907:20160719:075154.727 Cannot connect to the database. Exiting...
        7852:20160719:075156.751 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
        7852:20160719:075156.751 Cannot connect to the database. Exiting...
      

      This should not be desirable behavior as Zabbix-server should retry connecting to the MySQL-server whenever it is unable to do so as it is likely a temporary issue.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              frank Frank
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: