Transaction was deadlocked

KB ID:
1177
Product:
Veeam Backup & Replication
Version:
5.x
Published:
Last Modified:
2011-11-28

Challenge

When trying to delete backups in Veeam console, the following error occurs:
Failed to execute stored procedure, Name:[[Backup.Model.DeleteOIB]], Params: [@id=db4fc35a-aecb-43cb-87d0-b9260825e7c5]. Transaction (Process ID xx) was deadlocked on lock | generic waitable object resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The following entry can be seen in the VeeamShell log file:

[timestamp]  <32> Error    Failed to execute stored procedure. Name: [[Backup.Model.DeleteOIB]], Params: [@id = db4fc35a-aecb-43cb-87d0-b9260825e7c5].

[timestamp]  <01> Error    Failed to execute stored procedure. Name: [[Backup.Model.DeleteOIB]], Params: [@id = db4fc35a-aecb-43cb-87d0-b9260825e7c5].   at Veeam.Backup.Common.CBackgroundFunctionRunner.Run(Function function, Form splashForm)

[timestamp]  <01> Error       at Veeam.Backup.Common.CBackgroundFunctionRunner.Run(Function function, String message)

[timestamp]  <01> Error       at Veeam.Backup.UI.CBackupsDeletion.DeleteBackupFromDisk(CBackup backup)

[timestamp]  <01> Error       at Veeam.Backup.UI.BackupDeleteCommand.Execute()

[timestamp]  <01> Error    Transaction (Process ID xx) was deadlocked on lock | generic waitable object resources with another process and has been chosen as the deadlock victim. Rerun the transaction.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

[timestamp]  <01> Error       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

[timestamp]  <01> Error       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

[timestamp]  <01> Error       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

[timestamp]  <01> Error       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

[timestamp]  <01> Error       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

[timestamp] <01> Error       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

[timestamp]  <01> Error       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

[timestamp] <01> Error       at Veeam.Backup.DBManager.CDbAccessor.ExecNonQuery(String spName, SqlParameter[] spParams)

Solution

A hot-fix needs to be applied to the current version 5.0.2.230.

More Information

The hot-fix will be included in the next version.

Please be aware that we’re making changes which will restrict access to product updates for users without an active contract.

OK

Rate the quality of this KB article: 
5 out of 5 based on 1 ratings

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text:

Submit