SQL query failed in table 'tdata_xxxx'

Started by Dani@M3T, January 04, 2016, 08:21:17 PM

Previous topic - Next topic

Dani@M3T

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?

Alex Kirhenshtein


Dani@M3T

#2
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.

Dani@M3T

#3
After deleting these 2 DCI tables I don't see this error anymore.

edit:
thanks!