Default Avatar

hdk0310

The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

hdk0310

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

About

Username
hdk0310
Joined
Visits
154
Last Active
Roles
Member
Points
12
Badges
3

Badges

Name DropperFirst Comment10 Comments

Activity

  • hdk0310 earned the Name Dropper badge.
    Mentioning someone in a discussion (like this: @Name) is a great way to encourage dialog and let them know who you’re talking to.
    September 3
  • hdk0310 earned the First Comment badge.
    Commenting is the best way to get involved. Jump in the fray!
    September 3
  • hdk0310 earned the 10 Comments badge.
    No longer a one-hit wonder! It looks like you’re going places.
    September 3