Skip to main content

Sessions are not aborting after Select close_session command as well.

  • May 14, 2019 7:38 AM UTC
  • 4 replies
  • 16 views
hdk0310
Forum|alt.badge.img+1

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

Select close_session('session_id');
Select close_all_sessions();
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

    4 replies

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • May 18, 2019 12:29 PM UTC

    Did you try the INTERRUPT_STATEMENT function?

    See:
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/INTERRUPT_STATEMENT.htm

    hdk0310
    Forum|alt.badge.img+1
    • hdk0310
    • Author
    • Participating Frequently
    • May 20, 2019 11:33 AM UTC

    Yeah I've tried this as well. But unfortunately this is also not closing the sessions.

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • May 20, 2019 12:53 PM UTC

    What client tool (i.e. program) is creating these sessions that cannot be closed? Are they using ODBC or JDBC? Are these ssesion that cannot be closed currently running a SQL statement?

    hdk0310
    Forum|alt.badge.img+1
    • hdk0310
    • Author
    • Participating Frequently
    • May 21, 2019 11:21 AM UTC

    Yes these are JDBC sessions running through DbVisualizer. It was a copy statement trying to pick file from S3 bucket and load into Vertica. The sql is wrong as it gets hang after querying and I had to terminate the sessions but it is not closing permanently and staying in locks and query_requests.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement