[HIVE-16399] create an index for tc_txnid in TXN_COMPONENTS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 2.3.0, 3.0.0, 2.4.0
• Component/s: Transactions
• Target Version/s: 2.3.0, 3.0.0, 2.4.0
• Assignee: Wei Zheng
• Reporter: Eugene Koifman
• Created: 06/Apr/17 15:51
• Updated: 22/May/18 23:58
• Resolved: 02/May/17 02:26

Description

w/o this TxnStore.cleanEmptyAbortedTxns() can be very slow

Issue Links

• is related to: HIVE-16933 ORA-00060: deadlock detected while waiting on commit