IT43383: RESTORE OF SQL AG DATABASE FAILS TO GET THE CLUSTER SHARED VOLUME MOUNT INFORMATION AND CLUSTER CRASHES

APAR status

• Closed as program error.

Error description

• When IBM Spectrum Protect Plus performs SQL Server Always ON
  Availability Group database restore on Failover Cluster
  Instances (FCI) server, it attempts to add restore cluster drive
  from "Available Storage" resource group to "Cluster Shared
  Volume" resource group. This fails with following error:
  
  
  CTGGE0060,[sql-server] Database [sql-db]  instance
  [sql-instance]  pre-restore error[Failed to get the cluster
  shared volume mount information].
  
  
  The issue affects SQL AAG of FCI replicas sharing cluster
  drives.
  
  
  The windows event log shows:
  
  
  Error,<date-time>,Microsoft-Windows-FailoverClustering,1069,Re
  sourceControl Manager,"Cluster resource '<cluster-resource-name>
  type 'SQL Server Availability Group' in clustered role
  '<cluster-role>' failed.
  
  
  This also leads to cluster crash and all servers need to be
  restarted.
  
  
  IBM Spectrum Protect Plus Versions affected: IBM Spectrum
  Protect Plus v10.1.*
  
  Additional keywords: TS012019425 SPP
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus 10.1.x.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus 10.1.15.  *
  * Note that this is subject to change at the discretion of IBM *
  ****************************************************************
  

Problem conclusion

• This problem has been fixed so that SQL production restore will
  skip adding backup volume to cluster shared volume resource
  group, to avoid impacting production cluster resources.
  

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

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels