Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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--
[[email protected] ~]$ 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.




  • HibikiHibiki 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.