EsgynDB执行备份还原时提示：Snapshot metadata is currently locked
【问题描述】
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博客 ” ，链接：https://blog.itpub.net/69985104/viewspace-2727449/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
