Violation of PRIMARY KEY constraint 'PK_Events'.

[rolandk]

i suddenly have problems with one host (see attached log)

deleting the host and re-adding doesn`t work. veeam monitor tells "this object is still being removed. please try again later"

i`m using 4.0.1 beta

07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Hardware sensors info stored in 0.1 seconds"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "VMFS mount info stored in 0.0 seconds"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Power states stored in 0.0 seconds"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Collecting performance data (period: 21.07.2009 04:04:26 - 21.07.2009 04:09:43)"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "CollectRealTimePerfData: 21.07.2009 04:04:26 - 21.07.2009 04:09:43"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Realtime performance data retrieved in 0.2 seconds. Data for 2 items received."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Preprocessing of performance data complete in 0.0 seconds"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Storing performance data in _HIGH resolution table"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Performance data stored in 0.0 seconds. 696 values stored in 200 records."
07/21/09 04:09:43 Warning 0x0FA0 10.40.0.193 "696 records skipped"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "PerfData was saved to cache in 0.00 seconds"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Getting and storing events (period: 07/20/2009 18:29:35 - 07/21/2009 04:09:43)"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "0 event was added to database."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "5 events skipped"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Collecting datastores usage data"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Preprocessing of performance data complete in 0.0 seconds"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Storing performance data in _HIGH resolution table"
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "Performance data stored in 0.0 seconds. 2 values stored in 1 records."
07/21/09 04:09:43 Inform 0x0FA0 10.40.0.193 "PerfData was saved to cache in 0.00 seconds"
07/21/09 04:10:01 Inform 0x12D0 alarms "Detect Alarm: 0.016"
07/21/09 04:10:11 Inform 0x0A18 vcs "Collection cycle started. Checking connection..."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Collection cycle started. Checking connection..."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Connection OK"
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Getting and storing events (period: 07/20/2009 18:29:35 - 07/21/2009 04:10:11)"
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 1 of 2: The statement has been terminated."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "Throwing exception."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "0 event was added to database."
07/21/09 04:10:11 Inform 0x0FA0 10.40.0.193 "5 events skipped"
07/21/09 04:10:11 Inform 0x0A18 vcs "Connection OK"
07/21/09 04:10:11 Inform 0x0A18 vcs "Getting and storing events (period: 07/20/2009 15:21:56 - 07/21/2009 04:10:11)"
07/21/09 04:10:12 Inform 0x0A18 vcs "A database error (code:0x80040E2F, ) has occured in context of storing event in database. Error information follows"
07/21/09 04:10:12 Inform 0x0A18 vcs "Error record 1 of 2: The statement has been terminated."
07/21/09 04:10:12 Inform 0x0A18 vcs "Error record 2 of 2: Violation of PRIMARY KEY constraint 'PK_Events'. Cannot insert duplicate key in object 'dbo.Events'."
07/21/09 04:10:12 Inform 0x0A18 vcs "Throwing exception."
07/21/09 04:10:13 Inform 0x0A18 vcs "0 event was added to database."
07/21/09 04:10:13 Inform 0x0A18 vcs "2 events skipped"
07/21/09 04:10:21 Inform 0x12D0 alarms "Detect Alarm: 0.125"

[Gostev]

Hello Roland, the logs you have provided do not indicate any issues. Inability to add the host back right away after deletion is normal too, and is expected. Please wait for some more time for database to clean up, and try to add the host again.

[rolandk]

ok, i deleted the host from veeam monitor and got the message i could not add it because of deletion in progress about 5 minutes after delete. and i deleted it, because no performance counters were shown - then i saw these errors in the log which made me think i have an issue here.

so, i will try re-add the host tomorrow.

thanks
roland