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

Posted to issues@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2024/04/22 07:40:00 UTC

[jira] [Commented] (HIVE-28190) Materialized view rebuild lock heart-beating is broken

    [ https://issues.apache.org/jira/browse/HIVE-28190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17839527#comment-17839527 ] 

Denys Kuzmenko commented on HIVE-28190:
---------------------------------------

Merged to master.
Thanks for the fix [~InvisibleProgrammer] and [~kkasa] for the review!

> Materialized view rebuild lock heart-beating is broken
> ------------------------------------------------------
>
>                 Key: HIVE-28190
>                 URL: https://issues.apache.org/jira/browse/HIVE-28190
>             Project: Hive
>          Issue Type: Bug
>          Components: Standalone Metastore
>    Affects Versions: 4.0.0
>            Reporter: Zsolt Miskolczi
>            Assignee: Zsolt Miskolczi
>            Priority: Critical
>              Labels: hive-4.0.1-must, pull-request-available
>
> 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)