[
https://issues.apache.org/jira/browse/HIVE-27191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Simhadri Govindappa reassigned HIVE-27191:
------------------------------------------
> Cleaner is blocked by orphaned entries in MHL table
> ---------------------------------------------------
>
> Key: HIVE-27191
> URL: https://issues.apache.org/jira/browse/HIVE-27191
> Project: Hive
> Issue Type: Improvement
> Reporter: Simhadri Govindappa
> Assignee: Simhadri Govindappa
> Priority: Major
>
> The following mhl_txnids do not exist in TXNS table, as a result, the
> cleaner gets blocked and many entries are stuck in the ready-for-cleaning
> state.
> The cleaner should periodically check for such entries and remove them from
> MHL_TABLE to prevent the cleaner from being blocked.
> {noformat}
> postgres=# select mhl_txnid from min_history_level where not exists (select 1
> from txns where txn_id = mhl_txnid);
> mhl_txnid
> -----------
> 43708080
> 43708088
> 43679962
> 43680464
> 43680352
> 43680392
> 43680424
> 43680436
> 43680471
> 43680475
> 43680483
> 43622677
> 43708083
> 43708084
> 43678157
> 43680482
> 43680484
> 43622745
> 43622750
> 43706829
> 43707261
> (21 rows){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
