We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How to kill a session other than using close_session() — Vertica Forum

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