[ https://issues.apache.org/jira/browse/HIVE-28563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dayakar M updated HIVE-28563: ----------------------------- Description: This is a followup Jira for HIVE-28416 MaterializationsRebuildLockCleanerTask never cleans the abandoned MV Rebuild Lock entries from MATERIALIZATION_REBUILD_LOCKS table. As a part MaterializationsRebuildLockCleanerTask, before clearing the entries it checks whether the last heartbeat time for this lock entry is lesser than the (current time - hive transaction timeout) but the MaterializationRebuildLockHeartbeater heartbeats every (hive transaction timeout/2) so above condition will never meet and it won't clean the entries. was: MaterializationsRebuildLockCleanerTask never cleans the abandoned MV Rebuild Lock entries from MATERIALIZATION_REBUILD_LOCKS table. As a part MaterializationsRebuildLockCleanerTask, before clearing the entries it checks whether the last heartbeat time for this lock entry is lesser than the (current time - hive transaction timeout) but the MaterializationRebuildLockHeartbeater heartbeats every (hive transaction timeout/2) so above condition will never meet and it won't clean the entries. > MaterializationsRebuildLockCleanerTask never cleans the abandoned MV Rebuild > Lock entries from MATERIALIZATION_REBUILD_LOCKS table. > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-28563 > URL: https://issues.apache.org/jira/browse/HIVE-28563 > Project: Hive > Issue Type: Bug > Security Level: Public(Viewable by anyone) > Components: Materialized views > Reporter: Dayakar M > Assignee: Dayakar M > Priority: Major > > This is a followup Jira for HIVE-28416 > > MaterializationsRebuildLockCleanerTask never cleans the abandoned MV Rebuild > Lock entries from MATERIALIZATION_REBUILD_LOCKS table. > As a part MaterializationsRebuildLockCleanerTask, before clearing the entries > it checks whether the last heartbeat time for this lock entry is lesser than > the (current time - hive transaction timeout) but the > MaterializationRebuildLockHeartbeater heartbeats every (hive transaction > timeout/2) so above condition will never meet and it won't clean the entries. -- This message was sent by Atlassian Jira (v8.20.10#820010)