Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
-
None
Description
--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.
|
Attachments
Issue Links
- duplicates
-
MDEV-16728 RENAME temporary table may not find the target table on slave in RBR
- Open
- relates to
-
MDEV-25587 RENAME on namesake of temporary table breaks binlog replay
- Open
-
MDEV-33376 RBR aborts with ER_NO_SUCH_TABLE, Internal MariaDB error code: 1146 upon INSERT DELAYED inside trx
- Open