Comments

• skeswani - Select Field - Employee

  October 2017

  whats the sql? look like export to s3

  0
• kannan01

  October 2017

  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/

  0
• kannan01

  October 2017

  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

  0
• skeswani - Select Field - Employee

  October 2017

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

  0
• kannan01

  October 2017

  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:'}

  0
• kannan01

  October 2017

  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

  0
• kannan01

  October 2017

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

  0
• skeswani - Select Field - Employee

  November 2017

  ok, thanks, i am glad it worked.

  0