Failed to fetch pg_stat_monitor: sql: Scan error on column index 1, name \"client_ip\": converting NULL to string is unsupported"

[stevemayster]

Description

Hello
I try to setup PMM manager and got an error:

Failed to fetch pg_stat_monitor: sql: Scan error on column index 1, name "client_ip": converting NULL to string is unsupported"

in pmm-agent logs

Qan postgresql pgstatmonitor agent in Waiting state

My Postgres version is 15.11 and pg_stats_monitor version is 2.1.0 ( i also try to install 2.1.1 from Percona repo with same result)

I also have Postgres 16.2 version with pg_stats_monitor extension v. 2.1.1 running fine without issues

I checked for empty client_ip column in pg_stat_monitor but no luck

SELECT count(*) FROM pg_stat_monitor where client_ip is null return nothing

Expected Results

Qan postgresql pgstatmonitor agent in Running state and no errors in pmm-agent log

Actual Results

Qan postgresql pgstatmonitor agent in Waiting state and lot of errors in pmm-agent logs

Version

PMM server 3.0.0
PMM Agent:
Version: 3.0.0
PMMVersion: 3.0.0
Timestamp: 2025-01-23 13:50:41 (UTC)
FullCommit: d989d76

Steps to reproduce

Install pg_stat_monitor_15 , enable extension

Relevant logs

pmm-agent[851721]: time="2025-03-18T13:36:49.456+03:00" level=error msg="getNewBuckets failed: failed to fetch pg_stat_monitor: sql: Scan error on column index 1, name \"client_ip\": converting NULL to string is unsupported" agentID=7ec1a9b2-9775-4685-a4b0-cca174296425 component=agent-builtin type=agent_type_qan_postgresql_pgstatmonitor_agent

Code of Conduct

• I agree to follow Percona Community Code of Conduct