Vertica Database won't start

book

Article ID: 102344

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration CA Performance Management - Data Polling

Issue/Introduction

Found the following errors in the dbLog (/catalog/drdata/dbLog) when trying to start Vertica database. 

ERROR: Host does not meet minimum requirements: Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.
ERROR: Host does not meet minimum requirements: Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.
ERROR: Host does not meet minimum requirements: Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.
 

Environment

Release:
Component: IMSTOR

Resolution

Edit the file /etc/ssh/sshd_config and make sure UsePAM is set to yes example below: 

# Set this to 'yes' to enable PAM authentication, account processing,
# and session processing. If this is enabled, PAM authentication will
# be allowed through the ChallengeResponseAuthentication and
# PasswordAuthentication.  Depending on your PAM configuration,
# PAM authentication via ChallengeResponseAuthentication may bypass
# the setting of "PermitRootLogin without-password".
# If you just want the PAM account and session checks to run without
# PAM authentication, then enable this but set PasswordAuthentication
# and ChallengeResponseAuthentication to 'no'.
#UsePAM no
UsePAM yes


Do this on all nodes 

The restart sshd 
service sshd restart

Start the database using admintools.