Tips & Tricks

Resolving adminTools Last Chance Error Handler

1

After successfully installing Vertica 7.2, and creating a database in Admintools, a cluster would not start. Attempting to go back into Admintools and perform any operation resulted in an “adminTools Last Chance Error Handler.”

The error message appeared as:

The contents of /opt/vertica/log/adminTools.errors are:

Looking at /opt/vertica/config/admintools.conf, the [Nodes] section does not correctly list node names:

The node names should math the nodes listed under [Database]. Updating this section in the file on each node corrects the error:

About the author / 

Norbert Krupa

Norbert is the founder of vertica.tips and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

1 Comment

  1. vcarusi July 20, 2016 at 4:43 AM -  Reply

    Hi,
    For me the problem disappeared after I added in /opt/vertica/config/admintools.conf the following lines:

    [Cluster]
    hosts = 127.0.0.1

    [Nodes]
    node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin
    v_maria_node0001 = 127.0.0.1,/vertica_db_maria/catalog,/vertica_db_maria/data

    I wanted to create a new db , single node.

Leave a Reply

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.

Notice

This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: