EsgynDB執行備份還原時提示:Snapshot metadata is currently locked

joshliu發表於2020-10-16

【問題描述】

        EsgynDB(trafodion)資料庫執行備份還原操作時提示:Snapshot metadata is currently locked

>>RESTORE TRAFODION, TAG 'full4backup_00212429333584910646';
*** ERROR[5050] RESTORE command could not be completed. Reason: Snapshot metadata is currently locked for Tag: full4backup_00212429333584910646
--- SQL operation failed with errors.

【問題原因】

        根據錯誤資訊提示是lock問題,通過get all locked objects;檢視被lock的物件;

>>get all locked objects;
Operation:RESTORE Tag:full4backup_00212429333584910646 Object:_BACKUP_full4backup_00212429333584910646_.__SCHEMA__
Operation: lockCheck Tag: full4backup_00212429333584910646 Object: Snapshot Metadata
--- SQL operation complete.

【問題解決】

        使用cleanup backup ,tag xxx清除被lock的物件;

>>cleanup backup ,tag 'full4backup_00212429333584910646';
--- SQL operation complete.


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/69985104/viewspace-2727449/,如需轉載,請註明出處,否則將追究法律責任。

相關文章