-
Problem report
-
Resolution: Fixed
-
Trivial
-
5.0.5, 5.2.0
-
Sprint 74 (Mar 2021)
-
1
Steps to reproduce:
- Use the Zabbix offical MSSQL ODBC monitoring on a SQL Always on cluster with more than two nodes
- Discover non-local databases (always on replicated) existing on more than two nodes
Result:
It cannot create all objects since it only uses the AG Group name and Database and not the unique replica_name
The Primary node for my case is OMSQL01N1 so this is the result of the discovery
Expected:
It should create two entries but only one of the rows gets created with the group_name + dbname
Fix:
Updated the item prototypes to include the replica_name as follows so they are created unique:
MSSQL AG '{#GROUP_NAME}' Non-Local DB '*
{#REPLICA_NAME}*{#DBNAME}': Get non-local DB statesMSSQL AG '{#GROUP_NAME}' Non-Local DB '*{#REPLICA_NAME}
*
{#DBNAME}': Log queue sizeMSSQL AG '{#GROUP_NAME}' Non-Local DB '{#REPLICA_NAME}
{#DBNAME}
': Redo log queue size