Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
Description
--source include/master-slave.inc
|
CREATE TEMPORARY TABLE t (i INT); |
CREATE TABLE t AS SELECT * FROM t; |
|
--sync_slave_with_master
|
|
# Cleanup
|
--connection master
|
DROP TEMPORARY TABLE t; |
DROP TABLE t; |
--source include/rpl_end.inc |
10.2 36c0116720 |
2018-04-13 20:16:21 139886080214784 [ERROR] Slave SQL: Error 'Table 't' is specified twice, both as a target for 'CREATE' and as a separate source for data' on query. Default database: 'test'. Query: 'CREATE TABLE t AS SELECT * FROM t', Gtid 0-1-2, Internal MariaDB error code: 1093
|
2018-04-13 20:16:21 139886080214784 [Warning] Slave: Table 't' is specified twice, both as a target for 'CREATE' and as a separate source for data Error_code: 1093
|
2018-04-13 20:16:21 139886080214784 [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 470
|
Reproducible on 10.2, 10.3. Not reproducible on 10.1.
Attachments
Issue Links
- duplicates
-
MDEV-16192 Table 't' is specified twice, both as a target for 'CREATE' and as a separate source for data
- Closed
- is caused by
-
MDEV-5535 cannot reopen temporary table
- Closed