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
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
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!
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