PMM Showing wrong number of nodes and services on dashboard

[Prashant]

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

[Prashant]

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

[Vadim_Yalovets]

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__=~".*"}'

[Vadim_Yalovets]

@Prashant

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.

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)

[Prashant]

Sorry for delayed reply.
Please find output in attached

[Vadim_Yalovets]

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

pmm-admin --version

[Prashant]

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

[Vadim_Yalovets]

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

[Prashant]

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.

[Prashant]

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.

[Vadim_Yalovets]

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

[Prashant]

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.

[Prashant]

This is example of negative monitoring DB services

[Vadim_Yalovets]

@Prashant

Is PMM support RDS MySQL/Postgress? as we can see the option dedicated option for RDS Aurora n mysql.

Yes, Postgresql services can be monitored.

[Vadim_Yalovets]

@Prashant

This is example of negative monitoring DB services

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

[Prashant]

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.

[Vadim_Yalovets]

@Prashant

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

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

[Vadim_Yalovets]

@Prashant

Can you provide me steps to do the same

Please make the dashboard editable

and click “Edit” on the element.

[Prashant]

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?

[Vadim_Yalovets]

Could you show the used formula first?