1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
|
#######################################################################################
# This test checks dynamically setting the values for
# group_replication_communication_debug_options variable and checks all possible correct
# and incorrect values before and after starting the group replication and also
# setting the incorrect values through cmdline
#
# WL10200 : Change GCS/XCOM to have dynamic debugging and tracing
# Test :
# 0. This test requires 2 servers(1 server for all the correct and incorrect values verification, and
# 2nd server for cmdline value verification for this gr_communication_debug_options variable)
# 1. Store the values of gr_communication_debug_options before doing any operations on server1
# 2. Check and make sure file is not created when the server is started
# and validate the default value set for group_replication_communication_
# debug_options variable
# 3. Make sure server throws proper error when user tries to set incorrect values for
# gr_communication_debug_options
# 4. Test passing more than one value to group_replication_communication_debug_options
# with one incorrect value, and make sure server throws proper error
# 5. Bootstrap and start group replication on server1
# 6. Make sure file is created once the gr is started, in server1 data directory
# 7. Make sure server1 throws proper error, if user tries to set incorrect value,
# even after the gr is started
# 8. Validate the option set after 3-4 failed attempts with incorrect values
# 9. Set all the 5 valid values dynamically and make sure value set is GCS_DEBUG_ALL
# 10.Test passing more than one values(correct/incorrect) to group_replication_communication_debug_options
# also validate the set options.
# 11.Overwrite the previous option with "" dynamically and make sure old value is
# overridden by disabling all the previous set options.
# 12.Set all the 5 valid values and start the gr and validate that value set is GCS_DEBUG_ALL
# 13.Try to set all the valid values possible dynamically on server1 and validate the same
# 14.Make sure GCS_DEBUG_TRACE file is present after all these operations
# 15.Server2 is set with incorrect gr_communications_debug_options during the start,
# connect a client and try to start the gr and then set the correct values to
# gr_communications_debug_options and start the gr and validate
# 16.Overwrite previous set options with "" dynamically and make sure old value is
# overridden by disabling all the previous set options
# 17.Connect to server1 and cleanup
#######################################################################################
--source include/have_debug.inc
--let $group_replication_group_name= 89ab83b0-9f17-11e3-a5e2-0800200c9a66
--source include/have_group_replication_plugin.inc
--let $rpl_server_count= 2
--let $rpl_skip_group_replication_start= 1
--source include/group_replication.inc
SET SESSION sql_log_bin=0;
call mtr.add_suppression("\\[ERROR\\] \\[MY-[^]]*\\] \\[Repl\] Plugin group_replication reported: 'Some debug options in '.*' are not valid.'");
SET SESSION sql_log_bin=1;
# Store the values of gr_communication_debug_options before doing any operations on server1
--let $saved_gr_communication_debug_options_server1 = `SELECT @@GLOBAL.group_replication_communication_debug_options;`
# Check and make sure file is not created when the server is started and validate
# the default value set for group_replication_communication_debug_options variable
--error 1
--file_exists $MYSQLTEST_VARDIR/mysqld.1/data/GCS_DEBUG_TRACE
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_NONE"
--source include/assert.inc
# Make sure server throws proper error when user tries to set incorrect values for
# gr_communication_debug_options.
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="123456";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="!@#!#!#";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS=",,,";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_DBG";
# Test passing more than one value to group_replication_communication_debug_options
# with one incorrect value, and make sure server throws proper error
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_ALL,12345";
# Bootstrap and start group replication on server1
--source include/start_and_bootstrap_group_replication.inc
# Make sure file is created once the gr is started, in server1 data directory
--file_exists $MYSQLTEST_VARDIR/mysqld.1/data/GCS_DEBUG_TRACE
# Make sure server1 throws proper error, if user tries to set incorrect value,
# even after the gr is started
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="123456";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="!@#!#!#";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS=",,,,,";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_DBG";
# Validate the option set after 3-4 failed attempts with incorrect values
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_NONE"
--source include/assert.inc
# Set all the 5 valid values dynamically and make sure value set is GCS_DEBUG_ALL
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_BASIC,GCS_DEBUG_TRACE,XCOM_DEBUG_BASIC,XCOM_DEBUG_TRACE,GCS_DEBUG_ALL";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_ALL"
--source include/assert.inc
# Test passing more than one values(correct/incorrect) to group_replication_communication_debug_options
# also validate the set options
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_ALL,12345";
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_ALL,XCOM_DEBUG_DBG";
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_BASIC,GCS_DEBUG_TRACE,XCOM_DEBUG_BASIC,XCOM_DEBUG_TRACE";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_BASIC,GCS_DEBUG_TRACE,XCOM_DEBUG_BASIC,XCOM_DEBUG_TRACE"
--source include/assert.inc
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_BASIC,,,,,XCOM_DEBUG_BASIC";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_BASIC,XCOM_DEBUG_BASIC"
--source include/assert.inc
# Overwrite the previous option with "" dynamically and make sure old value is
# overridden by disabling all the previous set options.
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_NONE"
--source include/assert.inc
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
--source include/stop_group_replication.inc
--remove_file $MYSQLTEST_VARDIR/mysqld.1/data/GCS_DEBUG_TRACE
--source include/start_and_bootstrap_group_replication.inc
# Try to set all the valid values possible dynamically on server1 and validate the same
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_NONE";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_NONE"
--source include/assert.inc
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_BASIC";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_BASIC"
--source include/assert.inc
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_TRACE";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_TRACE"
--source include/assert.inc
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="XCOM_DEBUG_BASIC";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "XCOM_DEBUG_BASIC"
--source include/assert.inc
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="XCOM_DEBUG_TRACE";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "XCOM_DEBUG_TRACE"
--source include/assert.inc
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_ALL";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_ALL"
--source include/assert.inc
# Make sure GCS_DEBUG_TRACE file is present after all these operations
--file_exists $MYSQLTEST_VARDIR/mysqld.1/data/GCS_DEBUG_TRACE
# Server2 is set with incorrect gr_communications_debug_options during the start,
# connect a client and try to start the gr and then set the correct values to
# gr_communications_debug_options and start the gr and validate
--let $rpl_connection_name= server2
--source include/rpl_connection.inc
SET SESSION sql_log_bin=0;
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin group_replication reported: 'Some debug options in '.*' are not valid.'");
SET SESSION sql_log_bin=1;
SET GLOBAL group_replication_group_name= "89ab83b0-9f17-11e3-a5e2-0800200c9a66";
--error ER_GROUP_REPLICATION_CONFIGURATION
START GROUP_REPLICATION;
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="GCS_DEBUG_BASIC,XCOM_DEBUG_BASIC,GCS_DEBUG_TRACE";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_BASIC,GCS_DEBUG_TRACE,XCOM_DEBUG_BASIC"
--source include/assert.inc
--source include/start_group_replication.inc
--file_exists $MYSQLTEST_VARDIR/mysqld.1/data/GCS_DEBUG_TRACE
# Overwrite previous set options with "" dynamically and make sure old value is
# overridden by disabling all the previous set options.
SET GLOBAL GROUP_REPLICATION_COMMUNICATION_DEBUG_OPTIONS="";
--let $assert_text= Checking the value of gr_communications_debug_opts
--let $assert_cond= "[SELECT @@GLOBAL.group_replication_communication_debug_options]" = "GCS_DEBUG_NONE"
--source include/assert.inc
# Connect to server1 and cleanup
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
--disable_query_log
--eval SET @@GLOBAL.group_replication_communication_debug_options= "$saved_gr_communication_debug_options_server1"
--enable_query_log
--source include/group_replication_end.inc
# Known issue: Once bug#26729404 is fixed, remove the below lines.
# For Server2, the value of gr_communications_debug_options can't be
# set back to GCS_DEBUG_INVALID since its a garbage value and this
# will cause check-testcase failure on server2. Thus, disabling the
# check-testcase by sourcing 'force_restart.inc' file for the test.
--source include/force_restart.inc
|
