https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IxMTc3IiwiaGFzaCI6IjNjYjA3M2Y2LWY5YzktNGRjNi05OWIyLTcwYzc4NWE5NTE0NiJ9
1-800-691-1991 | 9am - 8pm ET
EN

Transaction was deadlocked

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
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

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

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.

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.