After a successful installation when I try to create a database this is what I get:
*** Creating database: kakukk ***
host01 OK [vertica-ce][(5, 1, 1)][000][x86_64]
host02 OK [vertica-ce][(5, 1, 1)][000][x86_64]
Checking full connectivity
Creating database kakukk
Node Status: v_kakukk_node0001: (DOWN)
Node Status: v_kakukk_node0001: (INITIALIZING)
Node Status: v_kakukk_node0001: (INITIALIZING)
Node Status: v_kakukk_node0001: (VALIDATING LICENSE)
Could not connect to database
Node Status: v_kakukk_node0001: (DOWN)
Node Status: v_kakukk_node0001: (DOWN)
A half baked database gets created that is hard to get rid of because it does not show in the administration tool. Any suggestion appreciated. Thanks.
Database creation problem on CE
Moderator: NorbertKrupa
Re: Database creation problem on CE
Hi leosz!
What says vertica.log?
And may I ask you why 2 nodes? In such configuration second node will be just a replication of first with K-Safty = 1.
What says vertica.log?
And may I ask you why 2 nodes? In such configuration second node will be just a replication of first with K-Safty = 1.
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Database creation problem on CE
2 nodes works fine ... just make sure the tables are segmented (version 6.0 choses segmented by default BTW).
Re: Database creation problem on CE
Thank you.
Apparently it is a license issue: "V2001: License issue: No Vertica license is installed"
The same rpm works like a charm in a single node install. What am I doing wrong?
Apparently it is a license issue: "V2001: License issue: No Vertica license is installed"
The same rpm works like a charm in a single node install. What am I doing wrong?
Re: Database creation problem on CE
Hi leosz!
- What is your installation string (for /opt/vertica/sbin/install_vertica)?
- Can you provide next output:
Code: Select all
grep -A 5 Configuration /opt/vertica/config/admintools.conf
- Did you try manually install license to /opt/vertica/config/share?
Code: Select all
[ dbadmin ] :: [ /opt/vertica/config/share ] %> ls agent.cert agent.key agent.pem license.key portinfo.dat
Re: Database creation problem on CE
Thank you SKwa.
install string:
/opt/vertica/sbin/install_vertica -s host01,host02 -r vertica-ce-5.1.1-0.x86_64.SUSE.rpm
grep:
dbadmin@host01:/opt/vertica/config/share> grep -A 5 Configuration /opt/vertica/config/admintools.conf
[Configuration]
install_opts = ['-s', 'host01,host02', '-r', 'vertica-ce-5.1.1-0.x86_64.SUSE.rpm']
default_base = /home/dbadmin
show_hostnames = False
format = 3
I am not sure what manually installing license means but all these files are in the /opt/vertica/config/share folder
Thanks again.
install string:
/opt/vertica/sbin/install_vertica -s host01,host02 -r vertica-ce-5.1.1-0.x86_64.SUSE.rpm
grep:
dbadmin@host01:/opt/vertica/config/share> grep -A 5 Configuration /opt/vertica/config/admintools.conf
[Configuration]
install_opts = ['-s', 'host01,host02', '-r', 'vertica-ce-5.1.1-0.x86_64.SUSE.rpm']
default_base = /home/dbadmin
show_hostnames = False
format = 3
I am not sure what manually installing license means but all these files are in the /opt/vertica/config/share folder
Thanks again.