The Vertica Database Forums

Hi All,
I am trying to backup(and restore to test) a bunch of tables in vertica 6.1
It works for one set where i can successfully backup and recover(after dropping from same schema)the tables. I am running a three node cluster.
In this other case, however, it is throwing an error during restore. The strange thing is that the restore was working when i tested it before, so then i dropped the tables, created backup/restore for another set of tables(mutually exclusive list).
Now, when i try to restore the first set it throws an error:

All child processes terminated successfully.
select load_snapshot_prep('old_tables_02112014', true);
SQL command select load_snapshot_prep('old_tables_02112014', true); failed:
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together

anyone seen this before? please help

thanks
DGh

Hi!

[DELETED]

thanks !
that is some really good insight into the actual workings of vertica. I happened to have a backup of the table in another db and recreating the backup seemed to work(able to restore it successfully a few times)
is all the internal knowledge about vertica's workings documented somewhere or is it from your working and exploring with the tool that you figured it out?
thanks again for your help!

Hi!

[DELETED]

Thanks sKwa, that helps!

HI Team,

I am facing some problem with my backup operation. I a,m getting Wollongong message while restore.

[dbadmin@c23 ~]$ /opt/vertica/bin/vbr.py --task restore --config schema.ini --archive=20160720_101752
Preparing...
Found Database port: 5433
Copying...
[==================================================] 100%
All child processes terminated successfully.
SQL command select load_snapshot_prep('schema', true); failed:
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together

restore failed!
Retrying... #1


My procedure as follows,

1. Create a hardlink backup
2. move this to remote storage
3. Created another backup
4. restore the remote backup and try to restore.

I am using Vertica 7.0.1-4. please help me to resolve thtis.