Details
-
Problem report
-
Status: Closed
-
Trivial
-
Resolution: Incomplete
-
6.2.3
-
None
-
None
Description
Zabbix 6.2.3, PG13+TS+PK{}
Steps to reproduce:
- Create host with discover trapper items-prototype
Result:
2022-10-18 12:24:25.266 MSK pid=[2829262] sql_state=23505 user=zabbix host=10.12.213.247(45088) ERROR: duplicate key value violates unique constraint "history_uint_pkey" 2022-10-18 12:24:25.266 MSK pid=[2829262] sql_state=23505 user=zabbix host=10.12.213.247(45088) DETAIL: Key (itemid, clock, ns)=(1992660, 1666084790, 2) already exists. 2022-10-18 12:24:25.266 MSK pid=[2829262] sql_state=23505 user=zabbix host=10.12.213.247(45088) STATEMENT: insert into history_uint (itemid,clock,ns,value) values (1992660,1666084790,2,0)..............
Аfter delete items and re-discover:
2022-10-18 13:50:25.309 MSK pid=[2828903] sql_state=23505 user=zabbix host=10.12.213.247(44730) ERROR: duplicate key value violates unique constraint "history_uint_pkey" 2022-10-18 13:50:25.309 MSK pid=[2828903] sql_state=23505 user=zabbix host=10.12.213.247(44730) DETAIL: Key (itemid, clock, ns)=(4654961, 1666089891, 2) already exists. 2022-10-18 13:50:25.309 MSK pid=[2828903] sql_state=23505 user=zabbix host=10.12.213.247(44730) STATEMENT: insert into history_uint (itemid,clock,ns,value) values (4654961,1666089891,2,0)..............