Database is not starting up

rahul_dharrahul_dhar
in General Discussion
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?

Comments

  • [Deleted User][Deleted User]
    Hi,

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

    Thanks,
    Pravesh

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...