Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8016

Replication aborts on DROP /*!40005 TEMPORARY */ TABLE IF EXISTS

    Details

      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
          
      ...

        Attachments

          Activity

            People

            • Assignee:
              knielsen Kristian Nielsen
              Reporter:
              elenst Elena Stepanova
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: