Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # When the group is in **multi-primary** mode and the user causes a
4 # change to **single-primary** mode the group must:
5 # - 1: Elect a primary. If one is selected by the user, that member must be chosen.
6 # - 2: The primary shall be writable after processing the current backlog
7 # - 3: Secondaries shall enable the server super_read_only mode.
8 # - 4: Update everywhere checks is set to False but only after all
9 # transactions from the old primary are applied.
10 #
11 #
12 # Test:
13 #
14 # 0. This test needs two servers started in multi primary mode
15 # 1. Create table to use on test
16 # 2. Pause transactions on server2 to monitor
17 # group_replication_enforce_update_everywhere_checks
18 # 3. Push data to server1. It won't be committed on server2 due to the
19 # paused transactions
20 # 4. Execute action switch to single primary mode, with server2 as primary
21 # member
22 # 5. Confirm stages on server2
23 # 6. Since server2 has paused transactions, the values aren't committed, so
24 # group_replication_enforce_update_everywhere_checks is enabled
25 # 7. Resume transactions on server2
26 # 8. On primary member the super_read_only shall be disable
27 # 9. Confirm server2 is the group primary member.
28 # 10. server2 after update all queued transactions will disable
29 # group_replication_enforce_update_everywhere_checks
30 # 11. The secondary member shall have the super_read_only enable
31 # 12. Cleanup
32 #
33 ###############################################################################
34
35 --source include/have_debug_sync.inc
36 --source include/have_group_replication_plugin.inc
37 --source include/group_replication.inc
38
39 --echo
40 --echo # 1. Create table to use on test
41
42 CREATE TABLE test.t1 (a INT PRIMARY KEY);
43
44 --source include/rpl_sync.inc
45
46 --let $rpl_connection_name= server2
47 --source include/rpl_connection.inc
48
49 --echo
50 --echo # 2. Pause transactions on server2 to monitor
51 --echo # group_replication_enforce_update_everywhere_checks
52
53 --let $debug_point= group_replication_wait_on_observer_trans
54 --source include/add_debug_point.inc
55
56 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
57
58 --echo
59 --echo # 3. Push data to server1.
60 --echo # It won't be committed on server2 due to paused transactions
61
62 --let $rpl_connection_name= server1
63 --source include/rpl_connection.inc
64
65 --eval INSERT INTO t1 VALUES (1)
66
67 --echo
68 --echo # 4. Execute action switch to single primary mode,
69 --echo # with server2 as primary member
70
71 --let $rpl_connection_name= server1
72 --source include/rpl_connection.inc
73
74 --replace_result $server2_uuid MEMBER2_UUID
75 --send_eval SELECT group_replication_switch_to_single_primary_mode("$server2_uuid")
76
77 --echo
78 --echo # 5. Confirm stages on server2
79
80 --let $rpl_connection_name= server2
81 --source include/rpl_connection.inc
82
83 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
84
85 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.events_stages_current WHERE event_name LIKE "%Primary Election: stabilizing transactions%"
86 --source include/wait_condition.inc
87
88 --let $stage_name= `SELECT event_name FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl/Single-primary%";`
89 --let $assert_text= stage/group_rpl/Single-primary Switch: executing Primary election
90 --let $assert_cond= "$stage_name" = "stage/group_rpl/Single-primary Switch: executing Primary election"
91 --source include/assert.inc
92
93 --let $stage_name= `SELECT event_name FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl/Primary Election%";`
94 --let $assert_text= stage/group_rpl/Primary Election: stabilizing transactions from former primaries
95 --let $assert_cond= "$stage_name" = "stage/group_rpl/Primary Election: stabilizing transactions from former primaries"
96 --source include/assert.inc
97
98 --echo
99 --echo # 6. Since server2 has paused transactions, the values aren't committed, so
100 --echo # group_replication_enforce_update_everywhere_checks is enabled
101
102 --let $assert_text= group_replication_enforce_update_everywhere_checks is ON
103 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_enforce_update_everywhere_checks]" = "1"
104 --source include/assert.inc
105
106 --echo
107 --echo # 7. Resume transactions on server2
108
109 --let $debug_point= group_replication_wait_on_observer_trans
110 --source include/remove_debug_point.inc
111 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
112
113 --echo
114 --echo # 8. On primary member the super_read_only shall be disable
115
116 --let $assert_text= The super_read_only mode should be 0 here.
117 --let $assert_cond= "[SELECT @@GLOBAL.super_read_only]" = 0;
118 --source include/assert.inc
119
120 --echo
121 --echo # 9. Confirm server2 is the group primary member.
122
123 --let $rpl_connection_name= server1
124 --source include/rpl_connection.inc
125
126 --replace_result $server2_uuid MEMBER2_UUID
127 --reap
128
129 --let $rpl_connection_name= server2
130 --source include/rpl_connection.inc
131
132 --echo
133 --echo # 10. server2 after update all queued transactions will disable
134 --echo # group_replication_enforce_update_everywhere_checks
135
136 --let $group_replication_expected_uuid=$server2_uuid
137 --source include/gr_assert_primary_member.inc
138
139 --echo
140 --echo # 11. The secondary member shall have the super_read_only enable
141
142 --let $rpl_connection_name= server1
143 --source include/rpl_connection.inc
144
145 --source include/gr_assert_secondary_member.inc
146
147 --echo
148 --echo # 12. Cleanup
149
150 --let $rpl_connection_name= server2
151 --source include/rpl_connection.inc
152
153 SET DEBUG_SYNC= 'RESET';
154
155 DROP TABLE t1;
156
157 --let $rpl_group_replication_single_primary_mode=1
158 --let $rpl_group_replication_reset_persistent_vars=1
159 --source include/group_replication_end.inc