Database creation problem on CE

[leosz]

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.

[id10t]

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.

[jpcavanaugh]

2 nodes works fine ... just make sure the tables are segmented (version 6.0 choses segmented by default BTW).

[leosz]

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?

[id10t]

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
  

[leosz]

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.