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

MSSQL ODBC Template Non-local database discovery

XMLWordPrintable

    • Sprint 74 (Mar 2021)
    • 1

      Steps to reproduce:

      1. Use the Zabbix offical MSSQL ODBC monitoring on a SQL Always on cluster with more than two nodes
      2. 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 states

       

      MSSQL AG '{#GROUP_NAME}' Non-Local DB '*{#REPLICA_NAME}

      *

      {#DBNAME}': Log queue size

       

      MSSQL AG '{#GROUP_NAME}' Non-Local DB '{#REPLICA_NAME}
      {#DBNAME}

      ': Redo log queue size

       

       

            mchudinov Maxim Chudinov (Inactive)
            maand75 Mathias Andersson
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: