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

Unhelpful Message in MySQLD Exporter Error Log in PMM, Stall

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: MySQLd_Exporter, PMM Client
    • Labels:

      Description

      Hi

      I Upgraded from Ubuntu 16.04 to 18.04 on one box and I noticed MySQLD
      exporter stopper working

      I checked in the error log, I can see:

      time="2018-08-19T18:55:57-04:00" level=info msg="Starting mysqld_exporter
      (version=, branch=, revision=)" source="mysqld_exporter.go:296"
      time="2018-08-19T18:55:57-04:00" level=info msg="Build context
      (go=go1.10.1, user=, date=)" source="mysqld_exporter.go:297"
      time="2018-08-19T18:55:57-04:00" level=fatal msg="failed reading ini file:
      open .my.cnf: no such file or directory" source="mysqld_exporter.go:304"
      time="2018-08-19T18:57:57-04:00" level=info msg="Starting mysqld_exporter
      (version=, branch=, revision=)" source="mysqld_exporter.go:296"
      time="2018-08-19T18:57:57-04:00" level=info msg="Build context
      (go=go1.10.1, user=, date=)" source="mysqld_exporter.go:297"
      time="2018-08-19T18:57:57-04:00" level=fatal msg="failed reading ini file:
      open .my.cnf: no such file or directory" source="mysqld_exporter.go:304"

      This error is very unhelpful for me as a user. What is .my.cnf and why is
      one needed ? I just specify options through "pmm-admin"

      As I try to remove and re-add the metrics service:

      root@ts140i:~# pmm-admin remove mysql:metrics
      OK, removed MySQL metrics ts140i from monitoring.
      root@ts140i:~# pmm-admin add mysql:metrics
      <At this point it stalls for at least 2 minutes.>
      OK, now monitoring MySQL metrics using DSN
      root:***@unix(/var/run/mysqld/mysqld.sock)

      What would take so long if it finally succeeds ?

      After re-adding it seems to be working properly.

      This node runs MySQL 8.0.12 (if this is important)


      Peter Zaitsev, CEO, Percona

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: