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

Zabbix server stops when MariaDB is down

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.0.10rc1
    • Fix Version/s: 3.4 (plan)
    • Component/s: Proxy (P), Server (S)
    • Labels:
      None
    • Environment:
      Debian GNU/Linux 9 (testing)
      MariaDB 10.1.23
      MariaDB Connector/C 2.3.2
    • Team:
      Team A
    • Sprint:
      Sprint 12
    • Story Points:
      0

      Description

      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;
              }
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            andris Andris Mednis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: