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

Error adding MySQL queries when options for mysqld_exporters are used

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.15.0
    • Fix Version/s: 1.16.0
    • Component/s: PMM Client
    • Labels:
      None

      Description

      When I tried to provide options for mysql_exporter and specified them with `pmm-admin add mysql:queries instead of mysql:metrics I got the next error:

      
      nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo pmm-admin add mysql:queries --socket=/tmp/PS_NODE_1.sock -- --collect.perf_schema.eventsstatements
      Error adding MySQL queries: timeout 10s waiting on agent to connect to API
      nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo pmm-admin list
      We have found system services disconnected from PMM server.
      Usually, this happens when data container is wiped before all monitoring services are removed or client is uninstalled.
      
      Orphaned local services: pmm-mysql-queries-0
      
      To continue, run 'pmm-admin repair' to remove orphaned services.
      

      I checked the same on latest 1.15.0 PMM and there is no any error.
      So my question, is it allowed to specify options for mysqld_exporter with mysql:queries?

        Attachments

          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:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4 hours Original Estimate - 4 hours
                  4h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 4 hours, 50 minutes
                  1d 4h 50m