SQL Deadlocked on Lock Resources

NovaBACKUP xSP / Remote Workforce
Last Updated: Oct 31, 2012 09:55PM PDT

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
 

 

NovaCare Status

NovaStor Support

Contact Us

  • E-Mail NovaStor Support

    Click Here to submit your case to the NovaStor Support Team.

  • Phone Support

    If you have NovaCare Support you can call our support line:

    US Support:
    Call +1(805) 409-3140
    Press 2 for Technical Support
    Monday through Friday
    8am - 5pm PST

    EMEA Support:
    Call +49 (40) 63809 - 989
    Monday through Friday
    9am - 5pm CET (GMT+1)

TeamViewer