绑定完请刷新页面
取消
刷新

分享好友

×
取消 复制
Troubleshooting-Snapshotmetadataiscurrentlylocked
2022-07-18 16:40:36

现象

EsgynDB中做备份还原的时候报错“Snapshot metadata is currently locked for Tag”,

>>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.

解决

通过“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.


分享好友

分享这个小栈给你的朋友们,一起进步吧。

EsgynDB
创建时间:2022-03-30 10:10:17
EsgynDB
展开
订阅须知

• 所有用户可根据关注领域订阅专区或所有专区

• 付费订阅:虚拟交易,一经交易不退款;若特殊情况,可3日内客服咨询

• 专区发布评论属默认订阅所评论专区(除付费小栈外)

技术专家

查看更多
  • itt0918
    专家
戳我,来吐槽~