[MDEV-33376] RBR aborts with ER_NO_SUCH_TABLE, Internal MariaDB error code: 1146 upon INSERT DELAYED inside trx Created: 2024-02-03  Updated: 2024-02-04

Status: Open
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
Fix Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type: Bug Priority: Major
Reporter: Roel Van de Paar Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-16909 RBR aborts with ER_NO_SUCH_TABLE upon... Stalled
relates to MDEV-33377 RBR aborts with ER_SLAVE_CONVERSION_F... Open

 Description   

Few similarities with MDEV-16909, but different versions affected and different testcase and scenario.

--source include/have_binlog_format_row.inc
--source include/master-slave.inc
 
SET autocommit=0;
 
--error ER_UNKNOWN_STORAGE_ENGINE
CREATE TABLE t1 (c1 INT) ENGINE=foo;
 
--error ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN
CALL sys.statement_performance_analyzer('OVERALL', NULL, 'with_full_table_scans');
 
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (c1 VARCHAR(64), PRIMARY KEY(c1)) ENGINE=MyISAM;
INSERT DELAYED t1 VALUES (4);
 
--sync_slave_with_master
--source include/rpl_end.inc

Leads to:

10.11.7 09049fe496eea1c19cd3ce80a788fa4b75d9609e (Debug)

2024-02-03 13:10:27 5 [Note] Slave I/O thread: connected to master 'repl_user@127.0.0.1:12555',replication starts at GTID position ''
2024-02-03 13:10:29 6 [ERROR] Slave SQL: Error executing row event: 'Table 'test.t1' doesn't exist', Gtid 0-1-4, Internal MariaDB error code: 1146
2024-02-03 13:10:29 6 [Warning] Slave: Table 'test.t1' doesn't exist Error_code: 1146
2024-02-03 13:10:29 6 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.000001' position 959; GTID position '0-1-3'


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