The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Recovery from backup failed for schema

Hi all,
Got an issue while trying to recover a schema from an incremental backup taken today:

Storage [58546837430795737] end epoch [467028147] is beyond the backup epoch [467007974]. Aborting the operation as this can make the database inconsistent

Could you please suggest as to what can be done as a workaround?

Tagged:

Answers

  • SruthiASruthiA Employee

    Please check if projection 58546837430795737 has data in WOS. If so, please perform moveout and try recovery

  • Ran the following but found no output:
    select * from projections where projection_id = '58546837430795737';

    select * from v_monitor.storage_containers where storage_oid = '58546837430795737';

  • SruthiASruthiA Employee

    This seems to be a known bug. It has been fixed in vertica 8.x version. One possible workaround could be you can restore objects to different cluster with same number of nodes. Then backup the object again and then restore it in your cluster.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.