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

RBR fails with ER_KEY_NOT_FOUND on tables with Aria and certain character sets

    XMLWordPrintable

Details

    Description

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t (b CHAR(8), KEY(b)) ENGINE=Aria CHARACTER SET utf32;
      INSERT INTO t VALUES ('x');
      UPDATE t SET b = 'updated';
      --sync_slave_with_master
       
      # Cleanup
      --connection master
      DROP TABLE t;
      --source include/rpl_end.inc
      

      10.4 9856bb42

      2023-07-11 15:01:55 13 [ERROR] mysqld: Can't find record in 't'
      2023-07-11 15:01:55 13 [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_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 960, Gtid 0-1-3, Internal MariaDB error code: 1032
      2023-07-11 15:01:55 13 [Warning] Slave: Can't find record in 't' Error_code: 1032
      

      Reproducible on all existing versions, also earlier releases.
      Also reproducible with ucs2.
      Not reproducible without a key.
      Not reproducible with MyISAM instead of Aria.

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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