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
Object Level backup on 6.1
Moderator: NorbertKrupa
Re: Object Level backup on 6.1
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:44 pm, edited 1 time in total.
Re: Object Level backup on 6.1
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!
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!
Re: Object Level backup on 6.1
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:43 pm, edited 1 time in total.
Re: Object Level backup on 6.1
Thanks sKwa, that helps!
-
- Newbie
- Posts: 1
- Joined: Thu Jul 21, 2016 11:48 am
Re: Object Level backup on 6.1
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.
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.