[MDEV-31663] RBR fails with ER_KEY_NOT_FOUND on tables with Aria and certain character sets Created: 2023-07-11  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Character Sets, Replication, Storage Engine - Aria
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-31665 Mixed up errors and warnings in the r... Open

 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.


Generated at Thu Feb 08 10:25:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.