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

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

    XMLWordPrintable

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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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