Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

EON Mode: Error Removing Nodes

[Code: 9098, SQL State: V1002] [Vertica]VJDBC ROLLBACK: Cannot drop 1 primary nodes. The cluster would appear partitioned and the database would shutdown

This happened when going from a 3 node cluster to 1 node. I was not able to remove a node to completely go to a single node cluster. Vertica kept me at 2 nodes. I tested this on v9.3.1


Best Answer

  • GoCougsGoCougs ✭✭
    Answer ✓

    This looks like it was a vertica bug that was fixed. Make sure you upgrade to vertica 11. That is what fixed it for me.


Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.