Error: Existing single-node localhost (loopback) cluster cannot be expanded

deb0687

Hi,

 

I have install single node Vertica using Loop back IP (127.0.0.1) log back.

 

Now I am adding nodes to make it 3 node cluster.

 

But while doing update_vertica --add-hosts 16.183.41.34,16.183.41.35 its showing the below error

 

Error: Existing single-node localhost (loopback) cluster cannot be expanded

Hint: Move cluster to external address first. See online documentation.

Installation FAILED with errors.

 

What can be the solution to proceed ?

 

Thanks in advance.

[Deleted User]

Hi,

 

Unfortunately you cannot add nodes when you installed with 127.0.0.1. The process to change the IP is not simple and need tech support assistance.

 

It is documented that this is not possible.

http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/ManageNodes/AddingNodes.htm?Highlight=adding nodes

 "Important: : If you installed HP Vertica on a single node without specifying the IP address or hostname (or you used localhost), you cannot  expand the cluster. You must reinstall HP Vertica and specify an IP address  or hostname that is not localhost/127.0.0.1."

 

 

 However what you can do is:

 1- Create an other 1 node database with one of the new nodes that you want to add. Use the right IP there.
 2- Use the copy cluster funcition to copy the data from the cluster 127.0.0.1 to the new database
 3- Now DB in point 1 is your database, add the 2 nodes to your new database.

 

 Here is a lync with details how to use the copy cluster function
 http://my.vertica.com/docs/7.2.x/HTML/index.htm#search-copy cluster
 
 I hope this helps,
 
 Eugenia