Vertica cluster backup failed with error :ROLLBACK 4236: nodes did not open a data connection

msanjibmsanjib Vertica Customer

3 node cluster:
all are up and running.
The remote host is having ssh pwdless connection from the box , I am running the backup.
Executed: vbr -t init -c full_local_backup.ini --debug 3 // it worked
$vbr -t backup -c full_local_backup.ini --debug 3 // getting error anything missing ? Please advise
Here is the error--
[verticauser@PE2MYDB3UATNODE3 ~]$ vbr -t backup -c full_local_backup.ini --debug 3
Starting backup of database appdefenderdb.
Participating nodes: v_appdefenderdb_node0001, v_appdefenderdb_node0002, v_appdefenderdb_node0003.
Error: SQL command "select instanceid from v_internal.vs_local_nodes;" failed: ROLLBACK 4236: One or more nodes did not open a data connection to this node. This may indicate a network configuration problem. Check that the private interfaces used for communication among the cluster hosts reside in the same subnet and are returned first by host address lookup
Backup FAILED.




  • Options
    HibikiHibiki Vertica Employee Employee

    Can you see any detailed log messages in vbr.log file?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file