1-800-691-1991 | 9am - 8pm ET
EN

Transaction was deadlocked

KB ID: 1177
Product: Veeam Backup & Replication
Version: 5.x
Published: 2011-08-24
Last Modified: 2020-08-13

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.

KB ID: 1177
Product: Veeam Backup & Replication
Version: 5.x
Published: 2011-08-24
Last Modified: 2020-08-13

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Knowledge base content request
By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Policy.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

ty icon

Thank you!

We have received your request and our team will reach out to you shortly.

OK

error icon

Oops! Something went wrong.

Please go back try again later.