Debian Codegraph @

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

raw
1 ########################################################################
2 #
3 # This test validate transactions that aren't held
4 #
5 # Test:
6 # 0. This test requires one server on single primary mode
7 # 1. Enable debug point that run an assert if command will be put on
8 # hold
9 # 2. Validate SQL command SHOW will not block
10 # 3. Validate SQL command SET will not block
11 # 4. Validate SQL command DO will not block
12 # 5. Validate SQL command EMPTY will not block
13 # 6. Validate SQL command USE will not block
14 # 7. Validate SQL command SELECT to performance_schema will not block
15 # 8. Validate SQL command SELECT to table PROCESSLIST from database
16 # infoschema will not block
17 # 9. Validate SQL command SELECT from database syschema will not block
18 # 10. Validate SQL command SELECT that don't use tables will not block
19 # 11. Validate SQL command RESET PERSIST will not block
20 # 12. Validate SQL command STOP GROUP_REPLICATION will not block
21 # 13. Reconnect server1 to group
22 # 14. Validate SQL command SHUTDOWN will not block
23 # 15. Cleanup
24 #
25 ########################################################################
26
27 --source include/have_debug.inc
28 --source include/have_group_replication_plugin.inc
29 --let $rpl_skip_group_replication_start= 1
30 --let $rpl_server_count= 2
31 --let $rpl_group_replication_single_primary_mode=1
32 --source include/group_replication.inc
33
34 --let $rpl_connection_name= server1
35 --source include/rpl_connection.inc
36
37 SET @@SESSION.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER;
38
39 --source include/start_and_bootstrap_group_replication.inc
40
41 --echo
42 --echo # 1. Enable debug point that run an assert if command will be put on
43 --echo # hold
44
45 --let $rpl_connection_name= server1
46 --source include/rpl_connection.inc
47
48 SET @debug_save= @@GLOBAL.DEBUG;
49 # If any command is hold the server will trigger an assert
50 SET @@GLOBAL.DEBUG= '+d,launch_hook_trans_begin_assert_if_hold';
51
52 --echo
53 --echo # 2. Validate SQL command SHOW will not block
54
55 SHOW GLOBAL VARIABLES LIKE 'group_replication_consistency';
56
57 --disable_result_log
58 SHOW PROCESSLIST;
59
60 SHOW STATUS;
61
62 SHOW ENGINE INNODB LOGS;
63
64 SHOW ENGINE INNODB STATUS;
65
66 SHOW ENGINE INNODB MUTEX;
67
68 SHOW MASTER STATUS;
69
70 SHOW REPLICA STATUS;
71
72 SHOW CHARACTER SET;
73
74 SHOW COLLATION;
75
76 SHOW BINARY LOGS;
77
78 SHOW OPEN TABLES;
79
80 SHOW REPLICAS;
81
82 SHOW BINLOG EVENTS;
83
84 SHOW WARNINGS;
85
86 SHOW ERRORS;
87
88 SHOW ENGINES;
89
90 SHOW PRIVILEGES;
91
92 SHOW PROCEDURE STATUS;
93
94 SHOW FUNCTION STATUS;
95
96 SHOW PLUGINS;
97
98 SHOW EVENTS;
99
100 SHOW PROFILE;
101
102 SHOW PROFILES;
103
104 SHOW RELAYLOG EVENTS;
105 --enable_result_log
106
107 --echo
108 --echo # 3. Validate SQL command SET will not block
109
110 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
111
112 --echo
113 --echo # 4. Validate SQL command DO will not block
114
115 DO SLEEP(1);
116
117 --echo
118 --echo # 5. Validate SQL command EMPTY will not block
119
120 --exec $MYSQL --comments -e "-- sql comment"
121
122 --echo
123 --echo # 6. Validate SQL command USE will not block
124
125 USE test;
126
127 --echo
128 --echo # 7. Validate SQL command SELECT to performance_schema will not block
129
130 SELECT COUNT(*) from performance_schema.replication_group_members;
131
132 --echo
133 --echo # 8. Validate SQL command SELECT to table PROCESSLIST from database
134 --echo # infoschema will not block
135
136 SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE='debug sync point: now';
137
138 --echo
139 --echo # 9. Validate SQL command SELECT from database syschema will not block
140
141 SELECT COUNT(*)=1 FROM sys.version;
142
143 --echo
144 --echo # 10. Validate SQL command SELECT that don't use tables will not block
145
146 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
147 SELECT @@GLOBAL.GTID_EXECUTED;
148
149 --echo
150 --echo # 11. Validate SQL command RESET PERSIST will not block
151
152 RESET PERSIST;
153
154 --echo
155 --echo # 12. Validate SQL command STOP GROUP_REPLICATION will not block
156
157 STOP GROUP_REPLICATION;
158
159 --echo
160 --echo # 13. Reconnect server1 to group
161
162 --let $rpl_connection_name= server1
163 --source include/rpl_connection.inc
164
165 SET @@GLOBAL.DEBUG= '-d,launch_hook_trans_begin_assert_if_hold';
166
167 --source include/start_and_bootstrap_group_replication.inc
168
169 --echo
170 --echo # 14. Validate SQL command SHUTDOWN will not block
171
172 SET @@GLOBAL.DEBUG= '+d,launch_hook_trans_begin_assert_if_hold';
173
174 SHUTDOWN;
175
176 --source include/wait_until_disconnected.inc
177
178 --enable_reconnect
179 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
180
181 --source include/wait_until_connected_again.inc
182 --disable_reconnect
183
184
185 --let $rpl_server_number= 1
186 --source include/rpl_reconnect.inc
187
188 --echo
189 --echo # 15. Cleanup
190
191 SET @@GLOBAL.DEBUG= '-d,launch_hook_trans_begin_assert_if_hold';
192
193 --replace_result $group_replication_group_name GROUP_NAME
194 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
195 --replace_result $_group_replication_local_address GROUP_LOCAL_ADDRESS2
196 --eval SET GLOBAL group_replication_local_address= "$_group_replication_local_address"
197 --replace_result $_group_replication_group_seeds GROUP_SEEDS_SERVER2
198 --eval SET GLOBAL group_replication_group_seeds= "$_group_replication_group_seeds"
199 --eval SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
200 --eval SET GLOBAL group_replication_single_primary_mode= TRUE;
201
202 SET @@SESSION.group_replication_consistency= DEFAULT;
203
204 --source include/group_replication_end.inc