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

Home Dashboard: Incorrect metric for 'DB uptime'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: 2.10.0
    • Component/s: Grafana Dashboards
    • Labels:
    • Environment:

      pmm-server as cocker container

      pmm-agent using postresql-exporter

    • Story Points:
      2
    • Sprint:
      Platform Sprint 22
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      Hello

      Home Dashborad -> click on db_uptime  "view" on one node -> explore shows

      min by (node_name) (mysql_global_status_uptime{node_name=~"..."} or
      mongodb_instance_uptime_seconds {node_name=~"..."} or
      (time() - process_start_time_seconds{node_name="...",job="postgres_exporter.*"}))

      On Postgres Servers the time the postgres_exporter is running is shown.
      As I see this to be only minutes on all postgres Servers, and all the same amount of minutes
      I think the restart of the pmm-server triggered a restart of the postgres-exporter. 
      (Time of docker container matches those of postgres-exporters)

      While restarting the exporters seems fine, show the time since start time of postgres-exporter as "db-uptime" is misleading. 

      Regards

        Attachments

        1. after_pmm-server_restart.png
          69 kB
          Lalit Choudhary
        2. homedashboard.png
          16 kB
          Hubertus Krogmann
        3. image-2020-08-11-17-37-14-849.png
          43 kB
          Beata Handzelova
        4. pmm-agent_restart.png
          69 kB
          Lalit Choudhary

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            hubi_oediv Hubertus Krogmann
            Votes:
            0 Vote for this issue
            Watchers:
            5 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 - 2 days, 1 hour, 45 minutes
                2d 1h 45m

                  Smart Checklist