[DRILL-1378] Using CTRL-C to cancel a query and exit SQLLINE cancels query but causes SQLLINE shell to hang

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.9.0
• Component/s: Client - CLI
• Labels: cancel ctrl-c hang query sqlline

Environment

MapR v3.1.1, RHEL 6.5

• Assignee: Parth Chandra
• Reporter: Michael England
• Created: 05/Sep/14 13:22
• Updated: 26/Feb/15 18:38
• Resolved: 26/Feb/15 18:38

Description

When running a query (in this case a Drill query over a large Hive table), pressing CTRL+C to cancel a query and exit the shell causes a cancellation message in sqlline.log but causes the SQLLINE shell to hang. CTRL-Z then needs to be pressed and the SQLLINE process needs to be killed manually. A CTRL+C keyboard interrupt should cancel the query and provide a new empty query line in the shell. A further CTRL-C keyboard press should exit the SQLLINE shell.

sqlline.log cancellation entry:

2014-09-05 14:16:13,852 [SIGINT handler] DEBUG o.a.drill.exec.client.DrillClient - Cancelling query b0b36fa7-051e-484e-bb42-f57613401834
2014-09-05 14:16:13,858 [Client-1] DEBUG org.apache.drill.jdbc.DrillResultSet - Result arrived QueryResultBatch [header=query_state: CANCELED
query_id {
part1: -5714100739066935218
part2: -4953126752676210636
}
is_last_chunk: true
, data=null]

Issue Links

• depends upon: DRILL-2245 Improve Drillbit resiliency