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

Zabbix server stops when MariaDB is down

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • 3.4 (plan)
    • 3.0.10rc1
    • Proxy (P), Server (S)
    • None
    • Debian GNU/Linux 9 (testing)
      MariaDB 10.1.23
      MariaDB Connector/C 2.3.2
    • Sprint 12
    • 0

      Zabbix server v3.0.10rc1 with MariaDB stops when DB is down:

       10079:20170529:135153.300 [Z3001] connection to database 'zabbix30' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
       10079:20170529:135153.300 cannot set MySQL character set to "utf8"
       10079:20170529:135153.300 Cannot connect to the database. Exiting...
      

      This fix helps:

      Index: src/libs/zbxdb/db.c
      ===================================================================
      --- src/libs/zbxdb/db.c (revision 68585)
      +++ src/libs/zbxdb/db.c (working copy)
      @@ -257,6 +257,7 @@
                      case ER_ACCESS_DENIED_ERROR:            /* wrong user or password */
                      case ER_ILLEGAL_GRANT_FOR_TABLE:        /* user without any privileges */
                      case ER_TABLEACCESS_DENIED_ERROR:       /* user without some privilege */
      +               case CR_CANT_READ_CHARSET:
                      case ER_UNKNOWN_ERROR:
                              return SUCCEED;
              }
      

            Unassigned Unassigned
            andris Andris Mednis
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: