Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
Description
Test case |
--source include/master-slave.inc
|
--source include/have_binlog_format_statement.inc
|
|
--connection master1
|
CREATE TABLE t1 (i INT); |
INSERT INTO t1 VALUES (1),(2); |
CREATE FUNCTION f() RETURNS INTEGER RETURN 1; |
CREATE TEMPORARY TABLE tmp AS SELECT f() AS col FROM t1; |
--disconnect master1
|
--sleep 1
|
--connection master
|
|
--sync_slave_with_master
|
Last_SQL_Error Error 'Can't reopen table: 'tmp'' on query. Default database: 'test'. Query: 'DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp`'
|
Apparently the problem appeared on 10.0 tree with the following revision:
commit 96784eb106d9e0ab6ce717a937a9be9af714b223
|
Author: Kristian Nielsen <knielsen@knielsen-hq.org>
|
Date: Mon Mar 9 13:06:32 2015 +0100
|
|
MDEV-7668: Intermediate master groups CREATE TEMPORARY with INSERT, causing parallel replication failure
|
|
...
|