Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.11.0
    • Fix Version/s: 1.13.0
    • Component/s: MySQLd_Exporter
    • Labels:

      Description

      1) Install PMM 1.11
      2) Install MySQL 8 with slowlog,
      3) Configure MYSQL 8 to work with PMM (enabled mysql_native_password plugin, create 'pmm' user)
      4) Add Mysql to PMM:

      sudo pmm-admin add mysql --defaults-file=/etc/my.cnf Mysql8 --user=pmm --password='T4k3My$andC0meb4ck'
      

      5) Check pmm-mysql-metrics log file
      Result:

      2018/05/21 20:04:06 http: panic serving 10.10.11.50:59840: descriptor Desc{fqName: "mysql_global_variables_validate_password.check_user_name", help: "Generic gauge metric from SHOW GLOBAL VARIABLES.", constLabels: {}, variableLabels: []} is invalid: "mysql_global_variables_validate_password.check_user_name" is not a valid metric name
      goroutine 295 [running]:
      net/http.(*conn).serve.func1(0xc42007c140)
      	/usr/lib/golang/src/net/http/server.go:1697 +0xd0
      panic(0x82f6c0, 0xc4205db530)
      	/usr/lib/golang/src/runtime/panic.go:491 +0x283
      github.com/percona/mysqld_exporter/vendor/github.com/prometheus/client_golang/prometheus.(*Registry).MustRegister(0xc420135880, 0xc42004db58, 0x1, 0x1)
      	/tmp/go/src/github.com/percona/mysqld_exporter/vendor/github.com/prometheus/client_golang/prometheus/registry.go:404 +0x9e
      main.newHandler.func1(0xae6de0, 0xc420508000, 0xc420506000)
      	/tmp/go/src/github.com/percona/mysqld_exporter/mysqld_exporter.go:237 +0x683
      net/http.HandlerFunc.ServeHTTP(0xc4201355c0, 0xae6de0, 0xc420508000, 0xc420506000)
      	/usr/lib/golang/src/net/http/server.go:1918 +0x44
      net/http.(*ServeMux).ServeHTTP(0xc420188c60, 0xae6de0, 0xc420508000, 0xc420506000)
      	/usr/lib/golang/src/net/http/server.go:2254 +0x130
      net/http.serverHandler.ServeHTTP(0xc420116c30, 0xae6de0, 0xc420508000, 0xc420506000)
      	/usr/lib/golang/src/net/http/server.go:2619 +0xb4
      net/http.(*conn).serve(0xc42007c140, 0xae76e0, 0xc4201340c0)
      	/usr/lib/golang/src/net/http/server.go:1801 +0x71d
      created by net/http.(*Server).Serve
      	/usr/lib/golang/src/net/http/server.go:2720 +0x288
      

      I tried to add mysql without passing defaults-file but with the same result
      I couldn't reproduce the problem on Ubuntu, only on Centos

        Attachments

          Issue Links

            Expenses

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 3 hours, 30 minutes
                    3h 30m