Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2073

PXC 5.7 : CREATE TABLE AS SELECT doesn't replicate if result set is empty

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7
    • Fix Version/s: 5.7.22
    • Component/s: None
    • Security Level: Public Bug
    • Labels:
      None

      Description

      https://jenkins.percona.com/job/pxc57.test.mtr/466/Host=min-trusty-x64,Ttype=release/console

      galera.MW-340A w1 [ fail ]Found warnings/errors in server log file!
      Test ended at 2018-03-07 02:38:05
      line
      2018-03-07T07:38:04.930808Z 2 [ERROR] Slave SQL: Error 'Unknown table 'test.t3'' on query. Default database: 'test'. Query: 'DROP TABLE t3', Error_code: 1051
      ^ Found warnings in /home/jenkins/var1/1/log/mysqld.2.err
      ok

      mysqltest failed but provided no output The result from queries just before the failure was:
      < snip >
      create table t1(a int not null, b int, primary key(a)) engine=innodb;
      create table t2(d int not null, e int, primary key(d)) engine=innodb;
      set autocommit = 0;
      SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
      create table t3(d int not null, e int, primary key(d)) engine=innodb
      select * from t2;
      DROP TABLE t1;
      DROP TABLE t2;
      DROP TABLE t3;

      • the logfile can be found in '/home/jenkins/var1/log/galera.MW-340A/MW-340A.log'

        Attachments

          Expenses

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                kenn.takara Kenn Takara
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days, 2 hours
                  3d 2h