メインコンテンツまでスキップ

SCSQL クローンライフサイクルジョブでデータベースのロックと接続解除が失敗する

Views:
9
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

環境

SnapCenter Plug-in for SQL ( SCSQL )

問題

  • SCSQL クローン操作はデータベースの接続解除および名前変更に失敗しました
  • 次のエラーメッセージが SMSQL_[job-ID] .log flie に記録されます

2021-01-08T02:05:12.7456187-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Database [DATABASE_NAME] is going to be Offline...
2021-01-08T02:05:15.4487241-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Detaching database [DATABASE_NAME]...
2021-01-08T02:05:15.4643359-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] RenameClone Enter 
2021-01-08T02:05:35.8645534-08:00 ERROR SmSql_11538 PID=[4180] TID=[69] Exception in RenameClone : Rename failed for Database 'CLONE_NAME'. 
2021-01-08T02:05:35.8645534-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Detach Clone: CLONE_NAME
2021-01-08T02:06:26.0936100-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Database [CLONE_NAME] is going to be Offline...
2021-01-08T02:06:30.3357704-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Detaching database [CLONE_NAME]...
2021-01-08T02:06:30.3513832-08:00 ERROR SmSql_11538 PID=[4180] TID=[69] Rename clone operation failed: Rename failed for Database 'CLONE_NAME'. 
2021-01-08T02:06:30.3513832-08:00 ERROR SmSql_11538 PID=[4180] TID=[69] Attaching original database: DATABASE_NAME
2021-01-08T02:06:30.3513832-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Attaching database: [DATABASE_NAME]
2021-01-08T02:06:32.0435319-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] Removing dbname CLONE_NAME from tempclones list
2021-01-08T02:06:32.0435319-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] createClonedDatabase End
2021-01-08T02:06:32.0435319-08:00 ERROR SmSql_11538 PID=[4180] TID=[69] The database could not be exclusively locked to perform the operation.
2021-01-08T02:06:32.0435319-08:00 ERROR SmSql_11538 PID=[4180] TID=[69] Failed to refresh the clone. The database could not be exclusively locked to perform the operation.
2021-01-08T02:06:32.0435319-08:00 DEBUG SmSql_11538 PID=[4180] TID=[69] CreateClone Done...

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.