Debian Codegraph @

mysql-test/suite/galera/r/mdev_10518.result

raw
1 connection node_2;
2 connection node_1;
3 # On node_1
4 connection node_1;
5 list of GTID variables :
6 gtid_domain_id 1
7 gtid_binlog_pos
8 gtid_binlog_state
9 gtid_current_pos
10 gtid_slave_pos
11 wsrep_gtid_domain_id 4294967295
12 wsrep_gtid_mode 1
13 # On node_2
14 connection node_2;
15 list of GTID variables :
16 gtid_domain_id 2
17 gtid_binlog_pos
18 gtid_binlog_state
19 gtid_current_pos
20 gtid_slave_pos
21 wsrep_gtid_domain_id 4294967295
22 wsrep_gtid_mode 1
23 # On node_1
24 connection node_1;
25 CREATE TABLE t1(i INT) ENGINE=INNODB;
26 CREATE TABLE t2(i INT) ENGINE=MEMORY;
27 INSERT INTO t1 VALUES(1);
28 SELECT * FROM t1;
29 i
30 1
31 SELECT * FROM t2;
32 i
33 list of GTID variables :
34 gtid_domain_id 1
35 gtid_binlog_pos 4294967295-1-3
36 gtid_binlog_state 4294967295-1-3
37 gtid_current_pos 4294967295-1-3
38 gtid_slave_pos
39 wsrep_gtid_domain_id 4294967295
40 wsrep_gtid_mode 1
41 # On node_2
42 connection node_2;
43 SELECT * FROM t1;
44 i
45 1
46 list of GTID variables :
47 gtid_domain_id 2
48 gtid_binlog_pos 4294967295-1-3
49 gtid_binlog_state 4294967295-1-3
50 gtid_current_pos
51 gtid_slave_pos
52 wsrep_gtid_domain_id 4294967295
53 wsrep_gtid_mode 1
54 # On node_1
55 connection node_1;
56 INSERT INTO t2 VALUES(1);
57 SELECT * FROM t2;
58 i
59 1
60 list of GTID variables :
61 gtid_domain_id 1
62 gtid_binlog_pos 1-1-1,4294967295-1-3
63 gtid_binlog_state 1-1-1,4294967295-1-3
64 gtid_current_pos 1-1-1,4294967295-1-3
65 gtid_slave_pos
66 wsrep_gtid_domain_id 4294967295
67 wsrep_gtid_mode 1
68 # On node_2
69 connection node_2;
70 SELECT * FROM t2;
71 i
72 list of GTID variables :
73 gtid_domain_id 2
74 gtid_binlog_pos 4294967295-1-3
75 gtid_binlog_state 4294967295-1-3
76 gtid_current_pos
77 gtid_slave_pos
78 wsrep_gtid_domain_id 4294967295
79 wsrep_gtid_mode 1
80 # On node_1
81 connection node_1;
82 DROP TABLE t1, t2;
83 #cleanup
84 connection node_1;
85 set global wsrep_on=OFF;
86 reset master;
87 set global wsrep_on=ON;
88 connection node_2;
89 set global wsrep_on=OFF;
90 reset master;
91 set global wsrep_on=ON;
92 connection node_2;
93 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
94 disconnect node_2;
95 disconnect node_1;
96 # End of test