10
« on: August 16, 2012, 02:56:24 pm »
Hi,
Server Platform: Windows Server 2008 R2 standard (64bit)
NetXMS Server: netxms-1.2.2-x64
Since upgrading to 1.2.2 I'm having intermittent problems viewing graphs of DCI values and getting DCI collection failures in the client. In the server system log I get a number of entries when the DCI collection fails:
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): constraint failed
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): constraint failed
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): column event_id is not unique
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): constraint failed
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): column event_id is not unique
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): constraint failed
I then restart NetXMS Core and its ok again for a while before failing again with the same problem.
Any pointers on where I should be looking would a great help.
David