IT43154: FILESERVER BACKUP ERROR "BUSYERROR: DATABASE IS LOCKED"

APAR status

• Closed as documentation error.

Error description

• When running a backup job on Spectrum Protect Plus, it may fail
  intermittently with the error message "An unexpected error
  occurred trying to execute an SQL query to the metadata
  database." This behavior is expected when a new process attempts
  to access data while the database is locked by a currently
  running process.
  
  Job log error:
  ERROR,CTGGT0030,[x.x.x.x] An unexpected error occurred trying to
  execute an SQL query to the metadata database C:\Users\sppuser\
  AppData\Local\FSPA\directoryA\x.x.x.x_vpool1_fs1\spp_backup_met
  adata.db"C:\Users\sppuser\AppData\Local\FSPA\uncsymlinks\x.x.x.
  x_vpool1_fs3\spp_backup_metadata.db") - Error: BusyError: databa
  ERROR,CTGGT0186,[x.x.x.x] The backup job failed with the
  following error: Database exception: BusyError: database is
  locked
  
  
  Virgo log:
  ERROR http-nio-8082-exec-1761
  c.s.dp.xsb.api.commons.exception.ExceptionMessageTranslator
  com.syncsort.dp.xsb.api.commons.exception.XSBResourceNotFound:
  null
      at
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.7
  
  Additional Keywords: SPP, SPPLUS, TS010981624
  

Local fix

• To resolve this issue, it is important to check if there is an
  active antivirus on the system. If there is, please exclude the
  following path and its related subdirectories from the virus
  scan:C:\Users\sppuser\AppData\Local\FSPA
  
  The following example is based on a specific customer case,
  however, it serves to illustrate the general process. The
  location of the folder in question is dependent on the user that
  was provided during system registration. In general, the folder
  can be found at "%LOCALAPPDATA%\FSPA", where %LOCALAPPDATA% will
  vary depending on the user.
  
  For example, if the system was registered using the local
  "Administrator" account, the full path to the folder that should
  be excluded would be
  C:\Users\Administrator\AppData\Local\FSPA
  It's important to note that this path may vary depending on the
  specific user and system configuration.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus levels 10.1.7 - 10.1.13            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.14. Note that this is subject to change at the          *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• The Windows file systems backup and restore requirements: IBM
  Spectrum Protect Plus 10.1.14,
  https://www.ibm.com/support/pages/node/6952269,  has been
  updated with following instructions for configuring antivirus
  software:
  Anti-virus software can interfere with the operations of IBM
  Spectrum Protect Plus. Exclude from anti-virus scans on your
  Windows Server:
      The path %LOCALAPPDATA%\FSPA where <%LOCALAPPDATA%> varies
  depending upon the specific user during registration and system
  configuration.
      Example: if the system was registered using the local
  "Administrator" account, the full path to the folder that should
  be excluded would be C:\Users\Administrator\AppData\Local\FSPA.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels