We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Bring back stand By node to permanent state in Vertica — Vertica Forum

Bring back stand By node to permanent state in Vertica

Hi,
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

Answers

  • SruthiASruthiA Administrator
    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

    ALTER NODE RESET ;
    (6359) ROLLBACK: Node v_vertexdb_node0012 has not been replaced.

    Thanks
    Hardik

  • SruthiASruthiA Administrator

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

Leave a Comment

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