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

Server summary:mysql summary - Exit Status 1

brianbrian EntrantCurrent User Role Beginner
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?

Comments

  • weberweber Advisor Inactive User Role Beginner
    For system summary you need to install percona-toolkit package from percona repo on the pmm client node.
  • brianbrian Entrant Current User Role Beginner
    Oops, didn't see my post right away so reposted/duplicated ;~(>

    percona-toolkit was installed, still same issue.
  • weberweber Advisor Inactive User Role Beginner
    Please verify whether you can run "pt-summary" and "pt-mysql-summary" on the db node.
  • brianbrian Entrant Current User Role Beginner
    pt-mysql-summary works only with --ask-pass
  • brianbrian Entrant Current User Role Beginner
    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.
This discussion has been closed.

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