Page 1 of 4

Database Creation fails

Posted: Fri Oct 04, 2013 3:43 pm
by oppelo
Hi:
I am trying to create a database on a VM on my laptop. I want the database to be created on an external drive which is a MOUNT point.
I am not having any luck. The following is the error:

*** Creating database: VDemoDB ***
127.0.0.1 OK [vertica][(6, 1, 2)][000][x86_64]
Creating database VDemoDB
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
Node Status: v_vdemodb_node0001: (DOWN)
ERROR: Database did not start cleanly on initiator node!
Stopping all nodes
Press RETURN to continue

The following is my admintools.com

[Configuration]
install_opts = []
default_base = /mnt/hgfs/VDBs
show_hostnames = False
format = 3

[Cluster]
hosts = 127.0.0.1
spread_hosts =

[Nodes]
node0001 = 127.0.0.1,/mnt/hgfs/VDBs,/mnt/hgfs/VDBs
v_vdemodb_node0001 = 127.0.0.1,/mnt/hgfs/VDBs,/mnt/hgfs/VDBs
v_vdemodb_node0001 = 127.0.0.1,/mnt/hgfs/VDBs,/mnt/hgfs/VDBs

Any help would be appreciated.

Thanks
Velu

Re: Database Creation fails

Posted: Fri Oct 04, 2013 4:12 pm
by JimKnicely
Hi,

Can you post the contents of the /opt/vertica/log/adminTools-root.log file? This is the log which will contain the errors and messages.

Re: Database Creation fails

Posted: Fri Oct 04, 2013 4:48 pm
by oppelo
That file was never updated since the VM was created way back in June. However, /opt/vertica/log/adminTools-dbadmin.log was updated.

Re: Database Creation fails

Posted: Fri Oct 04, 2013 4:54 pm
by JimKnicely
Are there any errors in that file?

Re: Database Creation fails

Posted: Fri Oct 04, 2013 5:02 pm
by oppelo
i am not sure. Can I email you the file directly.

Re: Database Creation fails

Posted: Fri Oct 04, 2013 8:04 pm
by JimKnicely
Sure!

Re: Database Creation fails

Posted: Sat Oct 05, 2013 3:54 pm
by oppelo
I have uploaded a ZIP file with all my files. Any help would be much appreciated. I need this done this weekend because I have to load and test the DB for a meeting on Monday.