We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica not restarting smoothly — Vertica Forum

Vertica not restarting smoothly

Vertica Customer
edited March 2022 in General Discussion

Every time i restart the Vertica, It gives error image1 even when no user is connected. It always restarts when we kill the vertica process forcefully on all the nodes e.g: option Stop Vertica on Host.
Since this is new installation Vertica10, could you please help what am i doing wrong ?
We have the old environment with vertica 8, but that is running fine and we can restart old production smoothly.

Best Answer

  • Vertica Employee Administrator
    Answer ✓

    Are you sure no users are connected, including MC and admintools itself? Check by running SELECT * FROM SESSIONS;
    If you are certain there are no active users or queries, stop with SQL query
    SELECT SHUTDOWN(true);

    or command line

    admintools -t stop_db -d -p -i -F

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.