现象
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.来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69953058/viewspace-3119793/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SQL Server 表分区注意事项
请登录后发表评论
登录
全部评论
