create table bbb select * from aaa dont replicated

[Alexander]

mysqld Ver 5.6.20-68.0-56 for debian-linux-gnu on x86_64 (Percona XtraDB Cluster (GPL), Release 25.7, wsrep_25.7.r4126)

on first node:

mysql> create table demo ( `login` varchar(50) DEFAULT NULL, `email` varchar(255) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0,22 sec)

mysql> insert into demo set login='login', <email address hidden>';
Query OK, 1 row affected (0,00 sec)

mysql> create table demo1 select * from demo;
Query OK, 1 row affected (0,20 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> show tables like 'demo%'
    -> ;
+---------------------------+
| Tables_in_cipt_db (demo%) |
+---------------------------+
| demo |
| demo1 |
+---------------------------+
2 rows in set (0,00 sec)

on second node:
mysql> show tables like 'demo%';
+---------------------------+
| Tables_in_cipt_db (demo%) |
+---------------------------+
| demo |
+---------------------------+
1 row in set (0,00 sec)

error log is empty

[Raghavendra D Prabhu (raghavendra-prabhu)]

After adding TOI around CREATE..SELECT, there is an assertion with UNIV_DEBUG + log-bin=OFF http://paste.wnohang.net/e0dca1

With log-bin ON, there is no further assertion.

[Seppo Jaakola (seppo-jaakola)]

Tested with wsrep-5.6 => cannot reproduce

[Raghavendra D Prabhu (raghavendra-prabhu)]

Actually, reverting the TOI fix since it is not required at this point.

[Raghavendra D Prabhu (raghavendra-prabhu)]

@Alexander,

It replicates fine with 5.6.21, hence marking as 'fix released' for now. You can grab 5.6.21 from experimental repo.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1761