The SQL execution completes but does not return, causing the client to remain blocked indefinitely.

TKilome

​Environment:​​ Vertica 11, using JDBC.
​​Issue:​​ When executing a long-running SQL query (~2 hours) via JDBC, the .execute() method remains blocked even after the query completes successfully. The connection eventually times out due to server-side idle timeout, leading to an exception.
​​Check Done:​​ Verified in query_requests that the query status is marked as completed.

​​Ask:​​
Hi everyone,
In Vertica 11, when running a slow SQL query (takes ~2 hours) via JDBC, the .execute() method keeps blocking indefinitely even after the query finishes successfully. The connection is only released after an idle timeout triggers a server-side disconnect, resulting in an exception.
I confirmed in query_requests that the query status is COMPLETED.
Has anyone encountered this? How can I resolve the blocking issue post-query completion?

Thanks in advance for any suggestions!