Debian Codegraph @

mysql-test/suite/galera/t/MDEV-21479.test

raw
1 #
2 # MDEV-21479 : Galera 4 unable to query cluster state if not primary component
3 #
4 --source include/galera_cluster.inc
5 --source include/have_innodb.inc
6
7
8 --echo # Lets first see that we can access wsrep schema tables
9 --echo # Node1
10 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
11 SELECT COUNT(*) AS EXPECT_1 from mysql.wsrep_cluster;
12 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members;
13
14 --connection node_2
15 --echo # Node2
16 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
17 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster;
18 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members;
19
20 --connection node_1
21 # Make node 1 tolerate split-brain
22 SET GLOBAL wsrep_provider_options = 'pc.ignore_sb=true';
23 SET GLOBAL wsrep_provider_options = 'pc.weight=2';
24
25 # Desync and disconnect node 2 from the PC:
26 --connection node_2
27 --echo # Desync and disconnect node_2
28 SET @@global.wsrep_desync = 1;
29 SET SESSION wsrep_dirty_reads=1;
30 SET SESSION wsrep_sync_wait=0;
31 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1';
32 --let $wait_condition = SELECT VARIABLE_VALUE = 'non-Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
33 --source include/wait_condition.inc
34 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
35
36 # Wait until node 2 disappears from the PC:
37 --connection node_1
38 --echo # Waiting until node_2 is not part of cluster anymore
39 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
40 --source include/wait_condition.inc
41 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
42 --source include/wait_condition.inc
43
44 --echo # Verify that we can access wsrep schema tables
45 --echo # Node1
46 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
47 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster;
48 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster_members;
49
50 --connection node_2
51 #
52 # Here node2 remembers old configuration even when we are non-Primary
53 #
54 --echo # Node2
55 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
56 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster;
57 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members;
58
59 # Reconnect node 2 to the PC:
60 --connection node_2
61 --echo # Reconnect node_2 back to cluster
62 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=0';
63 SET wsrep_dirty_reads=0;
64 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
65 --source include/wait_condition.inc
66 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
67 --source include/wait_condition.inc
68 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
69 --source include/wait_condition.inc
70
71 # Must return 0:
72 SHOW STATUS LIKE 'wsrep_desync_count';
73
74 # Resync node_2, should pass:
75 SET @@global.wsrep_desync = 0;
76
77 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
78 --source include/wait_condition.inc
79
80 CALL mtr.add_suppression("WSREP: Protocol violation\\. JOIN message sender .+ ?is not in state transfer \\(SYNCED\\)\\. Message ignored\\.");
81
82 --connection node_1
83 --echo # Wait until both nodes are back to cluster
84 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
85 --source include/wait_condition.inc
86 SET GLOBAL wsrep_provider_options = 'pc.ignore_sb=false';
87 SET GLOBAL wsrep_provider_options = 'pc.weight=1';
88
89 --echo # Verify that we can access wsrep schema tables
90 --echo # Node1
91 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
92 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster;
93 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members;
94
95 --connection node_2
96 --echo # Node2
97 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
98 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster;
99 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members;