Debian Codegraph @

mysql-test/suite/innodb/include/partition_upgrade.inc

raw
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