How to kill a session other than using close_session()

Zhiyi_Zhou

I need to kill a hanging session, and I have tried using close_session(session_id) statement multiple times, but it won't kill this particular session. Is there any other way to kill it? Thanks!

colin_loghin

you should first call select interrupt_statement('session',statement_id); and then call close_session(...) . This will permit the session manager to properly cleanup the running session. 

In certain cases , you may have to retry multiple times. If this does not , the last resort is to kill the node using admintools , the node that initiated the session ( based on the session_id) ..  This last resort would always work , but require the node to recover upon restart. 

Daniel_Leybovic

Hi!

>> In certain cases , you may have to retry multiple times, . If this does not , the last resort is to kill the node using admintools
Colin right, sometimes its stacked and only a "kill" helps, but sometimes it takes a lot of time for "rollback" (for example - "heavy" UPDATE can take a lot of time for ROLLBACK), so monitor a vertica log file too (if its critical do not "kill").