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

binlog.binlog_stm_drop_tmp_tbl fails in buildbot with Unknown table on exec

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos73-ppc64le/builds/9249

      bb-10.1-release 4177181e1617df185397ea275ee98eb4

      binlog.binlog_stm_drop_tmp_tbl 'innodb_plugin,mix' w3 [ fail ]
              Test ended at 2019-07-26 10:12:03
       
      CURRENT_TEST: binlog.binlog_stm_drop_tmp_tbl
      ERROR 1051 (42S02) at line 77: Unknown table 'test.t1'
      mysqltest: In included file "./extra/binlog_tests/drop_temp_table.test": 
      included from /usr/share/mysql-test/suite/binlog/t/binlog_stm_drop_tmp_tbl.test at line 6:
      At line 168: exec of '/usr/bin/mysql --defaults-file=/dev/shm/var/3/my.cnf < /dev/shm/var/3/tmp/bug28642318.sql' failed, error: 256, status: 1, errno: 95
      Output from before failure:
      # DROP table query fails with unknown table error without patch.
       
       
       
      The result from queries just before the failure was:
      < snip >
      RESET MASTER;
      # Set up.
      SET @save_binlog_format= @@session.binlog_format;
      SET @@session.binlog_format=STATEMENT;
      CREATE TABLE t1 (a INT) ENGINE=INNODB;
      SET @@session.binlog_format=STATEMENT;
      CREATE TEMPORARY TABLE t1 (b BLOB) ENGINE=INNODB;
      DELETE d1, d2 FROM t1 AS d1, t1 AS d2 WHERE d1.a<>d2.a;
      DROP TABLE t1;
      # DELETE query fails with table re-open error without patch.
      # Clean up.
      DROP TABLE IF EXISTS t1;
      DROP TABLE IF EXISTS t1;
      RESET MASTER;
      # Test case for DROP query.
      CREATE TABLE t1 (a INT) ENGINE=INNODB;
      CREATE TEMPORARY TABLE t1 (b BLOB) ENGINE=INNODB;
      DROP TABLE t1;
      DROP TABLE t1;
      # DROP table query fails with unknown table error without patch.
      

        Attachments

          Activity

            People

            Assignee:
            Elkin Andrei Elkin
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: