No Option Error - Can't do ANYTHING with admintools - Please Help (No Option Error)

dcruise23dcruise23 Registered User

I tried to change the IP addresses on each node in the cluster and after trying to create a new database - my whole vertica instance has gone bad. I literally cannot perform any task using AdminTools or command line.

 

After click ANY option in admin tools i get the following error:

 

adminTools Last Chance Error Handler running...

raised error: <class 'ConfigParser.NoOptionError'>

error message: no option ;v_atest_node0001' in section: 'Nodes'

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

REPORT THIS INFORMATION TO TECHNICAL SUPPORT
AND INCLUDE CONTENTS OF THE TRACE FILE IN YOUR REPORT

 

 

Trace File Contents:

handler invoked: 2015-05-16 15:18:17
raised error: <class 'ConfigParser.NoOptionError'>
Traceback (most recent call last):
File "/opt/vertica/bin/admintools", line 391, in <module>
ac.runApp()
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/adminCtrl.py", line 3374, in runApp
self.__ui.runFromNavigation("main")
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/uiMgr.py", line 165, in a_wrapper_accepting_args
fn(self, *args, **kwargs)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/uiMgr.py", line 450, in runFromNavigation
self.__navigator.navigate(uimanager=self, startingPoint=runFrom)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/Navigator.py", line 315, in navigate
((self.__menus[ nextMenu ][ self.NAV_MACTIONS ])[ offset ])()
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/adminCtrl.py", line 232, in restartDBFromEpoch
dbDict = self.__exec.getDBInfo()
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/adminExec.py", line 1709, in getDBInfo
config_info = c.getconfig(db)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/Configurator.py", line 283, in getconfig
props[option +"_new"].append( self.getsiteconfig( n ))
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/Configurator.py", line 353, in getsiteconfig
p = self.configdict.get("Nodes",nodename).split(',')
File "/opt/vertica/oss/python/lib/python2.7/ConfigParser.py", line 566, in get
raise NoOptionError(option, section)
NoOptionError: No option 'v_atest_node0001' in section: 'Nodes'

 

 

I cannot run a vbr.py backup (did previously but cant now) or anything related to vertica. Unfortunately it seems on the python side and the v_atest_node0001 is the database i tried to create but didnt create successfully.

 

Any ideas?


Thank you - much appreciated

 

 

Comments

  • SruthiASruthiA Employee, Registered User, VerticaExpert

    Hi,

     

    Seems like your admintools.conf file may be missing some things. Please share the content of /opt/vertica/config/admintools.conf and also the number of nodes in your cluster. 

    cat /opt/vertica/config/admintools.conf

     

     

    -Regards,

     Sruthi

  • DhruvaDhruva Registered User

    Hi Sruthi,

     

     

    I have the same issue, while trying to create a database, My cluster size is 3 nodes and

     

     

    [Configuration]

    last_port = 5433

    tmp_dir = /tmp

    default_base = /home/dbadmin

    format = 3

    install_opts = --hosts 'node1,node2,node3' --rpm '/tmp/vertica-7.1.2-0.x86_64.RHEL5.rpm' -u dbadmin

    spreadlog = False

    controlsubnet = default

    controlmode = broadcast

     

    [Cluster]

    hosts = 172.31.15.64,172.31.15.65,172.31.15.66

     

    [Nodes]

    node0001 = 172.31.15.64,/home/dbadmin,/home/dbadmin

    node0002 = 172.31.15.65,/home/dbadmin,/home/dbadmin

    node0003 = 172.31.15.66,/home/dbadmin,/home/dbadmin

     

    [Database:test]

    restartpolicy = ksafe

    port = 5433

    path = /home/dbadmin/test/v_test_node0001_catalog

    nodes = v_test_node0001,v_test_node0002,v_test_node0003

     

  • dcruise23dcruise23 Registered User

    Hi Dhruva,

     

    Make sure that your node names are set appropriately. You named your nodes 'node000x' but then referenced to them as 'v_test_node000x'. See the edit below where you can reference to your correct node names. Let me know if this helped!

     

    Yours:

     

    [Nodes]

    node0001 = 172.31.15.64,/home/dbadmin,/home/dbadmin

    node0002 = 172.31.15.65,/home/dbadmin,/home/dbadmin

    node0003 = 172.31.15.66,/home/dbadmin,/home/dbadmin

     

    [Database:test]

    restartpolicy = ksafe

    port = 5433

    path = /home/dbadmin/test/v_test_node0001_catalog

    nodes = v_test_node0001,v_test_node0002,v_test_node0003

     

     

    Edit:

     

     

    [Nodes]

    node0001 = 172.31.15.64,/home/dbadmin,/home/dbadmin

    node0002 = 172.31.15.65,/home/dbadmin,/home/dbadmin

    node0003 = 172.31.15.66,/home/dbadmin,/home/dbadmin

     

    [Database:test]

    restartpolicy = ksafe

    port = 5433

    path = /home/dbadmin/test/v_test_node0001_catalog

    nodes = node0001, node0002, node0003

  • claudiuoclaudiuo Registered User

    I am having the same problem: after creating the database adminTools errors exactly the same as for the OP and the conf file shows different node names in the Database section:

     

    [Nodes]
    node0001 = <ip1>,/home/mydba,/home/mydba
    node0002 = <ip2>,/home/mydba,/home/mydba
    node0003 = <ip3>,/home/mydba,/home/mydba

     

    [Database:cea]
    restartpolicy = ksafe
    port = 5433
    path = /home/mydba/cea
    nodes = v_cea_node0001,v_cea_node0002,v_cea_node0003

     

    What I wanted to mention though is that I didn't change the admintools.conf file manually, this is what I got after creating the database using the adminTools. I will try to modify the conf file manually but just wanted to say that this is something happening without manual changes so there must be some other cause somewhere.

Leave a Comment

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