Node get into ephemeral state while removing from database

Rohit_Sharma

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

Nimmi_gupta

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