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:
      Team INT
    • Sprint:
      Sprint 74 (Mar 2021)
    • Story Points:
      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

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

              Dates

              Created:
              Updated:
              Resolved: