ERROR: Database did not start cleanly on initiator node!

Moderator: NorbertKrupa

Post Reply
jaysunn
Newbie
Newbie
Posts: 2
Joined: Wed Jan 22, 2014 6:19 pm

ERROR: Database did not start cleanly on initiator node!

Post by jaysunn » Wed Jan 22, 2014 6:34 pm

ENV: RHEL6.3
VERTICA: 7.0.0.1


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. So I uninstalled and downloaded the latest version. I have setup a successful 3 node DB and a successful 1 node DB in the past. Here is the admintools.conf:

Code: Select all

[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 errors:

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

jaysunn
Newbie
Newbie
Posts: 2
Joined: Wed Jan 22, 2014 6:19 pm

Re: ERROR: Database did not start cleanly on initiator node

Post by jaysunn » Wed Jan 22, 2014 8:27 pm

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.

Code: Select all

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

Code: Select all

[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
Thanks,
jaysunn

Post Reply

Return to “Vertica Installation”