SCSQL クローンライフサイクルジョブでデータベースのロックと接続解除が失敗する
環境
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...