Skip to main content

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

  • March 4, 2019
  • 1 reply
  • 5 views
jeff

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.

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • March 6, 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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement