You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Simhadri Govindappa (Jira)" <ji...@apache.org> on 2023/03/29 10:11:00 UTC
[jira] [Assigned] (HIVE-27191) Cleaner is blocked by orphaned entries in MHL table
[ 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)