hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karen Coppage (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-23280) Trigger compaction with old aborted txns
Date Fri, 24 Apr 2020 06:50:00 GMT

     [ 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
        Status: Patch Available  (was: Open)

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

Mime
View raw message