[ZBX-18084] pgsql.dbstat.checksum_failures.rate, Agent 2 PostgreSQL 12 monitoring Created: 2020 Jul 15  Updated: 2024 Apr 10  Resolved: 2022 Jan 31

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G)
Affects Version/s: 5.0.1
Fix Version/s: 6.0 (plan)

Type: Problem report Priority: Minor
Reporter: Aigars Kadikis Assignee: Vyacheslav Khaliev
Resolution: Duplicate Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File metric-not-supported.png     File raw.json    
Team: Team INT
Sprint: 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)
Story Points: 0.5

 Description   

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

 

 Comments   
Comment by Aigars Kadikis [ 2020 Jul 15 ]

Happens with zabbix_agent2 5.0.1

Comment by Vyacheslav Khaliev [ 2022 Jan 27 ]

Resolved in ZBX-19897

Generated at Sat Sep 13 22:01:20 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.