[
https://issues.apache.org/jira/browse/HIVE-23280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karen Coppage updated HIVE-23280:
---------------------------------
Status: Open (was: Patch Available)
> Trigger compaction with old aborted txns
> ----------------------------------------
>
> Key: HIVE-23280
> URL: https://issues.apache.org/jira/browse/HIVE-23280
> Project: Hive
> Issue Type: Improvement
> Reporter: Karen Coppage
> Assignee: Karen Coppage
> Priority: Major
> Attachments: HIVE-23280.01.patch, HIVE-23280.01.patch,
> HIVE-23280.01.patch, HIVE-23280.01.patch, HIVE-23280.02.patch,
> HIVE-23280.03.patch, HIVE-23280.04.patch, HIVE-23280.04.patch
>
>
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
