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 a database using adminTools

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

Comments

  • 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]$ 




  • 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.

  • Thanks for the report - we have improved this error message.

Leave a Comment

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