We see from time to time this error in server log:
[ERROR] SQL query failed (Query = "INSERT INTO tdata_1466 (item_id,tdata_timestamp,record_id) VALUES (?,?,?)"): 23505 ERROR: duplicate key value violates unique constraint "tdata_1466_record_id_key "
DETAIL: Key (record_id)=(1558995887784001536) already exists.
We are on NetXMS V2.0 on PostgreSQL.
How can we fix this?
How often you are collecting this table?
How can I find the name or ID of this table?
edit:
I suppose '1466' of 'tdata_1466' is the ID of the node. I see 2 test tables collected every minute. I just deleted both.
After deleting these 2 DCI tables I don't see this error anymore.
edit:
thanks!