The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Node get into ephemeral state while removing from database
Rohit_Sharma
Vertica Customer
Hi People,
I have came across with the issue where I am trying to remove the node from EON database where my shard count is 6 and node count is 6 and I am trying to remove 1 node.
while removing I came across with the error and when I tried "select * from nodes" I saw the node removed is in ephemeral state.
here I gone through ephemeral document of vertica which says the data gets rebalance and then the state will turn into "Standby".
but I want to remove the node from the database, can anyone suggest on this ?
Thanks in advance for valuable suggestions
Best,
Rohit
Tagged:
0
Answers
Rohit,
Did you follow the doc steps, (below link) Remove Hosts From the Database. I did a quick test and it worked fine. Can you try and also can you share the select * from vs_nodes;
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/UsingVerticaOnAWS/RemovingHostsFromTheDatabase.htm?tocpath=Using Vertica on the Cloud|Vertica on Amazon Web Services|Remove Nodes From a Running AWS Cluster|_____1