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