unable to start database after server restart

I'm unable to start databases when the server reboots. I have only one node setup in vertica installation. I see that whenever the server reboots and when I try to start a database from adminTools, atleast once I get the following messages: -

 

*** Starting database: revgauge_demo ***
Starting nodes:
v_revgauge_demo_node0001 (127.0.0.1)
Starting Vertica on all nodes. Please wait, databases with large catalog may take a while to initialize.
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Node Status: v_revgauge_demo_node0001: (DOWN)
Error starting database, no nodes are up
Press RETURN to continue

 

 

After pressing Enter/Return, I get the following message:- 

 

Database startup failed. Too many nodes having invalid/ missing last good epoch values to continue.

Run diagnostics and contact Vertica  Technical Support.

 

I use DbVisualizer to query the database and noticed when DbVisualizer is open, then also I get the above error message. I have to close DbVisualizer and then try again or sometimes the database starts after a delay without any problem. Else sometimes I have to kill the 2 processes for the database and try starting the database again and then it starts. Can anyone explain this problem as to why it happens? And what could be the solution other than closing DbVisualizer or killing the process and retrying?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.