We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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.

Cheers,
SM

Tagged:

Answers

  • HibikiHibiki Vertica Employee Employee

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

Leave a Comment

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