Our database went down and I can not get it to restart using the admintools. When I try and start it, I get the following messages:
Code: Select all
*** Starting database: finance_wh01 ***
Node Status: v_finance_wh01_node0001: (DOWN) v_finance_wh01_node0002: (DOWN) v_finance_wh01_node0003: (DOWN)
Node Status: v_finance_wh01_node0001: (DOWN) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (DOWN) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Node Status: v_finance_wh01_node0001: (INITIALIZING) v_finance_wh01_node0002: (INITIALIZING) v_finance_wh01_node0003: (INITIALIZING)
Nodes DOWN: v_finance_wh01_node0001, v_finance_wh01_node0002, v_finance_wh01_node0003 (may be still initializing).
It is suggested that you continue waiting.
Do you want to continue waiting? (yes/no) [yes] no
Database startup successful, but it may be incomplete. Some nodes
remain in a transitional state. Waiting can sometimes resolve this
problem. See Database Cluster State in Main Menu for updated
cluster state. If this state persists, try using the Advanced menu
to Stop Vertica on Host, then Restart Database.
Press RETURN to continue
Please help!
Thanks,
Jeff