[DERBY-6817] Cannot stop Query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.11.1.1
• Component/s: JDBC, Network Server
• Urgency: Normal
• Assignee: Unassigned
• Reporter: sagar
• Created: 10/Jun/15 06:41
• Updated: 09/Sep/16 09:54
• Resolved: 10/Jun/15 14:14

Description

We cannot stop a SQL query from being executed or cancel it.

If we realize the SQL Query is wrong, and gone recursive or undeterminate with very high continuous CPU usage, the Query cannot be stopped.

Even if we shut down the Network server the server does not shutdown and the java process has to be killed ...

There must be a mechanism to do so.

Issue Links

• duplicates: DERBY-3908 Add a mechanism for cancelling runaway transactions.