Not the answer you need?
Register and ask your own question!

mysql:queries API Error

Our PMM server is being a proxy for security. We can connect to it from our clients and add linux:metrics and mysql:metrics. However, when we try to add mysql:queries, we get an error. "Error adding MySQL queries: timeout 10s waiting on agent to connect to API." It was working till we put it behind the proxy.

Not sure how we can debug this. Thanks!

Comments

  • nlangenlange Entrant Legacy User Role Beginner
    I have same error dans after repair I get a 409 error :
    root@XXXX#  pmm-admin check-network
    PMM Network Status
    
    Server Address | pmm.eurecia.com:443
    Client Address | X.X.X.141
    
    * System Time
    NTP Server (0.pool.ntp.org)         | 2017-11-29 14:24:25 +0100 CET
    PMM Server                          | 2017-11-29 13:25:01 +0000 GMT
    PMM Client                          | 2017-11-29 14:24:25 +0100 CET
    PMM Server Time Drift               | OK
    PMM Client Time Drift               | OK
    PMM Client to PMM Server Time Drift | OK
    
    * Connection: Client --> Server
    -------------------- -------
    SERVER SERVICE       STATUS
    -------------------- -------
    Consul API           OK
    Prometheus API       OK
    Query Analytics API  OK
    
    Connection duration | 1.78193ms
    Request duration    | 10.853308ms
    Full round trip     | 12.635238ms
    
    
    * Connection: Client <-- Server
    -------------- ------------- -------------------- ------- ---------- ---------
    SERVICE TYPE   NAME          REMOTE ENDPOINT      STATUS  HTTPS/TLS  PASSWORD
    -------------- ------------- -------------------- ------- ---------- ---------
    linux:metrics  XXXX  X.X.X.141:42000  OK      YES        -
    mysql:metrics  XXXX  X.X.X.141:42002  OK      YES        -
    
    root&#64;XXXX:~# pmm-admin add mysql:queries --user xxx
    Error adding MySQL queries: timeout 10s waiting on agent to connect to API.
    
    root&#64;XXXX:~# pmm-admin repair
    OK, removed 1 orphaned services.
    
    root&#64;XXXX:~# pmm-admin add mysql:queries --user xxx
    Error adding MySQL queries: PUT https://pmmserver.xxxx.xxx:443/qan-api/instances/ec6ff5a748564fa36b5f8ebf963b589d: API returned HTTP status code 409, expected 204
    
  • nlangenlange Entrant Legacy User Role Beginner
    So I find a solution you need to configure your proxy to handle websocket : nginx exemple https://www.nginx.com/blog/websocket-nginx/
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.