| 1 |
# WL 13352: Test Upgrade of partitioned tables from different versions |
| 2 |
# Caller need to set OLD_VERSION: 5727, 8013, 8015, 8017, 8019 |
| 3 |
# OLD_LCTN: 0,1,2 [lower_case_table_names] |
| 4 |
# OLD_PLATFORM: lin, win, mac [linux/windows/mac] |
| 5 |
|
| 6 |
# To disable external file path |
| 7 |
# --let $NO_EXT_PATH = 1 |
| 8 |
|
| 9 |
# To Enable fixed path for external files |
| 10 |
# --let $IS_FIXED_PATH = 1 |
| 11 |
|
| 12 |
--echo # Test Upgrade from old version $OLD_VERSION |
| 13 |
|
| 14 |
--source include/have_innodb_16k.inc |
| 15 |
--source include/not_valgrind.inc |
| 16 |
|
| 17 |
# For all other versions we run only on case sensitive fs |
| 18 |
if ($OLD_VERSION != 8019) { |
| 19 |
if ($OLD_VERSION != 5727) { |
| 20 |
--source include/have_case_sensitive_file_system.inc |
| 21 |
--let $OLD_LCTN = 1 |
| 22 |
} |
| 23 |
} |
| 24 |
|
| 25 |
--let $OLD_EXTN = $OLD_VERSION |
| 26 |
--let $LCTN = --lower_case_table_names=$OLD_LCTN |
| 27 |
|
| 28 |
# lower_case_table_names = 0 is supported only on case sensitive fs |
| 29 |
if ($OLD_LCTN == 0) { |
| 30 |
--source include/have_case_sensitive_file_system.inc |
| 31 |
} |
| 32 |
|
| 33 |
# lower_case_table_names = 2 is supported only on case sensitive fs |
| 34 |
if ($OLD_LCTN == 2) { |
| 35 |
--source include/have_case_insensitive_file_system.inc |
| 36 |
} |
| 37 |
|
| 38 |
if ($OLD_VERSION == 5727) |
| 39 |
{ |
| 40 |
# By default skip external directory for 5.7 |
| 41 |
--let $NO_EXT_PATH = 1 |
| 42 |
|
| 43 |
# 5.7 upgrade not supported across platforms |
| 44 |
if ($OLD_PLATFORM == win) |
| 45 |
{ |
| 46 |
--source include/windows.inc |
| 47 |
} |
| 48 |
|
| 49 |
if ($OLD_PLATFORM == mac) |
| 50 |
{ |
| 51 |
--source include/have_mac_os.inc |
| 52 |
} |
| 53 |
|
| 54 |
if ($OLD_PLATFORM == lin) |
| 55 |
{ |
| 56 |
--source include/have_case_sensitive_file_system.inc |
| 57 |
} |
| 58 |
--let $OLD_EXTN = `select concat("$OLD_VERSION", "_", "$OLD_PLATFORM", "_lctn_", "$OLD_LCTN")` |
| 59 |
} |
| 60 |
|
| 61 |
# Check migration across platforms for 8.0.19 |
| 62 |
if ($OLD_VERSION == 8019) |
| 63 |
{ |
| 64 |
--let $OLD_EXTN = `select concat("$OLD_VERSION", "_", "$OLD_PLATFORM", "_lctn_", "$OLD_LCTN")` |
| 65 |
--let EXTRA_TABLES = 1 |
| 66 |
} |
| 67 |
|
| 68 |
--echo # Stop DB server which was created by MTR default |
| 69 |
--source include/shutdown_mysqld.inc |
| 70 |
|
| 71 |
--let $EXTERNAL_DIR_NAME= mysql_wl13352_data |
| 72 |
|
| 73 |
# For manual upgrade testing with absolute path to match across setup |
| 74 |
if ($IS_FIXED_PATH) |
| 75 |
{ |
| 76 |
--let $EXTERNAL_DIRECTORY = /tmp/$EXTERNAL_DIR_NAME/ |
| 77 |
--let $UNZIP_DIR = / |
| 78 |
} |
| 79 |
|
| 80 |
if (!$IS_FIXED_PATH) |
| 81 |
{ |
| 82 |
--let $EXTERNAL_DIRECTORY = $MYSQL_TMP_DIR/tmp/$EXTERNAL_DIR_NAME/ |
| 83 |
--let $UNZIP_DIR = $MYSQL_TMP_DIR |
| 84 |
} |
| 85 |
|
| 86 |
# Cleanup external directory |
| 87 |
--error 0, 1 |
| 88 |
--force-rmdir $EXTERNAL_DIRECTORY |
| 89 |
|
| 90 |
--echo # Copy and unzip old version data directory. |
| 91 |
--copy_file $MYSQLTEST_VARDIR/std_data/upgrade/data_wl13352_$OLD_EXTN.zip $MYSQL_TMP_DIR/data_upgrade.zip |
| 92 |
--file_exists $MYSQL_TMP_DIR/data_upgrade.zip |
| 93 |
--exec unzip -qo $MYSQL_TMP_DIR/data_upgrade.zip -d $MYSQL_TMP_DIR |
| 94 |
--remove_file $MYSQL_TMP_DIR/data_upgrade.zip |
| 95 |
|
| 96 |
if (!$NO_EXT_PATH) |
| 97 |
{ |
| 98 |
--echo # Copy and unzip external directory |
| 99 |
--copy_file $MYSQLTEST_VARDIR/std_data/upgrade/extn_wl13352_$OLD_EXTN.zip $MYSQL_TMP_DIR/data_extn.zip |
| 100 |
--file_exists $MYSQL_TMP_DIR/data_extn.zip |
| 101 |
--exec unzip -qo $MYSQL_TMP_DIR/data_extn.zip -d $UNZIP_DIR |
| 102 |
--remove_file $MYSQL_TMP_DIR/data_extn.zip |
| 103 |
} |
| 104 |
|
| 105 |
let $MYSQLD_DATADIR_UPGRADE = $MYSQL_TMP_DIR/data_upgrade; |
| 106 |
--echo List all files before upgrade |
| 107 |
--echo ----------------------------- |
| 108 |
--list_files $MYSQLD_DATADIR_UPGRADE/test |
| 109 |
|
| 110 |
if (!$NO_EXT_PATH) |
| 111 |
{ |
| 112 |
--echo |
| 113 |
--echo List all files in external directory |
| 114 |
--echo ------------------------------------ |
| 115 |
--list_files $EXTERNAL_DIRECTORY/test |
| 116 |
|
| 117 |
--echo |
| 118 |
--echo List files outside database directory (empty) |
| 119 |
--echo --------------------------------------------- |
| 120 |
--list_files $EXTERNAL_DIRECTORY |
| 121 |
} |
| 122 |
|
| 123 |
--echo |
| 124 |
--echo # Upgrade to latest mysql version |
| 125 |
let $MYSQLD_LOG= $MYSQLTEST_VARDIR/log/mysqld_upgrade.log; |
| 126 |
|
| 127 |
if ($NO_EXT_PATH) { |
| 128 |
--replace_result $MYSQLD MYSQLD $MYSQLD_DATADIR_UPGRADE MYSQLD_DATADIR_UPGRADE $MYSQLD_LOG MYSQLD_LOG |
| 129 |
--exec echo "restart: --datadir=$MYSQLD_DATADIR_UPGRADE $LCTN --log-error=$MYSQLD_LOG" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect |
| 130 |
} |
| 131 |
|
| 132 |
if (!$NO_EXT_PATH) { |
| 133 |
--replace_result $MYSQLD MYSQLD $MYSQLD_DATADIR_UPGRADE MYSQLD_DATADIR_UPGRADE $MYSQLD_LOG MYSQLD_LOG $EXTERNAL_DIRECTORY EXTERNAL_DIRECTORY |
| 134 |
--exec echo "restart: --datadir=$MYSQLD_DATADIR_UPGRADE $LCTN --innodb_directories=$EXTERNAL_DIRECTORY --log-error=$MYSQLD_LOG" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect |
| 135 |
} |
| 136 |
|
| 137 |
--let $wait_counter= 10000 |
| 138 |
|
| 139 |
# Additional wait for 30 minutes for valgrid run |
| 140 |
--let add_wait_counter= 18000 |
| 141 |
|
| 142 |
--enable_reconnect |
| 143 |
--source include/wait_until_connected_again.inc |
| 144 |
|
| 145 |
--echo |
| 146 |
--echo List all files of upgraded data |
| 147 |
--echo ------------------------------- |
| 148 |
--list_files $MYSQLD_DATADIR_UPGRADE/test |
| 149 |
|
| 150 |
if (!$NO_EXT_PATH) |
| 151 |
{ |
| 152 |
--echo |
| 153 |
--echo List all files in external directory |
| 154 |
--echo ------------------------------------ |
| 155 |
--list_files $EXTERNAL_DIRECTORY/test |
| 156 |
|
| 157 |
--echo |
| 158 |
--echo List files outside database directory (empty) |
| 159 |
--echo --------------------------------------------- |
| 160 |
--list_files $EXTERNAL_DIRECTORY |
| 161 |
} |
| 162 |
|
| 163 |
--echo |
| 164 |
--echo # A. Validate upgraded tables and data |
| 165 |
|
| 166 |
--let $i = 0 |
| 167 |
|
| 168 |
while($i < 2) |
| 169 |
{ |
| 170 |
--echo # 1. Check table metadata and data |
| 171 |
--let $check_option = CHECK |
| 172 |
--source partition_upgrade_check.inc |
| 173 |
|
| 174 |
--echo # 2. Do DML insert/update/delete on upgraded tables |
| 175 |
--let $check_option = DML |
| 176 |
--source partition_upgrade_check.inc |
| 177 |
|
| 178 |
--echo # 3. Do DDL ALTER/DROP on upgraded tables |
| 179 |
--let $check_option = DDL |
| 180 |
--source partition_upgrade_check.inc |
| 181 |
|
| 182 |
if ($i == 0) { |
| 183 |
--echo |
| 184 |
--echo # B. Create all the tables again and validate |
| 185 |
--let $check_option = DROP |
| 186 |
--source partition_upgrade_check.inc |
| 187 |
--let $check_option = CREATE |
| 188 |
--source partition_upgrade_check.inc |
| 189 |
--echo |
| 190 |
} |
| 191 |
--inc $i |
| 192 |
} |
| 193 |
|
| 194 |
--echo |
| 195 |
--echo # Shutdown server |
| 196 |
--source include/shutdown_mysqld.inc |
| 197 |
|
| 198 |
--echo |
| 199 |
--echo # Remove upgraded data directory. |
| 200 |
--force-rmdir $MYSQL_TMP_DIR/data_upgrade |
| 201 |
|
| 202 |
if (!$NO_EXT_PATH) |
| 203 |
{ |
| 204 |
--force-rmdir $EXTERNAL_DIRECTORY |
| 205 |
|
| 206 |
if (!$IS_FIXED_PATH) |
| 207 |
{ |
| 208 |
--force-rmdir $MYSQL_TMP_DIR/tmp |
| 209 |
} |
| 210 |
} |
| 211 |
|
| 212 |
--echo |
| 213 |
--echo # Cleanup: Restart with default options. |
| 214 |
--let $restart_parameters = |
| 215 |
--source include/start_mysqld.inc |