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

MSSQL ODBC Template Non-local database discovery

    XMLWordPrintable

Details

    • Team INT
    • Sprint 74 (Mar 2021)
    • 1

    Description

      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

       

       

      Attachments

        Activity

          People

            mchudinov Maxim Chudinov
            maand75 Mathias Andersson
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: