Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Bring back stand By node to permanent state in Vertica

I have a 12 node cluster in which all the 12 nodes are working fine. I did an experiment to keep a node on stand by (let's say node 12-- node_type=STANDBY and node_state=STANDBY). It worked the way I thought If one of the node is down standby node will be active. Now I wanted it to Revert it back to the original. I do not want any of the nodes in STANDBY state all should be up with NODE_TYPE=PERMANENT. But Vertica is not allowing for the same. If I do ALTER NODE (node‑name) RESET; It gives an error: [Code: 6359, SQL State: 55000] [Vertica]VJDBC ROLLBACK: Node (node-name) has not been replaced. Any help will be appreciated. Thanks - clear


  • SruthiASruthiA Employee
    edited November 2018

    Please try the following to see if it works

    alter database reset standby;

  • Hi Shruthi,

    Thanks for your response.

    This command doesn't work.
    alter database reset standby;-- It runs successfully without any error or warning but node still remains in STANDBY state. No impact on node state

    (6359) ROLLBACK: Node v_vertexdb_node0012 has not been replaced.


  • Please open a support case. I think it needs catalog editing.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.