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
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Policy.

Cheers for trusting us with the spot in your mailbox!

Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest

error icon

Oops! Something went wrong.

Please try again later.

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.

Click here to send feedback regarding this KB, or suggest content for a new KB.
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.

Spelling error in text

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case

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.
Thank you for your interest in Veeam products!
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please try again later.