'pmm-admin remove --all --force' not removing mysql:queries

Percona Monitoring and Management (PMM) PMM 1.x
1

Hi,

I’m stuck in a situation where I can’t remove a mysql:queries probe, the situation below persists.
I have tried to remove and reinstall pmm-client, no joy.

It seems as if the server is keeping information about the config and is handing it out to the client on first reconnect after re-install.

The workflow/use case that has initially broken this setup was an upgrade of the DB server from CentOS 6 to CentOS 7 with pmm-client re-installation.

Any advice on how I can get out of this trouble would be very much appreciated.

Thanks!
A.

[root@xxx-mdb03 mysql]# pmm-admin remove --all --force
OK, 1 services were removed.
[root@xxx-mdb03 mysql]# pmm-admin list
pmm-admin 1.0.4

PMM Server | 172.30.140.10:8080
Client Name | xxx-mdb03
Client Address | 172.30.140.85
Service manager | linux-systemd

SERVICE TYPE NAME CLIENT PORT RUNNING DATA SOURCE OPTIONS

mysql:queries xxx -mdb03 42001 NO root:***@unix(/var/run/mysqld/mysqld.sock) query_source=slowlog

2

Hello,

We will have 1.0.5 release the next week which detects broken installation client side or server side and allows to do a repair.

In your case, I suggest to do the following: go to Consul web ui [url]http://server/consul/[/url] and deregister this particular service mysql:queries (42001) with alias “xxx-mdb03”. After that pmm-admin list should not list it and you should be able to re-add.

3

Thanks, you are a star! I couldn’t remove just the service but had to remove the whole node, but it seems that we’re back to normal now, thank you.

4

Great!

The next release will detect orphaned services on either local or remote side and the command “repair” will do the cleanup.