Skip to main content
Question

Bring back stand By node to permanent state in Vertica

  • November 29, 2018
  • 3 replies
  • 18 views

hdk0310
Forum|alt.badge.img+1

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

3 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • November 29, 2018

Please try the following to see if it works

alter database reset standby;


hdk0310
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • November 30, 2018

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


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • December 5, 2018

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