PMM Showing wrong number of nodes and services on dashboard

Hi Team,
We have only one node in monitoring that is also its own pmm server, but still on dashboard we are getting worng number of nodes and services. sometimes the node value goes inot negative i.e -1. Please let me know any solution for this

We have installed PMM server using docker. Pleas let me know how to clean up all the history data in PMM?

1 Like

Please use API request → delete_series

e.g.

curl -G -u admin:admin -k 'https://172.17.0.2/prometheus/api/v1/admin/tsdb/delete_series' --data-urlencode 'match[]={__name__=~".*"}'
1 Like

Negative values are really puzzling. Both elements are using count function.

Could you provide an output of the next query?
count by (agent_type) (up)

1 Like

Sorry for delayed reply.
Please find output in attached

1 Like

It looks strange that no vmagent is working in your installation.
Could you make sure that pmm-agent is uptodate?

pmm-admin --version
1 Like

sh-4.2# pmm-admin --version
ProjectName: pmm-admin
Version: 2.21.0
PMMVersion: 2.21.0
Timestamp: 2021-08-26 14:26:43 (UTC)
FullCommit: 7aa417cd9db7091a018032112b0f1d98665934fa

1 Like

Also could you provide an output of “pmm-admin list” command?
It looks like vmagent isn’t working on your installation.

Screenshot 2021-10-15 at 10.47.27

1 Like

I am getting below error. I am executing command with “root” user.

~ #docker exec -it pmm-server pmm-admin list
Unauthorized. Please check username and password.

1 Like

hi @Vadim_Yalovets,

Need your expert advice on below,
I am getting below error. I am executing command with “root” user.

~ #docker exec -it pmm-server pmm-admin list
Unauthorized. Please check username and password.

1 Like

Please exec the command on client side. You are doing it on your PMM server.

1 Like

Hi adivinho,

I am mostly monitoring RDS MySQL, So I cant access to underline OS in this case to run this command on client node. I have add RDS MySQL monitoring using access key and secret Key and it is using cloudwatch to monitor various metrices.
Is PMM support RDS MySQL/Postgress? as we can see the option dedicated option for RDS Aurora n mysql.

1 Like

image
This is example of negative monitoring DB services

1 Like

Yes, Postgresql services can be monitored.

1 Like

Could make sure that it’s used the original formula?
I have no idea how “count” operator could provide a negative value.

1 Like

Could make sure that it’s used the original formula? >> Can you provide me steps to do the same.

Yes, Postgresql services can be monitored >> you mean to say MySQL and Aurora can not be monitored under option of RDS services.

1 Like

MySQL, Aurora, Postgresql can be monitored under the option of RDS services.

1 Like

Please make the dashboard editable
Screenshot 2021-10-27 at 12.24.28

and click “Edit” on the element.
Screenshot 2021-10-27 at 12.24.46

1 Like

Sure I will do the same. One more thing need to clarify. should I Uninstall everything start with scratch again? is this resolve all this issue?

1 Like

Could you show the used formula first?

1 Like