Troubleshooting-Snapshotmetadataiscurrentlylocked

现象

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.