Debian Codegraph @

mysql-test/suite/galera_3nodes/r/MDEV-29171.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 select @@wsrep_gtid_domain_id,@@wsrep_node_name;
5 @@wsrep_gtid_domain_id @@wsrep_node_name
6 100 node1
7 connection node_2;
8 select @@wsrep_gtid_domain_id,@@wsrep_node_name;
9 @@wsrep_gtid_domain_id @@wsrep_node_name
10 100 node2
11 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
12 connection node_3;
13 select @@wsrep_gtid_domain_id,@@wsrep_node_name;
14 @@wsrep_gtid_domain_id @@wsrep_node_name
15 100 node3
16 connection node_3;
17 connection node_1;
18 connection node_2;
19 connection node_1;
20 connection node_1;
21 # restart: --wsrep_new_cluster --wsrep_gtid_domain_id=200
22 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
23 VARIABLE_VALUE
24 Primary
25 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
26 VARIABLE_VALUE
27 Synced
28 show variables like 'wsrep_gtid_domain_id';
29 Variable_name Value
30 wsrep_gtid_domain_id 200
31 connection node_2;
32 # restart
33 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
34 VARIABLE_VALUE
35 Primary
36 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
37 VARIABLE_VALUE
38 Synced
39 show variables like 'wsrep_gtid_domain_id';
40 Variable_name Value
41 wsrep_gtid_domain_id 200
42 connection node_1;
43 connection node_3;
44 # restart: --wsrep_sst_donor=node2
45 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
46 VARIABLE_VALUE
47 Primary
48 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
49 VARIABLE_VALUE
50 Synced
51 show variables like 'wsrep_gtid_domain_id';
52 Variable_name Value
53 wsrep_gtid_domain_id 200
54 connection node_1;
55 connection node_1;
56 set global wsrep_gtid_domain_id=100;
57 connection node_2;
58 set global wsrep_gtid_domain_id=100;
59 CALL mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
60 connection node_3;
61 set global wsrep_gtid_domain_id=100;
62 CALL mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");