Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate group_replication_consistency= 'AFTER' behaviour against group mode
3 # change.
4 #
5 # Test:
6 # 00. The test requires three servers: M1, M2 and M3.
7 # 01. Create a table on the group.
8 # 02. Make server3 block before send its prepare message.
9 # 03. Execute T1 on server1.
10 # 04. Wait until T1 is prepared on server3.
11 # 05. Change group mode to single primary, with server1 as
12 # primary.
13 # 06. Make server3 do send its prepare message.
14 # 07. Get outcome of the group mode change.
15 # 08. Validate data.
16 # 09. Clean up.
17 ################################################################################
18 --source include/big_test.inc
19 --source include/have_debug_sync.inc
20 --source include/have_group_replication_plugin.inc
21 --let $rpl_server_count= 3
22 --source include/group_replication.inc
23
24 --echo
25 --echo ############################################################
26 --echo # 01. Create a table on the group.
27 --let $rpl_connection_name= server1
28 --source include/rpl_connection.inc
29 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
30
31 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
32
33
34 --echo
35 --echo ############################################################
36 --echo # 02. Make server3 block before send its prepare message.
37 --let $rpl_connection_name= server3
38 --source include/rpl_connection.inc
39 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_before_message_send_after_applier_prepare';
40
41
42 --echo
43 --echo ############################################################
44 --echo # 03. Execute T1 on server1.
45 --let $rpl_connection_name= server1
46 --source include/rpl_connection.inc
47 --send INSERT INTO t1 VALUES (1)
48
49
50 --echo
51 --echo ############################################################
52 --echo # 04. Wait until T1 is prepared on server3.
53 --let $rpl_connection_name= server3
54 --source include/rpl_connection.inc
55 # Wait for the debug sync to be reached.
56 SET DEBUG_SYNC= "now WAIT_FOR signal.after_before_message_send_after_applier_prepare_waiting";
57
58
59 --echo
60 --echo ############################################################
61 --echo # 05. Change group mode to single primary, with server1 as
62 --echo # primary.
63 --let $rpl_connection_name= server_3
64 --source include/rpl_connection.inc
65 --replace_result $server1_uuid MEMBER1_UUID
66 --send_eval SELECT group_replication_switch_to_single_primary_mode("$server1_uuid")
67
68 --let $rpl_connection_name= server3
69 --source include/rpl_connection.inc
70 --let $wait_condition=SELECT COUNT(*)=1 FROM information_schema.processlist WHERE user='root' AND state='Executing hook on transaction begin.' AND info LIKE 'SELECT group_replication_switch_to_single_primary_mode(%'
71 --source include/wait_condition.inc
72
73
74 --echo
75 --echo ############################################################
76 --echo # 06. Make server3 do send its prepare message.
77 --let $rpl_connection_name= server3
78 --source include/rpl_connection.inc
79 # Signal debug sync to continue.
80 SET DEBUG_SYNC= 'now SIGNAL signal.after_before_message_send_after_applier_prepare_continue';
81 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_before_message_send_after_applier_prepare';
82
83
84 --echo
85 --echo ############################################################
86 --echo # 07. Get outcome of the group mode change.
87 --let $rpl_connection_name= server_3
88 --source include/rpl_connection.inc
89 --replace_result $server1_uuid MEMBER1_UUID
90 --reap
91 --source include/gr_assert_secondary_member.inc
92
93 --let $rpl_connection_name= server_1
94 --source include/rpl_connection.inc
95 --source include/gr_assert_primary_member.inc
96
97 --let $rpl_connection_name= server2
98 --source include/rpl_connection.inc
99 --source include/gr_assert_secondary_member.inc
100
101
102 --echo
103 --echo ############################################################
104 --echo # 08. Validate data.
105 --let $rpl_connection_name= server1
106 --source include/rpl_connection.inc
107 --reap
108
109 --let $assert_text= 'There is a 1 value in table t1'
110 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
111 --source include/assert.inc
112
113 --let $rpl_connection_name= server2
114 --source include/rpl_connection.inc
115 --let $assert_text= 'There is a 1 value in table t1'
116 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
117 --source include/assert.inc
118
119 --let $rpl_connection_name= server3
120 --source include/rpl_connection.inc
121 --let $assert_text= 'There is a 1 value in table t1'
122 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
123 --source include/assert.inc
124
125 --let $diff_tables=server1:t1, server2:t1, server3:t1
126 --source include/diff_tables.inc
127
128
129 --echo
130 --echo ############################################################
131 --echo # 09. Clean up.
132 --let $rpl_connection_name= server1
133 --source include/rpl_connection.inc
134 DROP TABLE t1;
135
136 --let $rpl_group_replication_single_primary_mode=1
137 --let $rpl_group_replication_reset_persistent_vars=1
138 --source include/group_replication_end.inc