Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20877

Unsupproted item key for "PostgreSQL by zabbix agent" (also agent2) templates

    XMLWordPrintable

Details

    • Problem report
    • Status: Need info
    • Trivial
    • Resolution: Unresolved
    • 6.0.3
    • None
    • 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.

       

      Attachments

        Activity

          People

            ksalins Karlis Salins
            patekfilip Attila Cseke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: