Server summary:mysql summary - Exit Status 1

PMM Ver 1.05, Grafana seems fine on OS, Percona-Mysql.

Did a pmm-admin remove mysql:queries, then added back

pmm-mysql-queries-42001.log shows:

Version: percona-qan-agent 1.0.5

Basedir: /usr/local/percona/qan-agent

Listen: 127.0.0.1:42001

PID: 24463

API: 192.168.0.24/qan-api

UUID: 015a594c599943cd62fb5b3f9ad37c00

09:43:40.458053 main.go:165: Starting agent…

09:43:40.458517 main.go:343: Agent is ready

09:43:40.462348 main.go:207: API is ready

09:44:04.674202 ERROR agent exit status 1

09:44:04.674264 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:eb6dc548-ac1b-4b9a-7d2d-9f94f7e813b5]

09:44:48.460546 WARNING data-sender Waiting for API to ack qan_1479231720025795596: read tcp 192.168.0.175:38511->192.168.0.24:80: i/o timeout

09:47:30.728374 ERROR agent exit status 1

09:47:30.728464 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:adcb7031-93fa-445f-4357-9c6ef3dc3315]

All communication are via LAN with MY firewall rules allowing everything and anything on 192.168.0.0/24 (still digging into what Docker does as far as chains and rules).

On the server, qan-api.log (not sure about this warning yet):

09:44:51 mysql.go:178: WARNING: %!s(int=30) duplicate query class metrics: start_ts=‘2016-11-15 17:41:00.00059533 +0000 UTC’: MySQL ab743f3216584e9e4c4c6f6e191ef3df

09:44:51 mysql.go:242: WARNING: duplicate global metrics: start_ts=‘2016-11-15 17:41:00.00059533 +0000 UTC’: MySQL ab743f3216584e9e4c4c6f6e191ef3df

What am I missing, ideas?

For system summary you need to install percona-toolkit package from percona repo on the pmm client node.

Oops, didn’t see my post right away so reposted/duplicated ;~(>

percona-toolkit was installed, still same issue.

Please verify whether you can run “pt-summary” and “pt-mysql-summary” on the db node.

pt-mysql-summary works only with --ask-pass

Problem solved.

On Wheezy/Percona client, mkdir /etc/percona-toolkit, vi /etc/percona-toolkit/pt-mysql-summary.conf and insert one line: p=yourpassword

run: pt-mysql-summary --config /etc/percona-toolkit/pt-mysql-summary.conf

Now mysql summary shows up on the pmm server.