You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Karen Coppage (Jira)" <ji...@apache.org> on 2020/04/23 07:55:00 UTC

[jira] [Updated] (HIVE-23280) Trigger compaction with old aborted txns

     [ https://issues.apache.org/jira/browse/HIVE-23280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karen Coppage updated HIVE-23280:
---------------------------------
    Attachment: HIVE-23280.01.patch

> 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
>
>
> 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)