Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica not restarting smoothly

veerkumarveerkumar
edited March 14 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

  • Bryan_HBryan_H 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.