How to Force Kill Session in Vertica 9.0

josefp

Hi,
I have a session performing SELECT S3Export(), but when I performed CLOSE_SESSION() and INTERRUPT_SESSION() command the session is still persistent.

I checked the PID of the session from the OS side using the information from the V_MONITOR.SESSIONS client_pid column, but I cannot find the OS PID running on the node.

How to force kill the session?

Bryan_H

There was a recent blog post about this, I think this answer was posted in another question:
https://forum.vertica.com/discussion/240886/stop-a-stubborn-query-that-won-t-cancel

josefp

Thank you Bryan, I'll check this option. Cheers.

hannah_shachar

This hasn't worked for me in the two times that I have had stuck queries.

SruthiA

There are scenarios where it doesn't work, if so please open a support case while query is hung so that we can collect debugging info and restart the node.