Warnings for database save failure

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

Warning: consider replacing deprecated section [Mapping0] with
    [Mapping] in config file
    Warning: consider replacing deprecated section [Mapping1] with
    [Mapping] in config file
    Warning: consider replacing deprecated section [Mapping2] with
    [Mapping] in config file
    Preparing...
    Found Database port:  5433
    Warning: Node state of v_drdata_node0001 is UNKNOWN; ideally node
    should be UP for backup; empty backup will be created on this node.
    Warning: Node state of v_drdata_node0002 is UNKNOWN; ideally node
    should beUP for backup; empty backup will be created on this node.
    Warning: Node state of v_drdata_node0003 is UNKNOWN; ideally nodeshould be
    UP for backup; empty backup will be created on this node.
    Traceback (most recent call last):
      File "/opt/vertica/bin/vbr.py", line 2130, in backup
        mapping = g["topology"][0]
    IndexError: list index out of range
    backup failed unexpectedly!
    Retrying... #1
    Traceback (most recent call last):
      File "/opt/vertica/bin/vbr.py", line 2130, in backup
        mapping = g["topology"][0]
    IndexError: list index out of range
    backup failed unexpectedly!

<snipped>

When checking the database state though adminTools, the cluster is showing UP.

 After exiting admintools ANSI Graphics GUI and scrolling through the SSH buffer, we noticed out of space errors.

/opt was 100% utilized.

Cause: The Vertica 6 config file (backup.ini) had not been updated properly. Looking at that file, you can see the deprecated sections

that the warnings were referring to:

[Misc]
snapshotName = backup_snapshot
verticaConfig = True
restorePointLimit = 1

[Database]
dbName = drdata
dbUser = caadmindb
dbPassword = XXXXX

[Transmission]

[Mapping0]
dbNode = v_drdata_node0001
backupHost = tx003
backupDir = /CA/backups

[Mapping1]
dbNode = v_drdata_node0002
backupHost = tx004
backupDir = /CA/backups

[Mapping2]
dbNode = v_drdata_node0003
backupHost = tx005
backupDir = /CA/backups

Here is a copy of the backup.ini edited for Vertica 7:

[Misc]
snapshotName = backup_snapshot
verticaConfig = True
restorePointLimit = 1

[Database]
dbName = drdata
dbUser = caadmindb
dbPassword = XXXXX

[Transmission]

[Mapping]
v_drdata_node0001 = tx003:/CA/backups
v_drdata_node0002 = tx004:/CA/backups
v_drdata_node0003 = tx005:/CA/backups


You can see the difference in the [Mapping] section. This needs to be
modified in the Vertica6 version after upgrading to Vertica7 to get rid of
the "Warning: consider replacing deprecated section [Mapping0] with [Mapping]
in config file " warnings.