Comment 2 for bug 1391948

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Unable to reproduce this with PXC 5.6.19. Please let me know if I miss anything.

On node1:

mysql> show global variables like 'wsrep_OSU_method';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| wsrep_OSU_method | TOI |
+------------------+-------+
1 row in set (0.00 sec)
mysql> use nil
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from test1;
+------+-----------+
| id | name |
+------+-----------+
| 1 | nilnandan |
+------+-----------+
1 row in set (0.00 sec)

mysql> create table test2 as select * from test1;
Query OK, 1 row affected (0.14 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> show tables;
+---------------+
| Tables_in_nil |
+---------------+
| test1 |
| test2 |
+---------------+
2 rows in set (0.00 sec)

mysql> quit

in binlog (node1) :

BEGIN
/*!*/;
# at 196
#141126 13:24:34 server id 1 end_log_pos 354 CRC32 0x9ba52700 Query thread_id=4 exec_time=0 error_code=0
use `nil`/*!*/;
SET TIMESTAMP=1416988474/*!*/;
CREATE TABLE `test2` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(10) DEFAULT NULL
)
/*!*/;

On node2:

mysql> show tables;
+---------------+
| Tables_in_nil |
+---------------+
| test1 |
+---------------+
1 row in set (0.00 sec)

mysql> show tables;
+---------------+
| Tables_in_nil |
+---------------+
| test1 |
| test2 |
+---------------+
2 rows in set (0.00 sec)

mysql> select * from test2;
+------+-----------+
| id | name |
+------+-----------+
| 1 | nilnandan |
+------+-----------+
1 row in set (0.00 sec)