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