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

The 'version' value was not being refreshed in various MySQL dashboards.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: 2.6.0
    • Component/s: Grafana Dashboards
    • Labels:
    • Story Points:
      1
    • Sprint:
      Platform Sprint 14
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      STR:

      • Install PMM2 server dev-latest with added Percona Server
      • Open MySQL Instance Summary dashboard
      • Upgrade MySQL Server (e.g. 8.0.18-9 -> 8.0.19)
      • Take a look at opened MySQL Instance Summary dashboard

      Given result:
      Singlestat still shown the previous MySQL version.

      Expected result:
      Correct version is shown if time range is changed.

      Solution:
      The mentioned singlestat is formed by the variable $version.
      It's used function label_values in formula. This function returns a list of label names for selected time range.
      So we got all mysql versions that were detected for this service during a selected time range.

      We can try to replace function label_values by another function query_result(query).
      It returns a list of Prometheus query result for the query. So we would get the last value only.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            vadim.yalovets Vadim Yalovets
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1 day, 3 hours, 40 minutes
                1d 3h 40m

                  Smart Checklist