Vertica cluster DB creation failed - SSH as dbadmin (custom created)

Categories: SteelCentral Aternity
Solution Number: S33736

Issue

Vertica cluster installation completed but DB creation failed with the following errors:

From Installer.log
INFO: Creating database
Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
Distributing changes to cluster.
Error: Not all nodes could be reached during database creation
Could not reach nodes: ['10.210.82.100']
ERROR: Database creation failed
ERROR: Installation failed. Please contact Aternity support.



From admintools.log:
admintools/492461:0x7f93225d8700 [SSHConnection._login_if_needed] <ERROR> <PexpectAdapter: dbadminCustom@w.x.y.z>: login error: UNEXPECTED EOF: Could not login with ssh. ssh output: 'Permission denied (publickey,keyboard-interactive).\r\r\n'
admintools/492461:0x7f93225d8700 [AdapterConnectionPool_3._connect] <ERROR> Unable to SSH as dbadminCustom to w.x.y.z: UNEXPECTED EOF: Could not login with ssh. ssh output: 'Permission denied (publickey,keyboard-interactive).\r\r\n'
admintools/492461:0x7f932cae4740 [AdapterConnectionPool_3.connect2_using_stored_auth] <WARNING> Unable to SSH as dbadminCustom to w.x.y.z: UNEXPECTED EOF: Could not login with ssh. ssh output: 'Permission denied (publickey,keyboard-interactive).\r\r\n'


Note: dbadminCustom user was created prior to the installation of Vertica and used in vertica_parameters.sh file as VERTICA_DB_ADMIN_USER
 

Solution

Check ssh communication using dbadminCustom user between the nodes. The communication should be sucessful and "password-less", meaning you should not be prompted for password for dbadminCustom when connecting to other node.
In case the ssh to another node required passowrd, please follow Vertica KB to set up password-less ssh access betwenn the nodes in Vertica cluster.

 

Environment

Vertica cluster
Aternity Platform 10.x
Aternity Platform 11.x
NOTICE: Riverbed® product names have changed. Please refer to the Product List for a complete list of product names.
Last Modified: 2019-10-17
Can't find an answer? Create a case