Simhadri Govindappa created HIVE-27191:
------------------------------------------
Summary: 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
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)
