SQL Deadlocked on Lock Resources
NovaBACKUP xSP / Remote Workforce
Masterlog on Storage Server is showing error...
Source: Microsoft OLE DB Provider for SQL Server
Query:
Error number: 80004005
Native error number: 1205
Error Description: Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction..
A deadlock occurs when two system server process IDs (SPIDs) are waiting for a resource and neither process can advance because the other process is preventing it from getting the resource.
Microsoft KB Article: _http://support.microsoft.com/kb/832524
This issue is resolved in the release of version 12.2 of the Storage Server, however if you are still on 12.1, please follow the instructions below.
Attached to this FAQ is the SQL script to alter/create the stored procedure that appears to be at the root of the issue in version 12.1
Before executing it, either rename the existing stored procedure "apf_volume_get_volume_files", or change the "CREATE" command to "ALTER" to overwrite the old procedure.
To execute:
- Block port 308
- Stop the BackupServer service
- Open SQL Enterprise Manager
- Run the script against the BackupServer database
- Restart the BackupServer service
- Open port 308