Vertica not restarting smoothly

veerkumar

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.

Bryan_H

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

veerkumar

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.

Bryan_H

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

veerkumar

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.