You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Zsolt Miskolczi (Jira)" <ji...@apache.org> on 2024/04/09 17:10:00 UTC

[jira] [Created] (HIVE-28190) Fix breaking bug in heartbeatLockMaterializationRebuild

Zsolt Miskolczi created HIVE-28190:
--------------------------------------

             Summary: Fix breaking bug in heartbeatLockMaterializationRebuild
                 Key: HIVE-28190
                 URL: https://issues.apache.org/jira/browse/HIVE-28190
             Project: Hive
          Issue Type: Bug
          Components: Standalone Metastore
            Reporter: Zsolt Miskolczi
            Assignee: Zsolt Miskolczi


It fails with the following error: 
{code:java}
org.springframework.dao.InvalidDataAccessApiUsageException: SQL [UPDATE "MATERIALIZATION_REBUILD_LOCKS" SET "MRL_LAST_HEARTBEAT" = 1712571919559 WHERE "MRL_TXN_ID" = 2297 AND "MRL_DB_NAME" = ? AND "MRL_TBL_NAME" = ?]: given 2 parameters but expected 0 {code}

We didn't spot it so far as when the heartbeat of materialized view fails with an error, it doesn't affect the rebuild query run. So that it can be only spotted by actively watching the logs.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)