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
Installing Vertica 7.0.0-1 RHEL6.3x64 Unable to create database
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.
Thanks,
jaysunn
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 VERTICA10Thanks,
jaysunn
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
[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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
