Comment 3 for bug 1376727

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

With upstream also able to reproduce

Node 1
*****

mysql> select * from test.demo_test;
+-----+--------------+------+------+------+
| c1 | c2 | c3 | c4 | c5 |
+-----+--------------+------+------+------+
| a11 | 123456789 | 10 | 2 | 0 |
| a12 | 123456789 | 10 | 1 | 0 |
| AA | HELLO, HELLO | 8 | 0 | 0 |
+-----+--------------+------+------+------+
3 rows in set (0.00 sec)

mysql> select * from test.demo_test;select @@wsrep_node_name;
+-----+--------------+------+------+------+
| c1 | c2 | c3 | c4 | c5 |
+-----+--------------+------+------+------+
| a11 | 123456789 | 10 | 2 | 0 |
| a12 | 123456789 | 10 | 1 | 0 |
| AA | HELLO, HELLO | 8 | 0 | 0 |
+-----+--------------+------+------+------+
3 rows in set (0.00 sec)

+-------------------+
| @@wsrep_node_name |
+-------------------+
| node1 |
+-------------------+
1 row in set (0.00 sec)

mysql> select @@version,@@version_comment;
+------------+-------------------------------------------+
| @@version | @@version_comment |
+------------+-------------------------------------------+
| 5.6.23-log | MySQL Community Server (GPL), wsrep_25.10 |
+------------+-------------------------------------------+
1 row in set (0.00 sec)

mysql>

Node 2
******

mysql> select * from test.demo_test;select @@wsrep_node_name;
+----+--------------+------+------+------+
| c1 | c2 | c3 | c4 | c5 |
+----+--------------+------+------+------+
| AA | HELLO, HELLO | 8 | 0 | 0 |
+----+--------------+------+------+------+
1 row in set (0.00 sec)

+-------------------+
| @@wsrep_node_name |
+-------------------+
| node2 |
+-------------------+
1 row in set (0.01 sec)

mysql> select @@version,@@version_comment;
+------------+-------------------------------------------+
| @@version | @@version_comment |
+------------+-------------------------------------------+
| 5.6.23-log | MySQL Community Server (GPL), wsrep_25.10 |
+------------+-------------------------------------------+
1 row in set (0.00 sec)

mysql>