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

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.
Tagged:
0
Best Answer
-
Bryan_H Vertica Employee Administrator
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
1
Answers
Thank you for response. I found that MC session was running. I stopped the MC session and then restarted the DB. and It was smooth as required.
Now i need to figure out to kill the idle sessions.
It's possible to close all sessions except the current one with SELECT CLOSE_ALL_SESSIONS();
If necessary, also set MaxClientSessions to 0 to prevent new connections
More info: https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/SHUTDOWN.htm
setting MaxClientSessions to 0 will be a permanent change, until we roll back to previous setting after restart.
Thank You. I will look into that.