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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 10.1, 10.0
        • Fix Version/s: 10.0.18, 10.1.5
        • Component/s: Replication
        • Labels:

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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                http://lists.askmonty.org/pipermail/commits/2015-April/007767.html

                Show
                knielsen Kristian Nielsen added a comment - http://lists.askmonty.org/pipermail/commits/2015-April/007767.html

                  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: