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

jeffjeff Registered User

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 Administrator, Moderator, Employee, Registered User, VerticaExpert
    edited March 6

    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