Creating a new database fails

[roediger]

Hello,

when I try to create a database on clean 3-node Vertica CE 6.0.1 Ubuntu 12.04 cluster I get the following error:

Code: Select all

*** Creating database: clusterdb ***
host1 OK [vertica-ce][(6, 0, 1)][000][all]
host2 OK [vertica-ce][(6, 0, 1)][000][all]
host3 OK [vertica-ce][(6, 0, 1)][000][all]
Checking full connectivity
Creating database clusterdb
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
Node Status: v_clusterdb_node0001: (DOWN)
ERROR: Database did not start cleanly on initiator node!
Stopping all nodes
Press RETURN to continue

The log file seems not to contain any specific error message (I've attached it nevertheless) and strangely, there are no Google results for the error message “Database did not start cleanly on initiator node!”.

I would appreciate any help to resolve this issue.

Thanks, Wolf

[roediger]

I resolved it. Due to a bug in libpam, nofile was not set. See http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=597225.

[JimKnicely]

Hi roediger!

Gosh, you resolved your own issue in less than two hours That's great, and thanks for letting everyone know the resolution!

I'm sure another Vertica user will benefit from you experience.

[trovador]

Hello roediger,
I'm also trying to get Vertica 6.0.1 CE running on Ubuntu 12.04 Server LTS. And I ran into the same problem.
How did you exaclty solve this issue?

I tried setting * hard nofile 4096 and soft limits and rebooted, but I get the same message..

Any ideas you could share?

[JimKnicely]

Hi trovador,

I wonder if the original poster's issue had something to do with the errors he received? The following errors were reported toward the end of his attachment:

• Not enough open file handles allowed (1024 available/32768 required)

Maybe this is also your problem?

In the installation docs, Vertica recommends the value to be 65536 for the Enterprise Edition for the supported Linux platforms, Ubuntu not being one of them

Here's a link to show you how to increase the setting in Ubuntu.

http://myadventuresincoding.wordpress.c ... pen-files/

Looks like you tried this already, but maybe you didn't increase the setting enough

P.S. Make sure to reboot after making the change.

[trovador]

In the end I just installed Debian instead of Ubuntu, and it worked fine.