remove node out of the cluster

Peacherr

- We have 8 node in the cluster
- Node 6 have problem
- we replace Node 6 with Node9
- Now node 9 up
- Node 6 take standby state

we need to remove node 6 out of the cluster
but it always shows message
" All node need UP "

How can I remove node 6 (standby state) out of the cluster

Adrian_Oprea_1

 All nodes must be up in order to remove one node. 

 

What is the status of your node 6 , can you stat it up ?

 

Peacherr

it show node_state is standby it means node 6 not up 

but the cluster show status UP.

 

I found this document guide how to remove. and I try to remove node by using MC instead . it cannot click the button

 

 

 

Remove Unused Hosts From the Database Using MC

 

You remove nodes from a database cluster on MC's Manage page. Click the node you want to act upon, and then click Remove node in the Node List.

Using MC, you can remove only nodes that are part of the database cluster and which show a state of DOWN (red). When you remove a node, its color changes from red to clear and MC updates its state to STANDBY. You can add STANDBY nodes back to the database later.

 

 

SruthiA

Hi,

 

       Can you try resetting the state of Active Standby node before you remove node out of the cluster. Please find the instructions in the below URL

 

https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/ManageNodes/RevertingaHotStandbyNode.htm%3FTocPath%3DAdministrator's%2520Guide%7CManaging%2520the%2520Database%7CManaging%2520Nodes%7CActive%2520Standby%2520Nodes%7C_____3

 

 

 

Sruthi

Peacherr

thanks