We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Installing Vertica 7.0.0-1 RHEL6.3x64 Unable to create database — Vertica Forum

Installing Vertica 7.0.0-1 RHEL6.3x64 Unable to create database

Jason_RalphJason_Ralph
in General Discussion
I am attempting to create a database using the adminTools.  I plan to add future nodes to this cluster but as of now I have just one, I read that I needed to use IP address and not localhost to add future nodes. Here is the admintools.conf:

[dbadmin@VERTICA10 config]$ cat admintools.conf
[Configuration]
last_port = 5433
default_base = /home/dbadmin
format = 3
install_opts = -s '172.21.20.156' -r '/root/vertica-7.0.0-1.x86_64.RHEL5.rpm'
spreadlog = False
controlsubnet = default
controlmode = broadcast

[Cluster]
hosts = 172.21.20.156

[Nodes]
node0001 = 172.21.20.156,/home/dbadmin,/home/dbadmin
v_vertica_vdb7_node0001 = 172.21.20.156,/mnt/data1/vertica/catalog_v7,/mnt/data1/vertica/data_v7
v_vdb_v7_node0001 = 172.21.20.156,/mnt/data1/vertica/catalog_v7,/mnt/data1/vertica/data_v7
v_vdb_v7_hap_node0001 = 172.21.20.156,/mnt/data1/vertica/catalog_v7,/mnt/data1/vertica/data_v7
v_hap_vdb7_node0001 = 172.21.20.156,/mnt/data1/vertica/catalog_v7,/mnt/data1/vertica/data_v7

========================================================================

Here is the error:

*** Creating database: VDB_HAP_7 ***
            172.21.20.156 OK [vertica][(7, 0, 0)][001][x86_64]
    Creating database VDB_HAP_7
    Starting bootstrap node v_vdb_hap_7_node0001 (172.21.20.156)
    Starting nodes:
        v_vdb_hap_7_node0001 (172.21.20.156)

    Starting Vertica on all nodes. Please wait, databases with large catalogs may take a while to initialize.

    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
    Node Status: v_vdb_hap_7_node0001: (DOWN)
ERROR:  Database did not start cleanly on initiator node!
        Stopping all nodes
Press RETURN to continue

====================================================================
/etc/hosts:
[root@VERTICA10 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6


172.21.20.156 VERTICA10.pftctrading.local VERTICA10
=====================================================================
tail -n100 /opt/vertica/log/adminTools-dbadmin.log

/data1/vertica/catalog_v7/VDB_HAP_7/v_vdb_hap_7_node0001_catalog/spread.conf'
2014-01-22 11:29:16.071 unknown:0x7fcb49889700 [Init] <INFO> Listening on port: 5433
2014-01-22 11:29:16.071 unknown:0x7fcb49889700 [Init] <INFO> About to fork
2014-01-22 11:29:16.072 unknown:0x7fcb49889700 [Init] <INFO> About to fork again
2014-01-22 11:29:16.072 unknown:0x7fcb49889700 [Init] <INFO> Completed forking
2014-01-22 11:29:16.072 unknown:0x7fcb49889700 [Init] <INFO> Startup [Connecting to Spread] Connecting to spread 4803
2014-01-22 11:29:46.088 unknown:0x7fcb49889700 [Init] <INFO> Spread daemon does not appear to be running on 172.21.20.156 -- exiting!

Jan 22 11:31:16  <BashAdapter: dbadmin@172.21.20.156>: (rc=0) []
Jan 22 11:31:16  <BashAdapter: dbadmin@172.21.20.156>: ['rm -rf /mnt/data1/vertica/catalog_v7/VDB_HAP_7']
Jan 22 11:31:16  <BashAdapter: dbadmin@172.21.20.156>: (rc=0) []
Jan 22 11:31:16  <BashAdapter: dbadmin@172.21.20.156>: ['rm -rf /mnt/data1/vertica/data_v7/VDB_HAP_7']
Jan 22 11:31:16  <BashAdapter: dbadmin@172.21.20.156>: (rc=0) []
Jan 22 11:31:16      Multi-node DB creation unsuccessful
Jan 22 11:31:16      Create DB complete, signaling FAIL


===================================================================
Not sure where else to look for any useful information.  Thank you for your time.

Jason






Comments

  • Jason_RalphJason_Ralph
    For others, I solved this by installing with the hostname instead of the
    IP address, I am thinking something with /etc/hosts not matching my
    install string. Here is the string and /etc/hosts file that worked.<BR />[root@VERTICA10 tmp]# /opt/vertica/sbin/install_vertica -s VERTICA10 -r /root/vertica-7.0.0-1.x86_64.RHEL5.rpm
    [root@VERTICA10 tmp]# cat /etc/hosts<BR /># Do not remove the following line, or various programs<BR />127.0.0.1 localhost.localdomain localhost<BR />172.21.20.156 VERTICA10

    Thanks,
    jaysunn
  • Jason_RalphJason_Ralph
    For others, I solved this by installing with the hostname instead of the IP address, I am thinking something with /etc/hosts not matching my install string. Here is the string and /etc/hosts file that worked.

    [root@VERTICA10 tmp]# /opt/vertica/sbin/install_vertica -s VERTICA10 -r /root/vertica-7.0.0-1.x86_64.RHEL5.rpm



        [root@VERTICA10 tmp]# cat /etc/hosts
        # Do not remove the following line, or various programs
        127.0.0.1       localhost.localdomain localhost
        ::1             localhost6.localdomain6 localhost6

        172.21.20.156 VERTICA10

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 ...