The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Unable to create database - Vertica 10.1 with RHEL8

smugsmug Community Edition User

Hi, I've already searched the forum and tried the said 'solutions' but my problem still persists and I'm unable to create a database.
I'm using Vertica 10.1 with RHEL8 as a virtual machine and trying to setup a single node. I've added my local IP to /etc/hosts with the proper hostname, installation works fine using the install_script with --hosts flag but as soon as I create a database using adminTools, I get the 'load the startup information from the bootstrap node.' error. I've tried changing the limits of the open file but the changes don't get reflected still shows 1024 with ulimit -n. Below is the adminTools log file.

2021-02-24 12:03:51.169 admintools/10243:0x7f1159bfb700 [at_command.to_subprocess_invocation] <INFO> Command: [/opt/vertica/oss/python3/bin/python3 -m vertica.engine.api.at_runner --no-prompt --module vertica.engine.api.move_staged_files]; input: [#{"staged_file": "/tmp/vstage-073590e5-1ef9-4766-ae2c-94dc609676a4/file", "dest_path": "/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat", "remove_parent_dirs": true, "untar_file": false, "__rollback__": false, "__protocol__": "1.0"}]
2021-02-24 12:03:51.260 at_exec/10516:0x7f4f363b8740 [root.setup_custom_logging] <INFO> New log for 'at_exec'
2021-02-24 12:03:51.260 at_exec/10516:0x7f4f363b8740 [root.setup_custom_logging] <INFO> sys.argv: '/opt/vertica/oss/python3/lib/python3.7/site-packages/vertica/engine/api/' --no-prompt --module 'vertica.engine.api.move_staged_files'
2021-02-24 12:03:51.262 at_exec/10516:0x7f4f363b8740 [ATRunner.exec_module] <INFO> running: <ATCommand> module=vertica.engine.api.move_staged_files version=1.0 args={"staged_file": "/tmp/vstage-073590e5-1ef9-4766-ae2c-94dc609676a4/file", "dest_path": "/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat", "remove_parent_dirs": true, "untar_file": false}
2021-02-24 12:03:51.263 at_exec/10516:0x7f4f363b8740 [ATRunner.exec_module] <INFO> result: <ATResult> status=Completed host=None content={"staging_dir_removed": true, "runner_ack": true} error_message=None
2021-02-24 12:03:51.278 admintools/10243:0x7f115ef9e740 [adminCtrl.infoBox] <INFO> infobox(Failed to load the startup information from the bootstrap node.
Hint: Are your resource limits for new processes correct?


  • SruthiASruthiA Vertica Employee Employee

    did you install libnsl package on your VM? Can you share me the contents of the limits.conf?

    cat /etc/security/limits.conf

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file