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

Home Dashboard: Incorrect metric for 'DB uptime'

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.4.0
    • 2.10.0
    • Grafana Dashboards
    • pmm-server as cocker container

      pmm-agent using postresql-exporter

    • 2
    • Yes
    • 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

        Activity

          People

            Unassigned Unassigned
            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