[HIVE-11916] TxnHandler.getOpenTxnsInfo() and getOpenTxns() may produce inconsistent result

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1
• Fix Version/s: 1.3.0
• Component/s: Transactions
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 22/Sep/15 02:10
• Updated: 01/Oct/15 00:45
• Resolved: 01/Oct/15 00:45

Description

both run at READ_COMMITTED isolation level and each runs 2 queries.
Thus it's possible for a new txn to start/commit after hight water mark is recored by these methods. So the returned list may have txns above the HWM.

This can be fixed by adding "WHERE TXN_ID < hwm" clause to 2nd query in each case

Issue Links

• is blocked by: HIVE-11934 Transaction lock retry logic results in infinite loop