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

mysql:metrics service is not started on Ubuntu LTS 16.04

    XMLWordPrintable

    Details

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

      Description

      1. Install last PMM server :
        docker run -d -p 8443:443 --restart always  -e SERVER_USER=qweqwe -e SERVER_PASSWORD=qwe123 -e QUERIES_RETENTION=4 --volumes-from pmm-data --name pmm-server perconalab/pmm-server:201803231647
      2. Install last pmm-client
      3. Add Mysql to monitoring
        nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo pmm-admin add mysql --query-source=perfschema --disable-queryexamples
        [linux:metrics] OK, now monitoring this system.
        [mysql:metrics] OK, now monitoring MySQL metrics using DSN root:***@unix(/var/run/mysqld/mysqld.sock)
        [mysql:queries] OK, now monitoring MySQL queries from perfschema using DSN root:***@unix(/var/run/mysqld/mysqld.sock)
        nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo pmm-admin list
        pmm-admin EXPERIMENTAL
        
        PMM Server      | 10.10.11.52:8443 (insecure SSL, password-protected)
        Client Name     | bm-dell06-qanqa03
        Client Address  | 10.10.11.52 
        Service Manager | linux-systemd
        
        -------------- ------------------ ----------- -------- ------------------------------------------- ----------------------------------------------
        SERVICE TYPE   NAME               LOCAL PORT  RUNNING  DATA SOURCE                                 OPTIONS                                       
        -------------- ------------------ ----------- -------- ------------------------------------------- ----------------------------------------------
        mysql:queries  bm-dell06-qanqa03  -           YES      root:***@unix(/var/run/mysqld/mysqld.sock)  query_source=perfschema, query_examples=false 
        linux:metrics  bm-dell06-qanqa03  42000       YES      -                                                                                         
        mysql:metrics  bm-dell06-qanqa03  42002       NO       root:***@unix(/var/run/mysqld/mysqld.sock)  tablestats=OFF 
        

      Result: mysql:metrics is not running

      time="2018-03-26T07:32:35Z" level=info msg="Starting mysqld_exporter (version=, branch=, revision=)" source="mysqld_exporter.go:288"
      time="2018-03-26T07:32:35Z" level=info msg="Build context (go=go1.9.4, user=, date=)" source="mysqld_exporter.go:289"
      time="2018-03-26T07:32:35Z" level=fatal msg="failed reading ini file: open .my.cnf: no such file or directory" source="mysqld_exporter.go:296"
      
      
      nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo ls -la /etc/my.cnf 
      -rw-r--r-- 1 root root 4448 Mar 23 20:10 /etc/my.cnf
      nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo ls -la /etc/mysql/ 
      total 44
      drwxr-xr-x   4 root root  4096 Mar 23 20:09 .
      drwxr-xr-x 123 root root 12288 Mar 23 20:10 ..
      drwxr-xr-x   2 root root  4096 Dec  1 17:53 conf.d
      lrwxrwxrwx   1 root root    24 Dec  1 17:53 my.cnf -> /etc/alternatives/my.cnf
      -rw-r--r--   1 root root   839 Jan 21  2017 my.cnf.fallback
      -rw-r--r--   1 root root  4448 Mar 22 10:45 my.cnf.migrated
      -rw-r--r--   1 root root  3508 Apr  6  2016 my.cnf.old
      -rw-r--r--   1 root root   364 May 25  2017 percona-server.cnf
      drwxr-xr-x   2 root root  4096 Dec  1 17:53 percona-server.conf.d
      nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo ls -la /etc/alternatives/my.cnf
      lrwxrwxrwx 1 root root 26 Dec  1 17:53 /etc/alternatives/my.cnf -> /etc/mysql/my.cnf.migrated
      

      Server: VERSION="16.04.3 LTS (Xenial Xerus)
      Percona Server 5.7.19

      I tried to reproduce the problem on Ubuntu 14.04 and CentOS 6.8 but everything works ok on other servers.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nailya.kutlubaeva Nailya Kutlubaeva
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 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 - 1 day, 1 hour, 40 minutes
                    1d 1h 40m