Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Getting error while creating EON db using the admintools CLI

Hi,

While running the admintools CLI to create Db in EON mode, i am getting the following logs :

2017-10-31 15:40:37.716 Spread Client:7f7409df3700 [SAL] [S3UDFS] [RETRY] [Attempt 14/50] [Canceled? N] [Should retry? Y] [Operation virtual void SAL::S3FileSystem::mkdirs(const char*, mode_t) const] (99) : 'Unable to connect to endpoint'

Could you please advise.

Comments

  • whats the sql? look like export to s3

  • Hi Sumeet,

    I am using the below command to create the DB

    /opt/vertica/bin/admintools -t create_db --database EON_TEST --hosts 10.131.75.111,10.131.75.81,10.131.75.32 --depot-path /vertica/data/EON_TEST_depot --shard-count 3 --communal-storage-location s3://eon-test-db/

  • This is the error i receive at the end.

    ERROR: Database did not start cleanly on initiator node!
    Stopping all nodes
    Could not connect to database (EOF received)vsql: could not connect to server: Connection refused
    Is the server running on host "10.131.75.111" and accepting
    TCP/IP connections on port 5433?

    Error: Database did not start cleanly on initiator node! Stopping all nodes

  • which region is this bucket in. s3://eon-test-db/. can you try with a bucket in us-east-1

  • Tried us-east-1. But getting same error.

    This is a snippet from the admntools.log

    2017-10-31 21:39:35.835 admintools/152947:0x7f6f6122a740 [Configurator.acquire] Seek thread lock
    2017-10-31 21:39:35.835 admintools/152947:0x7f6f6122a740 [Configurator.acquire] Acquire thread lock
    2017-10-31 21:39:35.835 admintools/152947:0x7f6f6122a740 [Configurator.Instance] Seeking FileLock on /opt/vertica/config/admintools.conf
    2017-10-31 21:39:35.835 admintools/152947:0x7f6f6122a740 [Configurator.Instance] Have FileLock on /opt/vertica/config/admintools.conf
    2017-10-31 21:39:35.836 admintools/152947:0x7f6f6122a740 [Configurator.release] Release thread lock
    2017-10-31 21:39:35.836 admintools/152947:0x7f6f6122a740 [Configurator.Instance] Release FileLock on /opt/vertica/config/admintools.conf
    2017-10-31 21:39:35.836 admintools/152947:0x7f6f6122a740 [nssh_check_for_running.event] EVENT: type=Status job None {"type":"NODEHOST", "state":"DOWN", "host":"10.131.75.111", "node":"v_eon_test_node0016", "dbname":"EON_TEST", "msg":"", "maxSteps":"1", "currStep":"1"}
    2017-10-31 21:39:35.836 admintools/152947:0x7f6f6122a740 [nssh_check_for_running.cfr_get_nodestate] nodeStatusString: Node Status: v_eon_test_node0016: (DOWN)
    2017-10-31 21:39:39.840 admintools/152947:0x7f6f6122a740 [nssh.collectProcessResult] Running ['/opt/vertica/bin/vsql', '--no-vsqlrc', '-n', '-p', '5433', '-h', '10.131.75.111', 'EON_TEST'] with env {'LESSOPEN': '||/usr/bin/lesspipe.sh %s', 'VSQL_OPTIONS': 'clusterstatus', 'SSH_CLIENT': '10.131.77.215 54472 22', 'SELINUX_USE_CURRENT_RANGE': '', 'LOGNAME': 'dbadmin', 'USER': 'dbadmin', 'PATH': '/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/vertica/bin:/home/dbadmin/.local/bin:/home/dbadmin/bin', 'HOME': '/home/dbadmin', 'LD_LIBRARY_PATH': '/opt/vertica/lib', 'LANG': 'en_US.UTF-8', 'TERM': 'xterm', 'SHELL': '/bin/bash', 'SHLVL': '1', 'HISTSIZE': '1000', 'XDG_RUNTIME_DIR': '/run/user/1001', 'SELINUX_ROLE_REQUESTED': '', 'XDG_SESSION_ID': '2037', '
    ': '/opt/vertica/bin/admintools', 'SSH_CONNECTION': '10.131.77.215 54472 10.131.75.111 22', 'SSH_TTY': '/dev/pts/1', 'HOSTNAME': 'ip-10-131-75-111.vpc.internal', 'SELINUX_LEVEL_REQUESTED': '', 'HISTCONTROL': 'ignoredups', 'PWD': '/home/dbadmin', 'MAIL': '/var/spool/mail/dbadmin', 'LS_COLORS': 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arc=01;31:.arj=01;31:.taz=01;31:.lha=01;31:.lz4=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.tzo=01;31:.t7z=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lrz=01;31:.lz=01;31:.lzo=01;31:.xz=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.alz=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.cab=01;31:.jpg=01;35:.jpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.axv=01;35:.anx=01;35:.ogv=01;35:.ogx=01;35:.aac=01;36:.au=01;36:.flac=01;36:.mid=01;36:.midi=01;36:.mka=01;36:.mp3=01;36:.mpc=01;36:.ogg=01;36:.ra=01;36:.wav=01;36:.axa=01;36:.oga=01;36:.spx=01;36:*.xspf=01;36:'}

  • Hi Sumeet, i was able to create the vertica cluster using MC.

    But when trying to insert data to a test table getting the following error.

    Something went wrong while copying the files to persistent location. Please look at the vertica.log for more details

  • i was able to by pass that with setting the aws location parameter. please disregard the above error

  • ok, thanks, i am glad it worked.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.