mysql:queries] Error adding MySQL queries: problem with agent registration on QAN API: exit status 1

Hi Team,

when i am trying to add the below service in one of the client server i am getting the below error:

[root@mysqltest ~]# pmm-admin add mysql --user=pmm_app --password= --query-source=perfschema --socket=/var/lib/mysql/mysql.sock

Warning: It is recommended to use the same version on both PMM Server and Client, otherwise some features will not work correctly.

Please upgrade your PMM Client by following the instructions from https://www.percona.com/doc/percona-monitoring-and-management/deploy/index.html#updating

[linux:metrics] OK, already monitoring this system.

[mysql:metrics] OK, already monitoring MySQL metrics.

[mysql:queries] Error adding MySQL queries: problem with agent registration on QAN API: exit status 1

after checking the network it says the Query Analytics API DOWN

[root@mysqltest ~]# pmm-admin check-network

Warning: It is recommended to use the same version on both PMM Server and Client, otherwise some features will not work correctly.

Please upgrade your PMM Client by following the instructions from https://www.percona.com/doc/percona-monitoring-and-management/deploy/index.html#updating

PMM Network Status

  • System Time

NTP Server (0.pool.ntp.org) | 2020-10-15 20:36:25 +0000 UTC

PMM Server | 2020-10-15 20:36:25 +0000 GMT

PMM Client | 2020-10-15 16:36:25 -0400 EDT

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 DOWN

Connection duration | 1.401407ms

Request duration | -795.598µs

Full round trip | 605.809µs

can you please let me know how can we start the service ?

This QAN API service does it needs to be turned on the server side or the client side ?

Thanks,

Sai

Hi @saitarun . pls see https://www.percona.com/doc/percona-monitoring-and-management/faq.html#how-to-troubleshoot-communication-issues-between-pmm-client-and-pmm-server this might help. And if needed -