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

Table count is unknown error while adding MySQL instance

    XMLWordPrintable

    Details

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

      Description

      Pre-conditions: MySQL server has more than 1000 tables

       mysql> SELECT count(*) AS TOTALNUMBEROFTABLES FROM INFORMATION_SCHEMA.TABLES;
      +---------------------+
      | TOTALNUMBEROFTABLES |
      +---------------------+
      |                1005 |
      +---------------------+
      1 row in set (0.21 sec)

      STR:

      1. Install PMM2 server (201911210730) and latest pmm2-client
      2. Add MySQL to monitoring:
         nailya.kutlubaeva@bm-dell02-qanqa01:~$ pmm-admin add mysql --password=MyNewPass --debug

        Given result:

         DEBUG 2019-11-21 10:46:28.703031176Z: POST /local/Status HTTP/1.1
        Host: 127.0.0.1:7777
        User-Agent: Go-http-client/1.1
        Content-Length: 3
        Accept: application/json
        Content-Type: application/json
        Accept-Encoding: gzip
        
        {}
        
        DEBUG 2019-11-21 10:46:28.703877526Z: HTTP/1.1 200 OK
        Content-Length: 435
        Content-Type: application/json
        Date: Thu, 21 Nov 2019 10:46:28 GMT
        Grpc-Metadata-Content-Type: application/grpc
        
        {"agent_id":"/agent_id/4c1bcc39-caf2-4e38-be80-d9935c6cdd41","runs_on_node_id":"/node_id/30dcfab2-b97e-4709-8447-bca6f9909f7c","server_info":{"url":"https://admin:admin@10.10.11.50:443/","insecure_tls":true,"connected":true,"version":"2.2.0"},"agents_info":[{"agent_id":"/agent_id/9f953fbf-0f12-4842-a208-e80f405448ac","agent_type":"NODE_EXPORTER","status":"RUNNING"}],"config_filepath":"/usr/local/percona/pmm2/config/pmm-agent.yaml"}
        DEBUG 2019-11-21 10:46:28.704148004Z: POST /local/Status HTTP/1.1
        Host: 127.0.0.1:7777
        User-Agent: Go-http-client/1.1
        Content-Length: 3
        Accept: application/json
        Content-Type: application/json
        Accept-Encoding: gzip
        
        {}
        
        DEBUG 2019-11-21 10:46:28.704594387Z: HTTP/1.1 200 OK
        Content-Length: 435
        Content-Type: application/json
        Date: Thu, 21 Nov 2019 10:46:28 GMT
        Grpc-Metadata-Content-Type: application/grpc
        
        {"agent_id":"/agent_id/4c1bcc39-caf2-4e38-be80-d9935c6cdd41","runs_on_node_id":"/node_id/30dcfab2-b97e-4709-8447-bca6f9909f7c","server_info":{"url":"https://admin:admin@10.10.11.50:443/","insecure_tls":true,"connected":true,"version":"2.2.0"},"agents_info":[{"agent_id":"/agent_id/9f953fbf-0f12-4842-a208-e80f405448ac","agent_type":"NODE_EXPORTER","status":"RUNNING"}],"config_filepath":"/usr/local/percona/pmm2/config/pmm-agent.yaml"}
        DEBUG 2019-11-21 10:46:28.705245933Z: POST /v1/management/MySQL/Add HTTP/1.1
        Host: 10.10.11.50:443
        User-Agent: Go-http-client/1.1
        Content-Length: 293
        Accept: application/json
        Authorization: Basic YWRtaW46YWRtaW4=
        Content-Type: application/json
        Accept-Encoding: gzip
        
        {"node_id":"/node_id/30dcfab2-b97e-4709-8447-bca6f9909f7c","service_name":"bm-dell02-qanqa01-mysql","address":"127.0.0.1","port":3306,"pmm_agent_id":"/agent_id/4c1bcc39-caf2-4e38-be80-d9935c6cdd41","username":"root","password":"MyNewPass","qan_mysql_slowlog":true,"max_slowlog_file_size":"0"}
        
        DEBUG 2019-11-21 10:46:28.872173171Z: HTTP/1.1 200 OK
        Content-Length: 770
        Cache-Control: no-store
        Connection: keep-alive
        Content-Type: application/json
        Date: Thu, 21 Nov 2019 10:46:28 GMT
        Grpc-Metadata-Content-Type: application/grpc
        Pragma: no-cache
        Server: nginx
        Strict-Transport-Security: max-age=31536000; includeSubdomains;
        X-Content-Type-Options: nosniff
        X-Frame-Options: DENY
        X-Xss-Protection: 1; mode=block
        
        {"service":{"service_id":"/service_id/249bec0a-7229-458e-b481-4e2d272f996f","service_name":"bm-dell02-qanqa01-mysql","node_id":"/node_id/30dcfab2-b97e-4709-8447-bca6f9909f7c","address":"127.0.0.1","port":3306},"mysqld_exporter":{"agent_id":"/agent_id/e2a961cd-635f-4f37-90a3-79b1fa4d788c","pmm_agent_id":"/agent_id/4c1bcc39-caf2-4e38-be80-d9935c6cdd41","service_id":"/service_id/249bec0a-7229-458e-b481-4e2d272f996f","username":"root","tablestats_group_table_limit":1000,"tablestats_group_disabled":true},"qan_mysql_slowlog":{"agent_id":"/agent_id/fd901fa8-5938-43ca-8d14-62c80e44cd97","pmm_agent_id":"/agent_id/4c1bcc39-caf2-4e38-be80-d9935c6cdd41","service_id":"/service_id/249bec0a-7229-458e-b481-4e2d272f996f","username":"root","max_slowlog_file_size":"1073741824"}}
        DEBUG 2019-11-21 10:46:28.873981569Z: Result: &management.addMySQLResult{Service:(*my_sql.AddMySQLOKBodyService)(0xc000374780), MysqldExporter:(*my_sql.AddMySQLOKBodyMysqldExporter)(0xc0000d30a0), TableCount:0}
        DEBUG 2019-11-21 10:46:28.873996021Z: Error: <nil>                                
        MySQL Service added.
        Service ID  : /service_id/249bec0a-7229-458e-b481-4e2d272f996f
        Service name: bm-dell02-qanqa01-mysql
        
        Table statistics collection disabled (the limit is 1000, the actual table count is unknown).
        
        

      Expected result: the actual table count is 1005 message is returned

      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 143077
      Server version: 5.7.25-0ubuntu0.16.04.2-log (Ubuntu)
      

        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 - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 2 hours, 16 minutes
                    2h 16m