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
Can you SELECT * FROM runtime_mysql_servers
using the same username/password as the PMM account?
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)
Now you know the reason Reconfigure pmm-client to use the admin user for proxysql.
Thanks. Worked like a charm! Will need to check/adapt the rights for that non-admin user.
Best,
Robert