create table bbb select * from aaa dont replicated

Bug #1388226 reported by Alexander
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Invalid
Undecided
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

Bug Description

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

summary: - create table bbb select * from aaa dont replicated
+ create table bbb select * from aaa is not replicated with TOI
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

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.

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Tested with wsrep-5.6 => cannot reproduce

Changed in codership-mysql:
status: New → Invalid
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

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

summary: - create table bbb select * from aaa is not replicated with TOI
+ create table bbb select * from aaa dont replicated
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

@Alexander,

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

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.