[
https://issues.apache.org/jira/browse/HIVE-23280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peter Vary updated HIVE-23280:
------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Status: Resolved (was: Patch Available)
Pushed to master.
Please document the new configuration.
Thanks for the patch [~klcopp]!
> 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
> Fix For: 4.0.0
>
> 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,
> HIVE-23280.05.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)
