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

Not all ODBC errors are processed by the pollers

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 7.0.19, 7.2.13, 7.4.3
    • Proxy (P), Server (S)
    • None
    • IBM DB2 ODBC driver version 11.5, also v12.1.2 with the same results (even 6.0.40 had the same issue).
    • Support backlog

      Steps to reproduce:

      1. Use template from the link shared internally.
      2. Get errors like: 
        Sep 16 11:10:25 zabbix zabbix_proxy: odbc poller #19 [got 0 values in 0.000748 sec, getting values][462]: zbx_odbc_diag(): [SQL_ERROR]:[HY000][-1092][[IBM][CLI Driver][DB2/NT64] SQL1092N  The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation.  User ID: "ZBX_MONITOR".
]
Sep 16 11:10:25 zabbix zabbix_proxy: odbc poller #19 [got 0 values in 0.000748 sec, getting values][462]: Cannot fetch row: [SQL_ERROR]:[HY000][-1092][[IBM][CLI Driver][DB2/NT64] SQL1092N  The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation.  User ID: "ZBX_MONITOR".
      3. see screenshots attached internally and logs, empty result and no errors on the item side

      Expected:
      Correct error handling, with current behaviour trigger are not working correctly, so issues can be missed.

            zabbix.dev Zabbix Development Team
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: