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

import-dashboard.py don't update PMM Query Analytics dashboard

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.8.0
    • Fix Version/s: 1.8.0
    • Component/s: None
    • Labels:
      None

      Description

      1. Install PMM 1.7, enable MySQL monitoring
      2. Upgrade to 1.8 via web
      3. Open PMM Query Analytics
        Result: Dashboard doesn't have menu, only Settings

       

      import-dashboards.py logs

      grafana: stopped
      grafana: started
      Grafana database directory: /var/lib/grafana
      * Dashboards upgrade from version 1.6.0 to 1.8.0.
      * Grafana stop: 0.
      * Copying 'pmm-app'
      * Grafana start: 0.
      * Waiting for Grafana to startgrafana: stopped
      grafana: started
      
      * Datasources: 200 '[{"id":2,"orgId":1,"name":"CloudWatch","type":"cloudwatch","typeLogoUrl":"public/app/plugins/datasource/cloudwatch/img/amazon-web-services.png","access":"proxy","url":"","password":"","user":"","database":"","basicAuth":false,"isDefault":false,"jsonData":{"authType":"keys"}},{"id":1,"orgId":1,"name":"Prometheus","type":"prometheus","typeLogoUrl":"public/app/plugins/datasource/prometheus/img/prometheus_logo.svg","access":"proxy","url":"http://127.0.0.1:9090/prometheus/","password":"","user":"","database":"","basicAuth":false,"isDefault":true,"jsonData":{}}]'
      * QAN-API Data Source
      200 {"id":3,"message":"Datasource added","name":"QAN-API"}
      * Importing 'pmm-app'
      * Plugin enable result: 200 '{"message":"Plugin settings updated"}'
      * Grafana stop: 0.
      * Grafana start: 0.
      * Waiting for Grafana to start
      * "home" dashboard: 200 '{"meta":{"type":"db","canSave":true,"canEdit":true,"canStar":true,"slug":"home-dashboard","expires":"0001-01-01T00:00:00Z","created":"2018-02-26T21:10:50Z","updated":"2018-02-26T21:10:50Z","updatedBy":"Anonymous","createdBy":"Anonymous","version":1},"dashboard":{"annotations":{"list":[]},"editable":true,"gnetId":null,"graphTooltip":1,"hideControls":true,"id":39,"links":[{"icon":"dashboard","includeVars":false,"keepTime":true,"tags":["QAN"],"targetBlank":false,"title":"Query Analytics","type":"link","url":"/graph/dashboard/db/_pmm-query-analytics"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["OS"],"targetBlank":false,"title":"OS","type":"dashboards"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["MySQL"],"targetBlank":true,"title":"MySQL","type":"dashboards"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["MongoDB"],"targetBlank":true,"title":"MongoDB","type":"dashboards"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["HA"],"targetBlank":true,"title":"HA","type":"dashboards"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["Cloud"],"targetBlank":true,"title":"Cloud","type":"dashboards"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["Insight"],"targetBlank":true,"title":"Insight","type":"dashboards"},{"asDropdown":true,"includeVars":true,"keepTime":true,"tags":["PMM"],"targetBlank":true,"title":"PMM","type":"dashboards"}],"rows":[{"collapse":false,"height":"10px","panels":[{"content":"\u003cdiv class=\"text-center dashboard-header\"\u003e\n\u003cimg src=\"https://pmmdemo.percona.com/img/pmm-logo.svg\" height=\"60px\" width=\"60px\"\u003e\n \u003cspan\u003ePercona Monitoring and Management\u003c/span\u003e\n\u003c/div\u003e","datasource":"Prometheus","editable":true,"height":"10px","id":1339,"links":[],"mode":"html","span":12,"style":{},"title":"","transparent":true,"type":"text"}],"repeat":null,"repeatIteration":null,"repeatRowId":null,"showTitle":false,"title":"Dashboard Row","titleSize":"h6"},{"collapse":false,"height":"10px","panels":[{"content":"**Overview** \n[Percona Monitoring and Management (PMM)](https://www.percona.com/pmm) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance, and provides time-based analysis to ensure that your data works as efficiently as possible. \n\n**Documentation** \nPlease consult the official [PMM documentation](https://www.percona.com/doc/percona-monitoring-and-management/index.html) to learn more about PMM. Also of interest are the [Release notes](https://www.percona.com/doc/percona-monitoring-and-management/release-notes/index.html) and [FAQ](https://www.percona.com/doc/percona-monitoring-and-management/faq.html) for common questions about PMM.\n\n**Community and Blogs** \nOn the [PMM Community Forums](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management) you will find help from Perconians and the Community at large. Further, we publish PMM announcements and use cases regularly on the [Percona Database Performance Blog](https://www.percona.com/blog/category/percona-monitoring-and-management/) \n\n**Get Help from Percona** \nAre you looking for assistance that comes with a response-time guarantee? Let our [Support team](https://www.percona.com/services/support?utm_source=pmm\u0026utm_medium=web\u0026utm_campaign=support_link) help you!\nAlready a customer? Log in to your [Percona Support Portal](https://customers.percona.com) \n\n\n\n","height":"330px","id":1021,"links":[],"mode":"markdown","span":6,"title":"","transparent":false,"type":"text"},{"headings":false,"height":"330px","id":1020,"limit":3,"links":[],"query":"","recent":true,"search":false,"span":3,"starred":true,"tags":[],"title":"Starred and Recently used Dashboards","type":"dashlist"},{"cacheTimeout":null,"colorBackground":false,"colorValue":false,"colors":["rgba(245, 54, 54, 0.9)","rgba(237, 129, 40, 0.89)","rgba(50, 172, 45, 0.97)"],"datasource":"Prometheus","decimals":0,"editable":true,"error":false,"format":"short","gaug/tmp/1: line 1: printf: `"': invalid format character
      e":{"maxValue":100,"minValue":0,"show":false,"thresholdLabels":false,"thresholdMarkers":true},"height":"50","id":1335,"interval":"","links":[],"mappingType":1,"mappingTypes":[{"name":"value to text","value":1},{"name":"range to text","value":2}],"maxDataPoints":100,"nullPointMode":"connected","nullText":null,"postfix":"","postfixFontSize":"100

        Smart Checklist

          Attachments

          1. Screenshot17-06-08.png
            100 kB
            Mykola Marzhan
          2. Screen Shot 2018-02-19 at 15.23.53.png
            26 kB
            Nailya Kutlubaeva
          3. Screen Shot 2018-02-19 at 15.33.57.png
            115 kB
            Nailya Kutlubaeva

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                nailya.kutlubaeva Nailya Kutlubaeva
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: