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

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

Views:
2
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...

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support