[HIVE-23280] Trigger compaction with old aborted txns - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.0.0-alpha-1
Component/s: None
Labels:
None

Target Version/s:

4.0.0

Description

When a txn is aborted and the compaction threshold for number of aborted txns is not reached then the aborted transaction can remain forever in the RDBMS database. This could result in several serious performance degradations:

getOpenTxns has to list this aborted txn forever
TXN_TO_WRITE_ID table is not cleaned

We should add a threshold, so after a given time the compaction is started anyway.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

HIVE-23280.01.patch
27/Apr/20 05:35
34 kB
Karen Coppage
HIVE-23280.01.patch
24/Apr/20 06:49
34 kB
Karen Coppage
HIVE-23280.01.patch
23/Apr/20 07:59
34 kB
Karen Coppage
HIVE-23280.01.patch
23/Apr/20 07:54
34 kB
Karen Coppage
HIVE-23280.02.patch
27/Apr/20 12:50
34 kB
Karen Coppage
HIVE-23280.03.patch
28/Apr/20 08:35
35 kB
Karen Coppage
HIVE-23280.04.patch
04/May/20 12:57
36 kB
Karen Coppage
HIVE-23280.04.patch
28/Apr/20 10:36
36 kB
Karen Coppage
HIVE-23280.05.patch
05/May/20 08:38
35 kB
Karen Coppage

Issue Links

links to

review board

Activity

People

Assignee:: Karen Coppage

Reporter:: Karen Coppage

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 23/Apr/20 07:11

Updated:: 17/Nov/22 08:50

Resolved:: 05/May/20 14:45