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.
[root@xxx-mdb03 mysql]# pmm-admin remove --all --force
OK, 1 services were removed.
[root@xxx-mdb03 mysql]# pmm-admin list
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