-
Problem report
-
Resolution: Unresolved
-
Minor
-
None
-
None
-
PostgreSQL 16 + Timescaledb + Zabbix Server 7.0.3
-
Sprint candidates
There is an assumption that this may be related to old versions of zabbix-agent. Since version 6.0, the history scheme has been significantly changed by adding primary keys item, clock, ns. Since we use old zabbix-agent, we could not receive (or take into account) data that should be unique (item, clock, ns). What do you think?)
```
2333:20240320:215501.796 [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "6817_3461_history_uint_pkey"
DETAIL: Key (itemid, clock, ns)=(218671, 1710960896, 0) already exists.
2333:20240320:215501.907 skipped 218 duplicates
```
To confirm this theory, I am attaching tickets + code.
https://support.zabbix.com/browse/ZBXNEXT-6921
https://support.zabbix.com/si/jira.issueviews:issue-html/ZBX-22695/ZBX-22695.html