Removed a node from a cluster when the node no longer exists.

I am trying to remove a node from a cluster but the machine itself is no longer around. We removed the node from the database before decommissioning it but did not realized it needed to be removed from the cluster as well.

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited March 2019

    Can you try dropping the node?

    SELECT rebalance_cluster();
    DROP NODE <<node_name>> CASCADE;
    

    If that does't work, you'll have to use the catalog editor to remove the node. Do you have Vertica Support? If so, open a support case and they can help you do that.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file