-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
5.0.2
-
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
Steps to reproduce:
- Collect data from Discovered Databases from MSSQL Server with some databases in OFFLINE state
- Got a trigger indicating OFFLINEDBNAME state is OFFLINE
- 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.