Skip to main content

Unable to create a database using adminTools

  • February 14, 2014
  • 3 replies
  • 26 views

Bill_DeStein
Forum|alt.badge.img
I'm unable to create a database using adminTools adminTools displays this: http://grab.by/ulb6 The adminTools error log looks like this: http://grab.by/ulb8 It looks like Raghav had a similar problem two weeks ago: https://community.vertica.com/vertica/topics/unable_to_create_database

3 replies

Bill_DeStein
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • February 15, 2014
So today I provisioned a brand new server on EC2 and installed Vertica 7.0.0.0-1 according to the instructions.  Then I followed the steps in the "Tutorial: Setting up an Example Database" in the GettingStartedGuide.pdf.  All went smoothly until I tried to create the database using adminTools.  I got this response below.  I'm surprised that I appear to be the only one having this problem.

I'll appreciate any suggestions.

Thanks,

Bill

-------------------------------------------------------

*** Creating database: vmartdb ***

127.0.0.1 OK [vertica][(7, 0, 0)][001][x86_64]

Creating database vmartdb

Starting bootstrap node v_vmartdb_node0001 (127.0.0.1)




adminTools Last Chance Error Handler running...

raised error:  <type 'exceptions.ValueError'>

error message: No JSON object could be decoded

trace file:  /opt/vertica/log/adminTools-dbadmin.errors

REPORT THIS INFORMATION TO TECHNICAL SUPPORT

AND INCLUDE CONTENTS OF THE TRACE FILE IN YOUR REPORT

[dbadmin@ip-172-31-21-166 log]$ 





Bill_DeStein
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • February 15, 2014
Okay, so I added some print statements to SSH.py and found the problem was that adminTools couldn't talk to verticad because verticad wasn't running (there could probably be a better error message for this).   So this issue is resolved.


Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • February 15, 2014
Thanks for the report - we have improved this error message.