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

Template DB MSSQL by ODBC: dependent items fail for databases in OFFLINE status

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • 5.0.2
    • None
    • Templates (T)
    • None
    • Debian GNU/Linux 10 (buster) amd64
      zabbix_server (Zabbix) 5.0.2
      ODBC Driver 17 for SQL Server
      Microsoft SQL Server 2008 R2
      Microsoft SQL Server 2012

    Description

      Steps to reproduce:

      1. Collect data from Discovered Databases from MSSQL Server with some databases in OFFLINE state
      2. Got a trigger indicating OFFLINEDBNAME state is OFFLINE
      3. Wait for results

      Result:

      Each Dependent item from Discovery Prototypes failed for databases in OFFLINE state with error:

      Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129986"},{"...
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Active Transactions' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path

      Excessive errors in zabbix_server log file like this:

       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Shrinks' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_shrinks["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Shrinks' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_shrinks["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Shrinks' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_shrinks["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Shrinks' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_shrinks["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Shrinks' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_growths["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Growths' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_growths["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Growths' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_growths["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Growths' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_growths["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...
       1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Log Growths' && @.instance_name=='_OFFLINEDBNAME_')].cntr_value.first()": no data matches the specified path
         5523:20200815:174719.174 error reason for "_SERVERNAME_:mssql.db.log_growths["_OFFLINEDBNAME_"]" changed: Preprocessing failed for: [{"object_name":"SQLServer","counter_name":"Uptime","instance_name":"","cntr_value":"4129146"},{"...

      We have plenty databases on several MSSQL servers in OFFLINE state, and this issue fills in the log and creates unnecessary load for zabbix server.

      Expected:
      Data should not be collected or processed for databases in OFFLINE or similiar states.

      Attachments

        Activity

          People

            igorbach Igor Gorbach
            ryu.khmelnov Roman Khmelnov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: