Skip to main content

Database is not starting up

  • August 13, 2013
  • 1 reply
  • 9 views

rahul_dhar
I have 3 nodes as a cluster. When i tried restarting the database, i am encountering following error - Nodes DOWN: v_im22_node0001, v_im22_node0002, v_im22_node0003 (may be still initializing). It is suggested that you continue waiting. Do you want to continue waiting? (yes/no) [yes] yes Node Status: v_im22_node0001: (DOWN) v_im22_node0002: (INITIALIZING) v_im22_node0003: (INITIALIZING) Node Status: v_im22_node0001: (DOWN) v_im22_node0002: (INITIALIZING) v_im22_node0003: (INITIALIZING) Node Status: v_im22_node0001: (DOWN) v_im22_node0002: (INITIALIZING) v_im22_node0003: (INITIALIZING) Node Status: v_im22_node0001: (DOWN) v_im22_node0002: (INITIALIZING) v_im22_node0003: (INITIALIZING) Node Status: v_im22_node0001: (DOWN) v_im22_node0002: (INITIALIZING) v_im22_node0003: (INITIALIZING) Status of Node 1 is DOWN as it seems there is no database on it (system crash might have caused it). However, as node 2 and node 3 have database on it, so i am trying to make the database up on them but the status for them doesn't change to UP. After sometime it threw a pop up suggesting to retry or run diagnostics and contact vertica technical team. Can anybody help me understand how can i bring the database up?

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • August 13, 2013
Hi,

Do you see catalog & data directories on node 01?
If not, create directories manually and try restarting the DB.

Thanks,
Pravesh