I just migrated to Timescaledb and now I'm getting an error like below every 10-20 minutes. Its always 337_337_history_log_pkey but the statement is always different.
Anyone have a hint? It's strange that zabbix might be trying to insert the same log entry twice. I don't quite follow.
```
ERROR: duplicate key value violates unique constraint "337_337_history_log_pkey"
DETAIL: Key (itemid, clock, ns)=(99380, 1709699986, 877000000) already exists.
STATEMENT: insert into history_log (itemid,clock,ns,timestamp,source,severity,value,l ogeventid) values (99380,1709699986,877000000,1709699957,'Schannel', 4,'The following fatal alert was received: 40.',36887);
```
After thinking about this... I might have two items for collecting similar windows event logs for different purposes. I wonder if that somehow exposed this issue.
Anyone have a hint? It's strange that zabbix might be trying to insert the same log entry twice. I don't quite follow.
```
ERROR: duplicate key value violates unique constraint "337_337_history_log_pkey"
DETAIL: Key (itemid, clock, ns)=(99380, 1709699986, 877000000) already exists.
STATEMENT: insert into history_log (itemid,clock,ns,timestamp,source,severity,value,l ogeventid) values (99380,1709699986,877000000,1709699957,'Schannel', 4,'The following fatal alert was received: 40.',36887);
```
After thinking about this... I might have two items for collecting similar windows event logs for different purposes. I wonder if that somehow exposed this issue.

Comment