-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
7.0.8
-
None
environment:
- Server 7.0.5
- Active Agent2 7.0.2
- PostgreSQL database
Result:
On the server in the logs multiple errors like:
36 duplicates missing
[Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique “history_pkey” constraint
CONNECT: The key (itemid, clock, ns)=(200806, 1738236706, 756826700) already exists.
2 duplicates missing
809348:20250130:143159.357 [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint “history_uint_pkey”
NOTE: The key (itemid, clock, ns)=(200516, 1738236716, 705656400) already exists.
This problem occurs only for Windows servers with the “Windows by Zabbix agent active” template applied. For Linux there is no such problem
No solution has been found at this time.
Expected:
Error in logs
- duplicates
-
ZBX-25148 Duplicate key value violates unique constraint
- READY TO DEVELOP