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

PMM QAN - can't add mysql:queries

Hello,

Installing pmm-client on new servers. linux:metrics and mysql:metrics have been added successfully. While adding mysql:queries I receive an error:

[[email protected] /]# pmm-admin add mysql:queries --query-source perfschema
Error adding MySQL queries: problem with agent registration on QAN API: exit status 1

Repair doesn't help:

[[email protected] /]# pmm-admin repair
No orphaned services found.

PMM list:

[[email protected] /]# pmm-admin list
pmm-admin 1.3.2

PMM Server | 10.147.x.x (password-protected)
Client Name | 0913lbmysql01
Client Address | 10.149.x.x
Service Manager | unix-systemv






SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS





linux:metrics 0913lbmysql01 42000 YES -
mysql:metrics 0913lbmysql01 42002 YES pmm:***@unix(/opt/mysql/mysql.sock) tablestats=OFF

Network-check:

[[email protected] /]# pmm-admin check-network
PMM Network Status

Server Address | 10.147.x.x
Client Address | 10.149.x.x

* System Time
PMM Server | 2017-10-20 05:47:57 +0000 GMT
PMM Client | 2017-10-20 13:48:59 +0800 IRKT
PMM Client to PMM Server Time Drift | 62s
Time is out of sync. Please make sure the server time is correct to see the metrics.

* Connection: Client --> Server

SERVER SERVICE STATUS

Consul API OK
Prometheus API OK
Query Analytics API DOWN

Connection duration | 47.348766ms
Request duration | 48.225644ms
Full round trip | 95.57441ms


* Connection: Client <-- Server





SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD





linux:metrics 0913lbmysql01 10.149.x.x:42000 OK YES YES
mysql:metrics 0913lbmysql01 10.149.x.x:42002 OK YES YES


From the Prometheus side:

https://10.149.x.x:42000/metrics
UP




https://10.149.x.x:42002/metrics-hr
UP




https://10.149.x.x:42002/metrics-mr
UP




https://10.149.x.x:42002/metrics-lr
UP


PMM version:
[[email protected] /]# rpm -qa | grep -i pmm
pmm-client-1.3.2-1.x86_64


Linux and mysql metrics work fine. But QAN doesn't.

How to fix this issue and add mysql:queries?

Regards,
Mikhail Golenkov

Comments

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.