Vertica Data Repository backup fails with error

Products

• CA Infrastructure Performance

Issue/Introduction

Description:

Customer runs the following cmd to initiate the backup:

$ /opt/vertica/bin/vbr.py --task backup --config-file /data/backup.ini

And gets the error:

ERROR 4019: Must be superuser to run database_snapshot
When communicating with vertica, the process failed with code 1
backup failed!
Retrying... #1
ERROR 4019: Must be superuser to run database_snapshot
When communicating with vertica, the process failed with code 1
backup failed!
Retrying... #2
ERROR 4019: Must be superuser to run database_snapshot
When communicating with vertica, the process failed with code 1
backup failed!

Solution:

 

Environment

Release:
Component: IMSTOR

Resolution

IMPORTANT: This article contains information about modifying the registry.
Before you modify the registry, make sure to create back up of the registry and ensure that you understand how to restore the registry if a problem may occur.
For more information about how to back up, restore, and edit the registry, please review the relevant Microsoft Knowledge Base articles on support.microsoft.com.

As the druser (OS user), run /opt/vertica/bin/admintools and connect to the database to verify the dbuser and dbpassword entry that has been entered intothe backup .ini file (used in the backup cmd) is correct. In the case of the resulting error above, the improper user and password was used.

This caused the backup failure.