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!

How to kill a session other than using close_session()

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!

Comments

  • 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. 
  • 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").

Leave a Comment

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