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

msanjibmsanjib Vertica Customer ✭
in General Discussion

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...