Sessions are not aborting after Select close_session command as well.
I have few entries in Vertica locks table. I wanted to close those sessions. For which I tried select close_session() command . The command ran successfully giving below result. But the sessions are still there.
Session close command sent. Check v_monitor.sessions for progress.
Tried below commands nothing helped though:
Version: Vertica Analytic Database v9.2.0-2
ALTER DATABASE mydb SET MaxClientSessions = 1;
Any other way how can I close these sessions other than db restart? Is this a bug in vertica 9.2 version.
Thanks in Advance