Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39782

RBR fails with ER_KEY_NOT_FOUND upon UPDATE on HEAP table with blob

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t (f BLOB) ENGINE=HEAP;
      INSERT INTO t VALUES (0); 
      UPDATE t SET f = 1; 
       
      --sync_slave_with_master
       
      --connection master
      DROP TABLE t;
      --source include/rpl_end.inc
      

      bb-blob-monty f993ed539095a64f6c26972a935beb764f4047e2

      2026-05-28 11:23:32 7 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table test.t; Can't find record in 't', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 896, Gtid 0-1-3, Internal MariaDB error code: 1032
      2026-05-28 11:23:32 7 [Warning] Slave: Can't find record in 't' Error_code: 1032
       
      #260528 11:23:32 server id 1  end_log_pos 896 CRC32 0xed29aea9  Update_rows: table id 32 flags: STMT_END_F
      ### UPDATE `test`.`t`
      ### WHERE
      ###   @1='\x00'
      ### SET
      ###   @1='1'
      # Number of rows: 1
      # at 896
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.