hdk0310
✭
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
Reactions
-
Node went down due to insufficient catalog space and not coming up.
Hi, 2 of the nodes in my 13 node cluster has went down due to insufficient catalog space. I saw there was lot of space occupied by vertica.log file so cleared those and restarted the database. One of… (View Post)-1