Vertica database restore failing

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

When attempting a restore of the vertica database the following error is seen:

Loading snapshot catalog from backup.

Error: SQL command "select load_snapshot_prep('new_schema_db_backup', 'CREATE_OR_REPLACE', '', '####');" failed: ERROR 6651:  Backup node [####] is not found in this cluster

Restore FAILED.

Environment

CAPM 3.x

Resolution

This is an indication that the "NodeMapping" section is missing from the backup configuration ini file that was created when you setup your backup.  You could add the following to the ini file:

 

[NodeMapping]

v_drdata_node0001 = v_drdata_node0001

v_drdata_node0002 = v_drdata_node0002

v_drdata_node0003 = v_drdata_node0003

 

... then run the restore again

 

See the "Additional Information" section for more information about the NodeMapping section

 

 

Additional Information

See the following URL for additional information on the NodeMapping section of the backup configuration file:

https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/ConfigFileReference/[NodeMapping].htm