Violation of PRIMARY KEY constraint 'PK_Events'.

Real-time performance monitoring and troubleshooting

Violation of PRIMARY KEY constraint 'PK_Events'.

Veeam Logoby rolandk » Tue Jul 21, 2009 4:21 pm

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"
rolandk
Influencer
 
Posts: 16
Liked: never
Joined: Wed Jul 15, 2009 11:04 am
Full Name: RolandK

Re: Violation of PRIMARY KEY constraint 'PK_Events'.

Veeam Logoby Gostev » Tue Jul 21, 2009 8:17 pm

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.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Violation of PRIMARY KEY constraint 'PK_Events'.

Veeam Logoby rolandk » Tue Jul 21, 2009 9:07 pm

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
rolandk
Influencer
 
Posts: 16
Liked: never
Joined: Wed Jul 15, 2009 11:04 am
Full Name: RolandK


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests