Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-11588

Database instance count on OS overview is incorrect

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.33.0, 2.34.0
    • 2.36.0
    • Grafana
    • 0.5
    • Yes
    • Yes
    • No
    • Observability
    • Hide

      Check database count panel at OS overview dashboard. For one instance it should be one.

      Show
      Check database count panel at OS overview dashboard. For one instance it should be one.

    Description

      Impact on the user 
      Minimal, but confusing

      Steps to reproduce

      • Create a new PMM server
      • View OS dashboard
      • Compare node count to database instance count (top of the dashboard)

      Actual result

      • Database instance count = 4
      • Node count = 1

      Expected Result

      • Database instance count = node count

      Workaround
      Edit the dashboard

      Details
      The database instance count panel on the OS overview dashboard is counting duplicates of the same instance, such that PMM's own PostgreSQL instance appears as 4 items, when there is only 1

      Current expression
      count(
      mysql_global_status_uptime{node_name=~"...",region=~".*",node_type=~"generic"} or 
      mongodb_mongos_instance_uptime_seconds{region=~".*",node_type=~"generic",node_name=~"..."} or 
      pg_up{node_name=~"...",region=~".*",node_type=~"generic"} or 
      postgresql_up{node_name=~"...",region=~".*",node_type=~"generic"}
      )
      

      Removing the `count` shows the issue quite clearly:

      Attachments

        Activity

          People

            anton.bystrov Anton Bystrov
            ceri.williams Ceri Williams
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist