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!
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.
0
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.