[HIVE-22905] Transaction is not aborted when query cancelled, only when session is closed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Transactions
• Target Version/s: 4.0.0
• Assignee: Aron Hamvas
• Reporter: Aron Hamvas
• Created: 18/Feb/20 16:23
• Updated: 17/Nov/22 08:49
• Resolved: 21/Feb/20 09:42

Description

Reproduction:

1. Start HMS
2. Start HS2
3. Start beeline
4. Execute a query and cancel query after transaction is started and before locks are acquired (yeah, that will take a debugger with breakpoints in DbLockManager)
5. Do not terminate Hive session

DbLockManager will keep spinning in the checkLock loop as long as the Hive session is not closed since abortTxns is not invoked on HMS, and until the lock is acquired (even though the query could have been canceled long time ago).

Driver only checks in close() method if there are locks acquired but it does not check if a txn is open.

Issue Links

• causes: HIVE-24550 Cleanup only transaction information for the current DriverContext