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