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

pgsql.dbstat.checksum_failures.rate, Agent 2 PostgreSQL 12 monitoring

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • 6.0 (plan)
    • 5.0.1
    • Agent (G)
    • None
    • Sprint 66 (Jul 2020), Sprint 67 (Aug 2020), Sprint 68 (Sep 2020), Sprint 69 (Oct 2020), Sprint 70 (Nov 2020), Sprint 71 (Dec 2020), Sprint 72 (Jan 2021), Sprint 73 (Feb 2021), Sprint 74 (Mar 2021), Sprint 75 (Apr 2021), Sprint 76 (May 2021), Sprint 77 (Jun 2021), Sprint 78 (Jul 2021), Sprint 79 (Aug 2021), Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021), Sprint 83 (Dec 2021), Sprint 84 (Jan 2022)
    • 0.5

      Setup:

      PostgreSQL 12.2 via official TimescaleDB docker container:

      docker run --name pg12 -t \
      -e POSTGRES_PASSWORD="zabbix" \
      -e POSTGRES_DB="dummy_db" '
      -p 5432:5432 -d timescale/timescaledb:1.7.0-pg12
      

      Agent 2 via docker:

      docker run --name pg12mon \
      -e ZBX_HOSTNAME="pg12mon" \
      -e ZBX_SERVER_HOST="ip.of.postgresql.host" \
      -e ZBX_BUFFERSIZE="65535" \
      -e ZBX_REFRESHACTIVECHECKS="3600" \
      -e ZBX_STARTAGENTS="0" \
      -d zabbix/zabbix-agent2:alpine-5.0-latest

      Monitoring is done using "Zabbix agent (active)" checks only.

      Per each database it shows:

      Value "ZBX_NOTSUPPORTED: Checksum failures metric is supported only in PostgreSQL 12 or higher." of type "string" is not suitable for value type "Numeric (float)" 

       

      Master item contains:

      raw.json

       

            vkhaliev Vyacheslav Khaliev
            aigars.kadikis Aigars Kadikis
            Team INT
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: