The Vertica Forum recently got a makeover! Let us know what you think by filling out this short survey.

Failure attempting to Create Database after new install

Hello,

Immediately following a fresh install on 3 hosts, I try to create a DB via admintools and get the following output. Hosts 02 and 03 never move from the (DOWN) state.  Any ideas on what the cause could be?

Thanks,

Matt

*** Creating database: MattTestDB ***
                        10.0.0.239 OK [vertica][(6, 1, 3)][000][all]
                        10.0.0.240 OK [vertica][(6, 1, 3)][000][all]
                        10.0.0.241 OK [vertica][(6, 1, 3)][000][all]
                Checking full connectivity
        Creating database MattTestDB
        Node Status: v_matttestdb_node0001: (DOWN)
        Node Status: v_matttestdb_node0001: (INITIALIZING)
        Node Status: v_matttestdb_node0001: (VALIDATING LICENSE)
        Node Status: v_matttestdb_node0001: (UP)
        Creating database nodes
        Creating node v_matttestdb_node0002 (host 10.0.0.240)
        Creating node v_matttestdb_node0003 (host 10.0.0.241)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)
        Node Status: v_matttestdb_node0001: (UP) v_matttestdb_node0002: (DOWN) v_matttestdb_node0003: (DOWN)


Comments

  • Some further info, the contents of dbLog from each node:

    [email protected]:/data/MattTestDB$ more dbLog
    Connected to spread at host 10.0.0.239(10.0.0.239) port 4803

    [email protected]:/data/MattTestDB# more dbLog
    Connected to spread at host 10.0.0.240(10.0.0.240) port 4803

    [email protected]:/data/MattTestDB# more dbLog
    Connected to spread at host 10.0.0.241(10.0.0.241) port 4803





  • Interestingly, if I try and create a DB from a different node, I get a similar effect, but it is always the node local to the instance of admintools which reports UP while the other two are down. This seems to imply some connectivity issue but I don't know what:

            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)
            Node Status: v_testdb_node0001: (DOWN) v_testdb_node0002: (UP) v_testdb_node0003: (DOWN)


  • Hi Matt,

    Hm...  Yes, that does sound like a connectivity issue of some sort.  Do you have any sort of firewall between your nodes?  In particular, is UDP traffic able to get through smoothly?  We rely on UDP for a lot of our initialization and control messages; it's also, unfortunately, often blocked or lossy on certain types of networks, and so needs a little more configuration...

    Have you run Vertica's "vnetperf" tool?  It may give you some pointers about network configuration:

    https://my.vertica.com/docs/6.1.x/HTML/index.htm#19284.htm

    Adam
  • I am  Also  getting  the same  issue  . I have  only one  node  and  while  running  the command  /opt/vertica/bin/admintools -t view_cluster, it is  not  listing  anything  . I am really  don't  know  how to proceed  here 

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.