Vertica backup failing

Document ID : KB000004326
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When running the vertica backup it fails with the following error:

"When communicating with vertica, the process failed with code 1 backup failed!"

Environment:
2.x
Cause:

As the error is generic, you should run the backup with the --debug3 flag:

 

/opt/vertica/bin/vbr.py --task backup --config-file /path to .ini file/<filename>.ini --debug=3 

This identified the following error:

vsql: FATAL 3781: Invalid username or password 

Cannot connect to vertica database, please check server status or db parameters 

backup failed! 

Resolution:

To resolve, simply review the .ini file that was created to run the backup and change either the dbUser value or the password in the passwordFile, or possibly both.  The dbUser should be set to the same user that you use to open adminTools.  After doing this just rerun the backup and it should complete successfully