Pmm-agent with proxysql exporter error: "Error scraping for collect.runtime_mysql_servers\"

Percona Monitoring and Management (PMM) PMM 2.x
1

Dears.
Having an issue with pmm-agent and proxysql exporter
Pmm-agent is excessively logging en error in message log, causing log files growth.
Error is:

Feb  6 16:48:57 hostname pmm-agent[800105]: time="2024-02-06T16:48:57.876+01:00" level=error msg="ts=2024-02-06T15:48:57.876Z caller=exporter.go:202 level=error msg=\"Error scraping for collect.runtime_mysql_servers\"" agentID=/agent_id/e00df7e2-3a57-4ff1-a036-c0e5015d443b component=agent-process type=proxysql_exporter

Running versions

  • pmm2-client.x86_64 2.40.1-6.el9
  • proxysql.x86_64 2.4.8-1.el9

Anyone came across such situation?

Thanks.
Kind regards,
Robert

2

Can you SELECT * FROM runtime_mysql_servers using the same username/password as the PMM account?

3

Hi,
running the command with user used while enabling proxysql metrics returns:

MySQL [(none)]> SELECT * FROM runtime_mysql_servers;
ERROR 1045 (28000): ProxySQL Admin Error: no such table: runtime_mysql_servers

while running as admin user:

MySQL [(none)]> SELECT * FROM runtime_mysql_servers;
+--------------+-------------+------+-----------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname    | port | gtid_port | status       | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+-------------+------+-----------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1            | host31.fqdn | 3306 | 0         | ONLINE       | 1      | 0           | 1000            | 0                   | 1       | 0              |         |
| 1            | host41.fqdn | 3306 | 0         | ONLINE       | 100    | 0           | 1000            | 0                   | 1       | 0              |         |
| 2            | host31.fqdn | 3306 | 0         | ONLINE       | 1      | 0           | 1000            | 0                   | 1       | 0              |         |
| 3            | host31.fqdn | 3306 | 0         | ONLINE       | 1      | 0           | 1000            | 0                   | 1       | 0              |         |
| 3            | host41.fqdn | 3306 | 0         | ONLINE       | 100    | 0           | 1000            | 0                   | 1       | 0              |         |
| 4            | host41.fqdn | 3306 | 0         | OFFLINE_HARD | 100    | 0           | 1000            | 0                   | 1       | 0              |         |
+--------------+-------------+------+-----------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
6 rows in set (0.002 sec)
4

Now you know the reason :wink: Reconfigure pmm-client to use the admin user for proxysql.

5

Thanks. Worked like a charm! Will need to check/adapt the rights for that non-admin user.
Best,
Robert

6

same error. mysql pmm-client version is 2.40.1. I found that it is because the admin-stats_credentials user which is pmm doc suggested is not allow to query runtime_mysql_servers. I think we should update the doc

USAGE

pmm-admin add proxysql --username=pmm --password=pmm

where username and password are credentials for the administration interface of the monitored ProxySQL instance. You should configure a read-only account for monitoring using the admin-stats_credentials variable in ProxySQL