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!

Vertica not restarting smoothly

veerkumarveerkumar 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

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

    or command line

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


Leave a Comment

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