1# ==== Purpose ====
2#
3# This file restarts a server after replacing it relay log info repository file by a custom one
4#
5# ==== Usage ====
6#
7# --sub_testcase= <sub testcase name>
8#
9# Parameters:
10#  $slave_server_num
11#    The number of the slave server for which operations in this script
12#    are to be performed.
13#  $rpl_server_restart_parameters
14#    The parameters passed to the server on start
15#  $sub_testcase
16#    The test case name for which file repo is to be prepared.
17
18--write_file $MYSQL_TMP_DIR/create_file_repo_with_PCU_has_@.inc END_OF_PROCEDURE
19  --write_file $MYSQLD_DATADIR/$filename
2010
21./slave-relay-bin.000001
224
23
240
250
260
271
28
29replication_applier
30l@calhost
31EOF
32END_OF_PROCEDURE
33
34--write_file $MYSQL_TMP_DIR/create_file_repo_with_anon_PCU.inc END_OF_PROCEDURE
35  --write_file $MYSQLD_DATADIR/$filename
3610
37./slave-relay-bin.000001
384
39
400
410
420
431
44
45
46localhost
47EOF
48END_OF_PROCEDURE
49
50--write_file $MYSQL_TMP_DIR/create_file_repo_with_nonexist_PCU.inc END_OF_PROCEDURE
51  --write_file $MYSQLD_DATADIR/$filename
5210
53./slave-relay-bin.000001
544
55
560
570
580
591
60
61replication_applier_nonexist
62localhost
63EOF
64END_OF_PROCEDURE
65
66--write_file $MYSQL_TMP_DIR/create_file_repo_with_PCU.inc END_OF_PROCEDURE
67  --write_file $MYSQLD_DATADIR/$filename
6810
69./slave-relay-bin.000001
704
71
720
730
740
751
76
77replication_applier
78localhost
79EOF
80END_OF_PROCEDURE
81
82--write_file $MYSQL_TMP_DIR/create_file_repo_with_no_require_flag_no_priv_user.inc END_OF_PROCEDURE
83  --write_file $MYSQLD_DATADIR/$filename
8410
85./slave-relay-bin.000001
864
87
880
890
900
911
92
93
94
95EOF
96END_OF_PROCEDURE
97
98--write_file $MYSQL_TMP_DIR/create_file_repo_with_no_require_flag_with_priv_user.inc END_OF_PROCEDURE
99  --write_file $MYSQLD_DATADIR/$filename
10010
101./slave-relay-bin.000001
1024
103
1040
1050
1060
1071
108
109replication_applier
110localhost
111EOF
112END_OF_PROCEDURE
113
114--write_file $MYSQL_TMP_DIR/create_file_repo_with_no_require_table_primary_key_check.inc END_OF_PROCEDURE
115  --write_file $MYSQLD_DATADIR/$filename
11611
117./slave-relay-bin.000001
1184
119
1200
1210
1220
1231
124
125root
126localhost
1270
128EOF
129END_OF_PROCEDURE
130
131--write_file $MYSQL_TMP_DIR/create_file_repo_with_invalid_require_table_primary_key_check.inc END_OF_PROCEDURE
132  --write_file $MYSQLD_DATADIR/$filename
13312
134./slave-relay-bin.000001
1354
136
1370
1380
1390
1401
141
142root
143localhost
1440
1456
146EOF
147END_OF_PROCEDURE
148
149--let $MYSQLD_DATADIR= `select @@datadir`
150--let $filename = `SELECT @@relay_log_info_file`
151
152--let $rpl_server_number = $slave_server_num
153--let $rpl_force_stop=1
154--source include/rpl_stop_server.inc
155--remove_file $MYSQLD_DATADIR/$filename
156
157if ($sub_testcase == default) {
158  --source $MYSQL_TMP_DIR/create_file_repo_with_PCU.inc
159}
160if ($sub_testcase == host_name_has_@) {
161  --source $MYSQL_TMP_DIR/create_file_repo_with_PCU_has_@.inc
162}
163if ($sub_testcase == anonymous_user) {
164  --source $MYSQL_TMP_DIR/create_file_repo_with_anon_PCU.inc
165}
166if ($sub_testcase == nonexist_user) {
167  --source $MYSQL_TMP_DIR/create_file_repo_with_nonexist_PCU.inc
168}
169if ($sub_testcase == no_flag_no_priv_user) {
170  --source $MYSQL_TMP_DIR/create_file_repo_with_no_require_flag_no_priv_user.inc
171}
172if ($sub_testcase == no_flag_with_priv_user) {
173  --source $MYSQL_TMP_DIR/create_file_repo_with_no_require_flag_with_priv_user.inc
174}
175if ($sub_testcase == no_require_table_primary_key_check) {
176  --source $MYSQL_TMP_DIR/create_file_repo_with_no_require_table_primary_key_check.inc
177}
178if ($sub_testcase == invalid_require_table_primary_key_check) {
179  --source $MYSQL_TMP_DIR/create_file_repo_with_invalid_require_table_primary_key_check.inc
180}
181
182--let $rpl_server_parameters= $rpl_server_restart_parameters
183
184--let $explicit_default_counter = 15000
185--source include/rpl_start_server.inc
186
187--remove_file $MYSQL_TMP_DIR/create_file_repo_with_no_require_flag_no_priv_user.inc
188--remove_file $MYSQL_TMP_DIR/create_file_repo_with_no_require_flag_with_priv_user.inc
189--remove_file $MYSQL_TMP_DIR/create_file_repo_with_PCU.inc
190--remove_file $MYSQL_TMP_DIR/create_file_repo_with_PCU_has_@.inc
191--remove_file $MYSQL_TMP_DIR/create_file_repo_with_anon_PCU.inc
192--remove_file $MYSQL_TMP_DIR/create_file_repo_with_nonexist_PCU.inc
193--remove_file $MYSQL_TMP_DIR/create_file_repo_with_no_require_table_primary_key_check.inc
194--remove_file $MYSQL_TMP_DIR/create_file_repo_with_invalid_require_table_primary_key_check.inc
195