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

    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?

        Smart Checklist

          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