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

Jason_Ralph

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

Jason_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_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