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

Unhandled ODBC monitoring error should not bring down zabbix server

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Won't fix
    • Affects Version/s: 2.1.8
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Zabbix 2.1.8 (second beta)
      OEL 6.4
      unixODBC-2.2.14
      mysql-connector-odbc -5.1.5r1144

      Description

      When database monitoring feature encounters ODBC exception it can't handle, then instead of just marking this item as Not supported, the entire zabbix server shuts down. Would be nice, if that error would not have so dramatic consequences and Zabbix server could stay alive after that.
      For example:

      Handled error
      24561:20131023:141301.255 In odbc_DBconnect() db_dsn:'nosuchdb.mydomain.com' user:'myuser'
      24561:20131023:141301.256 odbc_Diag(): rc_msg:'SQL_ERROR' rec_nr:1 sql_state:'IM002' native_err_code:0 err_msg:'[unixODBC][Driver Manager]Data source name not found, and no default driver specified'
      24561:20131023:141301.256 End of odbc_DBconnect():FAIL
      24561:20131023:141301.256 End of get_value_db():NOTSUPPORTED

      Un-handled error
      20951:20131023:125501.034 In odbc_DBconnect() db_dsn:'myserver.mydomain.com' user:'myuser'
      /opt/zabbix/sbin/zabbix_server: poller #1 [got 1 values in 0.077962 sec, getting values]: relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference
      20945:20131023:125501.044 One child process died (PID:20951,exitcode/signal:127). Exiting ...
      20945:20131023:125501.044 zbx_on_exit() called

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              arli Arli
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: