Skip to main content

Posts

Showing posts from April, 2018

Veritca - Drop node / remove node on virtual environment when machine is already terminated

in our case I was trying to add 5 nodes to Vertica 10 nodes cluster. while adding the new nodes we were facing some problems with the file system and we were forced to terminate the new machines. we fixed the VM image and recreated the nodes in order to scale out Vertica cluster again. during this process we were keep getting an errors message like: "node x already exists" while running the add nodes command (although we removed them from admintools.conf and from the cluster using: /opt/vertica/sbin/install_vertica --remove-hosts) finally, we found out a solution that was very helpful in our case and is not documented well in Vertica documentation, (we were not able to find it there) drop node command. DROP NODE <node_name>;   probably leftovers of the first scale out run were stayed in the database metadata itself, I guess that when we terminated the new nodes after the first try we didn't notice that one of the nodes were still part of the cluster