[ZBX-20877] Unsupproted item key for "PostgreSQL by zabbix agent" (also agent2) templates Created: 2022 Apr 11  Updated: 2022 Jul 14  Resolved: 2022 Jul 14

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I), Templates (T)
Affects Version/s: 6.0.3
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Attila Cseke Assignee: Karlis Salins
Resolution: Won't Do Votes: 0
Labels: agent, database, items
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

ubuntu 20.04, zabbix 6 LTS, postgresql 14


 Description   

Hi,

I am trying to configure postgres monitoring for postgresql-14 database on ubuntu 20.04. Zabbix server and agents (v. 6.0.3) are also running on ubuntu 20.04. 

Firewall, db, zabbix config seems OK, yet I am getting unsupported item keys for all postgres related keys.

 

Here is output of zabbix_agentd (similar for zabbix_get on the server)

 zabbix_agentd -t "pgsql.config.hash["127.0.0.1","5432","zbx_monitor","zbx_monitor","postgres"]"
pgsql.config.hash[127.0.0.1,5432,zbx_monitor,zbx_monitor,postgres] [m|ZBX_NOTSUPPORTED] [Unsupported item key.]

 

Here is a section of the zabbix_server.log

11031:20220411:131038.618 item "dev-04:pgsql.replication.lag.b["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11033:20220411:131039.619 item "dev-04:pgsql.bgwriter["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11034:20220411:131040.620 item "dev-04:pgsql.connections["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131041.620 item "dev-04:pgsql.dbstat.sum["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131042.621 item "dev-04:pgsql.dbstat["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11033:20220411:131043.622 item "dev-04:pgsql.locks["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11034:20220411:131044.623 item "dev-04:pgsql.ping["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131045.624 item "dev-04:pgsql.replication.count["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131046.626 item "dev-04:pgsql.replication.lag.sec["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131047.627 item "dev-04:pgsql.replication.recovery_role["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131048.628 item "dev-04:pgsql.replication.status["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131049.631 item "dev-04:pgsql.uptime["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131050.632 item "dev-04:pgsql.autovacuum.count["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131051.632 item "dev-04:pgsql.archive["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131052.635 item "dev-04:pgsql.wal.stat["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11033:20220411:131055.635 item "dev-04:pgsql.cache.hit["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Cannot evaluate function: not enough data at "last(//pgsql.dbstat.sum.blks_hit.rate) * 100 / (last(//pgsql.dbstat.sum.blks_hit.rate) + last(//pgsql.dbstat.sum.blks_read.rate))".
 11034:20220411:131056.636 item "dev-04:pgsql.oldest.xid["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11034:20220411:131056.640 item "dev-04:pgsql.replication.process["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131057.641 item "dev-04:pgsql.queries["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}","\{$PG.DATABASE}","\{$PG.QUERY_ETIME.MAX.WARN}"]" became not supported: Unsupported item key.

Looked on the web for 2 days for a solution, but I could not find anything relevant to my case.

 

 Comments   
Comment by Karlis Salins [ 2022 Apr 12 ]

Hello,
This error appears because agent does not know of the items.

Be careful with correct templates(these are for 6.0, make sure you are using the latest available agent version):
This template is for Zabbix Agent
This template is for Zabbix Agent 2

Please check if you are using the correct one and follow all instructions written in the template manual.

Best regards,
Karlis

Comment by Attila Cseke [ 2022 Apr 27 ]

Hi,

Thank you for your answer. 

I had to copy the sql-s and the conf file into the proper directories. After that it started working. So the problem was on my end, we can close this report. not an issue with zabbix.

Regards,

Attila Cseke

Generated at Fri May 02 07:04:50 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.