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

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

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 http://server/consul/ 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.

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.

Great!

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