Debian Codegraph @

mysql-test/suite/group_replication/t/gr_majority_loss_modify_wc.test

raw
1 ################################################################################
2 # WL#11512
3 # Verify that a blocked group, a group with 2 members on which 1 crashes
4 # (without executing STOP GROUP_REPLICATION), *cannot* modify its
5 # "write concurrency."
6 #
7 # Test:
8 # 0) The test requires two servers: M1 and M2
9 # 1) Create a group with 2 members. Bring all ONLINE and create a table.
10 # 2) Reconfigure write-concurrency value on group.
11 # 3) Crash M2
12 # 4) Unsuccessfully call to group_replication_set_write_concurrency(_) on
13 # blocked server (M1).
14 # 5) Unblock the group with the alive member (M1).
15 # 6) Check that write_concurrency value remains same after unblocking group.
16 # 7) Call group_replication_set_write_concurrency(_) on M1 in order to prove
17 # liveness. Assert check that "write concurrency" is modified.
18 # 8) Clean up.
19 #
20 # Note: based off majority_loss_5_to_2
21 ################################################################################
22 # This test does crashes servers, thence we skip it on valgrind.
23 --source include/not_valgrind.inc
24 --source include/have_group_replication_plugin.inc
25
26 --let $rpl_connection_name= server1
27 --source include/rpl_connection.inc
28 --let $member1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
29
30 --let $rpl_connection_name= server2
31 --source include/rpl_connection.inc
32 --let $member2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
33
34 --let $rpl_connection_name= server1
35 --source include/rpl_connection.inc
36
37 --echo
38 --echo ############################################################
39 --echo # Step 1 Create a group with 2 members. Bring all ONLINE.
40 --let $rpl_server_count= 2
41 --source include/group_replication.inc
42
43 --echo
44 --echo ############################################################
45 --echo # Step 2 Reconfigure write-concurrency value on group, check the new value.
46 --let $gr_new_write_concurrency= 42
47
48 --eval SELECT group_replication_set_write_concurrency($gr_new_write_concurrency)
49 --let $wait_condition= SELECT group_replication_get_write_concurrency() = $gr_new_write_concurrency
50 --source include/wait_condition.inc
51
52 --echo
53 --echo ############################################################
54 --echo # Step 3 Crash M2
55 # We do kill the servers, using shutdown_server 0, and then MTR will
56 # follow the expect file and restart the server, but we do not wait
57 # for the server restart.
58 # Since the servers loose its GCS configuration they will not rejoin
59 # the group.
60 --let $rpl_connection_name= server2
61 --source include/rpl_connection.inc
62 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.2.expect
63 --shutdown_server 0
64 --source include/wait_until_disconnected.inc
65
66 # Wait until all members are marked unreachable in
67 # the remaining server
68 --let $rpl_connection_name= server1
69 --source include/rpl_connection.inc
70
71 --let $group_replication_member_state= UNREACHABLE
72 --let $group_replication_member_id= $member2_uuid
73 --source include/gr_wait_for_member_state.inc
74 --echo member2 @ server1 is marked as UNREACHABLE
75
76 --echo
77 --echo ############################################################
78 --echo # Step 4 Unsuccessfully call to group_replication_set_write_concurrency(_) on blocked server (M1).
79 # group_replication_set_write_concurrency will fail since group lost its
80 # majority.
81 --let $rpl_connection_name= server1
82 --source include/rpl_connection.inc
83
84 --error ER_CANT_INITIALIZE_UDF
85 --eval SELECT group_replication_set_write_concurrency($gr_new_write_concurrency)
86
87 # Ensure that even group_replication_get_write_concurrency fails since group lost majority.
88 --error ER_CANT_INITIALIZE_UDF
89 --eval SELECT group_replication_get_write_concurrency()
90
91 --echo
92 --echo ############################################################
93 --echo # Step 5 Unblock the group with the alive member (M1).
94 --let $local_address_server1= `SELECT @@GLOBAL.group_replication_local_address`
95
96 --disable_query_log
97 --eval SET GLOBAL group_replication_force_members= "$local_address_server1"
98 --enable_query_log
99
100 --let $assert_text= group_replication_force_members is correct
101 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = "$local_address_server1"
102 --source include/assert.inc
103
104 --let $group_replication_number_of_members= 1
105 --source include/gr_wait_for_number_of_members.inc
106
107 --echo
108 --echo ############################################################
109 --echo # Step 6 Check that write_concurrency value remains same after unblocking group.
110 --let $wait_condition= SELECT group_replication_get_write_concurrency() = $gr_new_write_concurrency
111 --source include/wait_condition.inc
112
113 --echo
114 --echo ############################################################
115 --echo # Step 7 Call group_replication_set_write_concurrency(_) on M1 in order to prove liveness. Assert check that "write concurrency" is modified.
116 --let $gr_new_write_concurrency= 111
117 --eval SELECT group_replication_set_write_concurrency($gr_new_write_concurrency)
118 --let $wait_condition= SELECT group_replication_get_write_concurrency() = $gr_new_write_concurrency
119 --source include/wait_condition.inc
120
121 --echo
122 --echo ############################################################
123 --echo # Step 8 Clean up.
124
125 --let $rpl_connection_name= server2
126 --source include/rpl_connection.inc
127 --let $rpl_server_number= 2
128 --source include/rpl_reconnect.inc
129
130 --source include/group_replication_end.inc