Object Restore in 6.1 issue

Moderator: NorbertKrupa

Post Reply
whitish
Newbie
Newbie
Posts: 2
Joined: Wed Jan 09, 2013 11:52 am

Object Restore in 6.1 issue

Post by whitish » Mon Mar 17, 2014 9:04 pm

Dear All,

I m trying to restore my objects using vbr.py. The backup was made in vertica 6.1 and the restore version is vertica 7 (i didn't find any limitation to move 6.1 backup to vertica 7 though).

Code: Select all

vbr.py --task restore --config-file /opt/vertica/bin/rest_my.ini --debug 3 --showconfig
Config "rest_my.ini"

Code: Select all

[Misc]
snapshotName = full
verticaConfig = True
restorePointLimit = 1
objects = schema1,schema2,schema3,schema4,schema5

[Database]
dbName = scoring
dbUser = dbadmin
dbPassword=password
dbPromptForPassword = False

[Transmission]

[Mapping0]
dbNode = v_scoring_node0001
backupHost = 127.0.0.1
backupDir = /opt/bckp
I got error which says (see code below):
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible

Code: Select all

Preparing...
v_scoring_node0001 127.0.0.1 /opt/vertica/catalog/scoring/v_scoring_node0001_catalog
Found Database port:  5433
 DB      | Host      | State 
---------+-----------+-------
 scoring | 127.0.0.1 | UP    


g["upNodes"]: ['v_scoring_node0001']
g["downNodes"]: []
g["nodeStates"] {'v_scoring_node0001': 'UP'}
/opt/vertica/bin/vsql  -dscoring -p5433 -Udbadmin -X -q -c "select get_ahm_epoch();
"
 get_ahm_epoch 
---------------
             0
(1 row)


ahm:  0
new g["topology"] after filtering:  [{'backupDir': '/opt/bckp', 'dbHost': '127.0.0.1', 'dbNode': 'v_scoring_node0001', 'backupHost': '127.0.0.1', 'dbDir': '/opt/vertica/catalog/scoring/v_scoring_node0001_catalog'}]
set([('127.0.0.1', True), ('127.0.0.1', False)])
preparing on host 127.0.0.1...
preparing on host 127.0.0.1...
Recovering...
Copying... 
31406 :: 127.0.0.1 /opt/bckp/v_scoring_node0001/full 127.0.0.1 /opt/vertica/catalog/scoring/v_scoring_node0001_catalog
0 out of 0, 100%
All child processes terminated successfully.
select load_snapshot_prep('full', true);
SQL command select load_snapshot_prep('full', true); failed:
ERROR 4757:  SnapshotMemento does not match. Oid conflicts are possible
HINT:  Try restoring a cluster wide backup together

restore failed!
Retrying... #1
Recovering...
Copying... 
31611 :: 127.0.0.1 /opt/bckp/v_scoring_node0001/full 127.0.0.1 /opt/vertica/catalog/scoring/v_scoring_node0001_catalog
0 out of 0, 100%
All child processes terminated successfully.
select load_snapshot_prep('full', true);
SQL command select load_snapshot_prep('full', true); failed:
ERROR 4757:  SnapshotMemento does not match. Oid conflicts are possible
HINT:  Try restoring a cluster wide backup together

restore failed!
Retrying... #2
Recovering...
Copying... 
31823 :: 127.0.0.1 /opt/bckp/v_scoring_node0001/full 127.0.0.1 /opt/vertica/catalog/scoring/v_scoring_node0001_catalog
0 out of 0, 100%
All child processes terminated successfully.
select load_snapshot_prep('full', true);
SQL command select load_snapshot_prep('full', true); failed:
ERROR 4757:  SnapshotMemento does not match. Oid conflicts are possible
HINT:  Try restoring a cluster wide backup together

restore failed!
Does anybody have any clue how to find a proper workaround?

I have found similar question on this forum, but I didn't manage to manually modify catalog OIDs.

Thank you in advance for any hints.

Best,
-Alex
Last edited by whitish on Tue Mar 18, 2014 11:51 am, edited 1 time in total.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Object Restore in 6.1 issue

Post by NorbertKrupa » Tue Mar 18, 2014 2:48 am

Is this the question you're referring to?
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Backup & Recovery”