After upgrade the agent from 3.1.0 to 3.2.0 agent then MariaDB service state always Down (MariaDB 10.6 version or higher versions)

Percona Monitoring and Management (PMM)
1

Description:

Following the upgrade from version 3.1.0 to version 3.2.0 of the pmm-agent, the MariaDB service status in the GUI service list is consistently displayed as Down state alone.

NOTE: However, it is now displaying UP state after downgrading to version 3.1.0.

As per the below screenshot, agents are running fine.

image
image1568×249 18 KB

image
image1891×332 32.6 KB

image
image1912×527 37.8 KB

Steps to Reproduce:

Install MariaDB version: 10.6 or above
PMM server and agent version: 3.2.0

Upgrade the PMM server and agent from version 3.1.0 to 3.2.0.

Logs:

Jun 5 09:32:07 tndmdb101 pmm-agent[3208560]: time=“2025-06-05T09:32:07.632-07:00” level=error msg=“time=2025-06-05T16:32:07.632Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘pmm_usr’@‘12.1.100.80’ (using password: YES)"” agentID=4d418fec-f81a-4111-8e9a-64610aad004f component=agent-process type=mysqld_exporter
Jun 5 09:32:09 tndmdb101 pmm-agent[3208560]: time=“2025-06-05T09:32:09.300-07:00” level=error msg=“time=2025-06-05T16:32:09.300Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘pmm_usr’@‘12.1.100.80’ (using password: YES)"” agentID=7902c189-b446-4ad5-a782-624786275f5f component=agent-process type=mysqld_exporter
Jun 5 09:32:10 tndmdb101 pmm-agent[3208560]: time=“2025-06-05T09:32:10.304-07:00” level=error msg=“time=2025-06-05T16:32:10.303Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘pmm_usr’@‘12.1.100.80’ (using password: YES)"” agentID=65c6de00-a7df-4c01-bb2a-3bf13199751b component=agent-process type=mysqld_exporter
Jun 5 09:32:12 tndmdb101 pmm-agent[3208560]: time=“2025-06-05T09:32:12.633-07:00” level=error msg=“time=2025-06-05T16:32:12.633Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘pmm_usr’@‘12.1.100.80’ (using password: YES)"” agentID=4d418fec-f81a-4111-8e9a-64610aad004f component=agent-process type=mysqld_exporter
Jun 5 09:32:12 tndmdb101 pmm-agent[3208560]: time=“2025-06-05T09:32:12.992-07:00” level=error msg=“time=2025-06-05T16:32:12.992Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘pmm_usr’@‘12.1.100.80’ (using password: YES)"” agentID=65c6de00-a7df-4c01-bb2a-3bf13199751b component=agent-process type=mysqld_exporter
Jun 5 09:32:14 tndmdb101 pmm-agent[3208560]: time=“2025-06-05T09:32:14.301-07:00” level=error msg=“time=2025-06-05T16:32:14.300Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘pmm_usr’@‘12.1.100.80’ (using password: YES)"” agentID=7902c189-b446-4ad5-a782-624786275f5f component=agent-process type=mysqld_exporter

Additional Information:

PMM user grants: GRANT SELECT, RELOAD, PROCESS, BINLOG MONITOR, SLAVE MONITOR,REPLICATION CLIENT ON . TO pmm_usr@10.12.8.30 IDENTIFIED BY ‘XXXXXXXX’ WITH MAX_USER_CONNECTIONS 10;

But I am able to log in with the above user, and with the 3.1.0 version, it was working fine.

Can someone please help me with the issue?

2

Once the ‘$’ symbol is eliminated from the password and the password is updated, the issue is fixed.

@nurlan Thank you so much for your timely assistance.

Maybe we should not include the special character symbols in the password going forward?