Grant Krieger created HAWQ-1530: ----------------------------------- Summary: 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: Radar Lei
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 (v6.4.14#64029)