Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL Table Details dashboard showing No Data #1771

Open
1 task done
GenLN opened this issue Feb 23, 2023 · 2 comments
Open
1 task done

MySQL Table Details dashboard showing No Data #1771

GenLN opened this issue Feb 23, 2023 · 2 comments
Assignees
Labels
bug Bug report

Comments

@GenLN
Copy link

GenLN commented Feb 23, 2023

Description

Dashboard showing no data. Hundreds of clients connected to PMM server.
Variable "Service Name" not loading any value.
Query used for service_name variable is
label_values(mysql_info_schema_table_version, service_name)

This raw metric also crash victoriametrics when used in explore.
Only queries using "by" works.. for example:
label_values(max by(service_name)(mysql_info_schema_table_version), service_name)

Maybe solution is to use some kind of aggregation on the query or simple change metric to "mysql_up" and it should look like:
label_values(mysql_up, service_name)

Expected Results

Showing data per service name

Actual Results

No data, empty var Service Name

Version

PMM Server 2.34 > PMM client 2.34

Steps to reproduce

No response

Relevant logs

No response

Code of Conduct

  • I agree to follow Percona Community Code of Conduct
@GenLN GenLN added the bug Bug report label Feb 23, 2023
@ritbl
Copy link
Contributor

ritbl commented Feb 23, 2023

Hey @GenLN, thanks for reporting. Can you please give more details on your setup and what you monitor. So that we can try to reproduce the behavior you are experiencing.
Please provide:

  • how do you run PMM Server and PMM Client
  • what databases you are monitoring (vendors+versions+number of instances)

@ritbl ritbl self-assigned this Feb 23, 2023
@GenLN
Copy link
Author

GenLN commented Mar 8, 2023

running in k8s PMM server using helm chart.
PMM clients in docker.
250+ instances mysql,mongodb

@ritbl ritbl removed their assignment Oct 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Bug report
Projects
None yet
Development

No branches or pull requests

4 participants