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