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


How can I remove a node when the database is currently down? — Vertica Forum

How can I remove a node when the database is currently down?

One of nodes (02) in our four-node development cluster is having its hard drive worked on. It's unavailable and has been wiped. I'd like to bring the database up. However, node 02 was taken out _after_ the database was brought down. I would have thought that I could bring the db up, and the other nodes would recognize that 02 is unavailable, etc. Instead, the db refuses to come up. Is there a way to get around this (tell the system to remove the node, etc) and then bring the db up?

Comments

  • If your system is K-safe 1, the database should come up with a node down.  If you aren't running K=1, then you will have data loss as the data from node 2 is not replicated anywhere else.

Leave a Comment

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