Description:
I made a backup of ClickhouseDB, VM, and PostgreSQL after updating from 2.44 to 3.2.0.
On the new testing server, I installed the 3.2.0 version and restored the backup to see if it was functioning properly. I am unable to view any PostgreSQL-related metrics on the PMM Health Check Dashboard following the backup import.
Steps to Reproduce:
- Upgrade PMM version from 2.44.0 to 3.2.0
- Take a backup after the 3.2.0 upgrade.
- Install 3.2.0 on the new test server
- Restore the backup to the new test server.
- Verify the PostgreSQL dashboards in the PMM Health. Here metrics are empty.
Version:
PMM - 3.2.0
Logs:
Inside the PMM3.2.0 container, observed the below errors.
From the postgresql14.log:
postgres=#
2025-06-24 07:38:42.710 UTC [35048] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:43.991 UTC [35050] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:43.992 UTC [35051] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:43.993 UTC [35052] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:44.996 UTC [35053] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:44.996 UTC [35054] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:48.992 UTC [35067] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:48.992 UTC [35068] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:48.993 UTC [35069] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:49.997 UTC [35070] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:49.997 UTC [35071] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
2025-06-24 07:38:51.704 UTC [35078] FATAL: role “AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=” does not exist
From the pmm-agent.log:
time=“2025-06-24T08:52:48.989+00:00” level=info msg=“ts=2025-06-24T08:52:48.988Z caller=server.go:75 level=info msg="Established new database connection" fingerprint=127.0.0.1:5432” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:48.994+00:00” level=error msg=“ts=2025-06-24T08:52:48.993Z caller=collector.go:202 level=error msg="Error opening connection to database" err="error querying postgresql version: pq: role \"AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=\" does not exist"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:49.994+00:00” level=error msg=“ts=2025-06-24T08:52:49.994Z caller=datasource.go:107 level=error msg="Error opening connection to database" dsn="postgres://AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=:PASSWORD_REMOVED@127.0.0.1:5432/postgres?connect_timeout=1&sslmode=disable" err="pq: role \"AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=\" does not exist"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:49.994+00:00” level=info msg=“ts=2025-06-24T08:52:49.994Z caller=server.go:75 level=info msg="Established new database connection" fingerprint=127.0.0.1:5432” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:49.995+00:00” level=error msg=“ts=2025-06-24T08:52:49.994Z caller=datasource.go:107 level=error msg="Error opening connection to database" dsn="postgres://AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=:PASSWORD_REMOVED@127.0.0.1:5432/postgres?connect_timeout=1&sslmode=disable" err="pq: role \"AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=\" does not exist"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:49.995+00:00” level=info msg=“ts=2025-06-24T08:52:49.994Z caller=server.go:75 level=info msg="Established new database connection" fingerprint=127.0.0.1:5432” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:50.999+00:00” level=error msg=“ts=2025-06-24T08:52:50.998Z caller=postgres_exporter.go:770 level=error err="Error opening connection to database (postgres://AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=:PASSWORD_REMOVED@127.0.0.1:5432/postgres?connect_timeout=1&sslmode=disable): pq: role \"AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=\" does not exist"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:50.999+00:00” level=error msg=“ts=2025-06-24T08:52:50.999Z caller=postgres_exporter.go:770 level=error err="Error opening connection to database (postgres://AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=:PASSWORD_REMOVED@127.0.0.1:5432/postgres?connect_timeout=1&sslmode=disable): pq: role \"AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=\" does not exist"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:51.702+00:00” level=info msg=“ts=2025-06-24T08:52:51.702Z caller=percona_exporter.go:86 msg="Excluded databases" databases="[template0 template1 cloudsqladmin pmm-managed-dev azure_maintenance rdsadmin]"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:51.702+00:00” level=info msg=“ts=2025-06-24T08:52:51.702Z caller=server.go:75 level=info msg="Established new database connection" fingerprint=127.0.0.1:5432” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:52.159+00:00” level=error msg=“cannot get MySQL version: Error 1045 (28000): Access denied for user ‘AX4rfqpFN9wEjDQhoUufeTDLA3QFWlOQ0k9ZmVK3p8vWLFHG’@‘101.11.8.17’ (using password: YES)” agentID=6237ca76-efc0-4db9-9b0a-77b726fdfa21 component=agent-builtin type=qan_mysql_perfschema_agent
time=“2025-06-24T08:52:52.511+00:00” level=info msg=“time=2025-06-24T08:52:52.510Z level=INFO source=mysqld_exporter.go:243 msg=collect params=custom_query.hr,global_status,info_schema.innodb_metrics,standard.go,standard.process” agentID=75ee6d78-0749-4fb0-852e-b1e943e101e4 component=agent-process type=mysqld_exporter
time=“2025-06-24T08:52:52.539+00:00” level=error msg=“time=2025-06-24T08:52:52.539Z level=ERROR source=exporter.go:137 msg="Error opening connection to database" err="Error 1045 (28000): Access denied for user ‘AX4rfqoj4flI70EYXybEL56vKOERIPVZAQBpQHnOJxcpVwZ+’@‘101.11.8.17’ (using password: YES)"” agentID=75ee6d78-0749-4fb0-852e-b1e943e101e4 component=agent-process type=mysqld_exporter
time=“2025-06-24T08:52:52.707+00:00” level=error msg=“ts=2025-06-24T08:52:52.706Z caller=datasource.go:107 level=error msg="Error opening connection to database" dsn="postgres://AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=:PASSWORD_REMOVED@127.0.0.1:5432/postgres?connect_timeout=1&sslmode=disable" err="pq: role \"AX4rfqpWrkZZADKTxBeIh9AZDlLlNXPtvMgznavIl82Vc2U5+LZLX+P1XG8=\" does not exist"” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter
time=“2025-06-24T08:52:52.707+00:00” level=info msg=“ts=2025-06-24T08:52:52.707Z caller=server.go:75 level=info msg="Established new database connection" fingerprint=127.0.0.1:5432” agentID=be09d7c1-6b62-4c0a-b1d7-19f2af019646 component=agent-process type=postgres_exporter