[MDEV-16909] RBR aborts with ER_NO_SUCH_TABLE upon RENAME on temporary table - Jira

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Fix Version/s: 10.5, 10.6
Component/s: Data Definition - Temporary, Replication
Labels:
None

--source include/have_binlog_format_row.inc

--source include/master-slave.inc

CREATE TEMPORARY TABLE t1 (a INT);

--error 0,1146

RENAME TABLE t1 TO tmp;

--sync_slave_with_master

--connection master

--source include/rpl_end.inc

10.0 9dfef6e29b9
180807 3:38:56 [ERROR] Slave SQL: Error 'Table 'test.t1' doesn't exist' on query. Default database: 'test'. Query: 'RENAME TABLE t1 TO tmp', Gtid 0-1-1, Internal MariaDB error code: 1146
180807 3:38:56 [Warning] Slave: Table 'test.t1' doesn't exist Error_code: 1146
180807 3:38:56 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 313
180807 3:38:56 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000001' at position 313

The replication problem appeared in 10.0.27 release after the commit below made RENAME on temporary table possible.

commit bf2e31500c9a0a7fcdccfb724e9447347a3ab684

Author: Alexey Botchkov <holyfoot@askmonty.org>

Date:   Mon Jul 18 11:50:08 2016 +0400

    MDEV-8569 build_table_filename() doesn't support temporary tables.

            Temporary tables support added for RENAME and ALTER TABLE.

duplicates

MDEV-16728 RENAME temporary table may not find the target table on slave in RBR

relates to

MDEV-25587 RENAME on namesake of temporary table breaks binlog replay

MDEV-33376 RBR aborts with ER_NO_SUCH_TABLE, Internal MariaDB error code: 1146 upon INSERT DELAYED inside trx

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

MariaDB Server