Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-28190

Materialized view rebuild lock heart-beating is broken

    XMLWordPrintableJSON

Details

    Description

      It fails with the following error: 

      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

      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.

      Attachments

        Issue Links

          is caused by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-27481 TxnHandler cleanup

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #5186

          Activity

            People

              InvisibleProgrammer Zsolt Miskolczi
              InvisibleProgrammer Zsolt Miskolczi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: