Radar Lei reopened HAWQ-1530:

Reopen this issue sinceĀ [~outofmemory] can reproduce it.

> Illegally killing a JDBC select query causes locking problems
> -------------------------------------------------------------
>                 Key: HAWQ-1530
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1530
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Transaction
>            Reporter: Grant Krieger
>            Assignee: Yi Jin
>            Priority: Major
>             Fix For:
> Hi,
> When you perform a long running select statement on 2 hawq tables (join) from 
> JDBC and illegally kill the JDBC client (CTRL ALT DEL) before completion of 
> the query the 2 tables remained locked even when the query completes on the 
> server. 
> The lock is visible via PG_locks. One cannot kill the query via SELECT 
> pg_terminate_backend(393937). The only way to get rid of it is to kill -9 
> from linux or restart hawq but this can kill other things as well.
> The JDBC client I am using is Aqua Data Studio.
> I can provide exact steps to reproduce if required
> Thank you
> Grant 

This message was sent by Atlassian JIRA

Reply via email to