| 1 |
# |
| 2 |
# Call innodb_redo_log_archive_start() and -stop() with wrong parameters. |
| 3 |
# |
| 4 |
DO innodb_redo_log_archive_start(); |
| 5 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_start'; Invalid number of arguments. |
| 6 |
DO innodb_redo_log_archive_start(NULL); |
| 7 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_start'; First argument must not be null. |
| 8 |
DO innodb_redo_log_archive_start(1); |
| 9 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_start'; Invalid first argument type. |
| 10 |
DO innodb_redo_log_archive_start('', 1); |
| 11 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_start'; Invalid second argument type. |
| 12 |
DO innodb_redo_log_archive_start('', '', ''); |
| 13 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_start'; Invalid number of arguments. |
| 14 |
DO innodb_redo_log_archive_stop(NULL); |
| 15 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_stop'; Invalid number of arguments. |
| 16 |
DO innodb_redo_log_archive_stop(1); |
| 17 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_stop'; Invalid number of arguments. |
| 18 |
DO innodb_redo_log_archive_stop(''); |
| 19 |
ERROR HY000: Can't initialize function 'innodb_redo_log_archive_stop'; Invalid number of arguments. |
| 20 |
|
| 21 |
# |
| 22 |
# Unprivileged user cannot start nor stop redo log archiving. |
| 23 |
# |
| 24 |
CREATE USER mysqltest_u1@localhost; |
| 25 |
[connection mysqltest_u1] |
| 26 |
DO innodb_redo_log_archive_start('label1'); |
| 27 |
ERROR 42000: Access denied; you need (at least one of) the INNODB_REDO_LOG_ARCHIVE privilege(s) for this operation |
| 28 |
DO innodb_redo_log_archive_stop(); |
| 29 |
ERROR 42000: Access denied; you need (at least one of) the INNODB_REDO_LOG_ARCHIVE privilege(s) for this operation |
| 30 |
[connection default] |
| 31 |
DROP USER mysqltest_u1@localhost; |
| 32 |
|
| 33 |
# |
| 34 |
# NULL innodb_redo_log_archive_dirs. |
| 35 |
# |
| 36 |
SET @@global.innodb_redo_log_archive_dirs = NULL; |
| 37 |
DO innodb_redo_log_archive_start('label1'); |
| 38 |
ERROR HY000: Server variable 'innodb_redo_log_archive_dirs' is NULL or empty |
| 39 |
|
| 40 |
# |
| 41 |
# Empty innodb_redo_log_archive_dirs. |
| 42 |
# |
| 43 |
SET @@global.innodb_redo_log_archive_dirs = ''; |
| 44 |
DO innodb_redo_log_archive_start('label1'); |
| 45 |
ERROR HY000: Server variable 'innodb_redo_log_archive_dirs' is NULL or empty |
| 46 |
|
| 47 |
# |
| 48 |
# Non-existen label. |
| 49 |
# |
| 50 |
SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1'; |
| 51 |
DO innodb_redo_log_archive_start('no-such-label'); |
| 52 |
ERROR HY000: Label 'no-such-label' not found in server variable 'innodb_redo_log_archive_dirs' |
| 53 |
|
| 54 |
# |
| 55 |
# Subdir with path separator. |
| 56 |
# |
| 57 |
SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1'; |
| 58 |
DO innodb_redo_log_archive_start('label1', 'tmp/tmp'); |
| 59 |
ERROR HY000: Redo log archiving start prohibits path name in 'subdir' argument |
| 60 |
|
| 61 |
# |
| 62 |
# Directory does not exist. |
| 63 |
# |
| 64 |
SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1'; |
| 65 |
DO innodb_redo_log_archive_start('label1'); |
| 66 |
ERROR HY000: Redo log archive directory 'IRLA_DIRECTORY_1' does not exist or is not a directory |
| 67 |
|
| 68 |
# |
| 69 |
# Directory is a file. |
| 70 |
# |
| 71 |
SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1'; |
| 72 |
DO innodb_redo_log_archive_start('label1'); |
| 73 |
ERROR HY000: Redo log archive directory 'IRLA_DIRECTORY_1' does not exist or is not a directory |
| 74 |
|
| 75 |
# |
| 76 |
# Directory clashes with server directories. |
| 77 |
# |
| 78 |
# Stop server |
| 79 |
# |
| 80 |
# |
| 81 |
# Select unique path names for the server directories |
| 82 |
# |
| 83 |
# |
| 84 |
# Precautionary cleanup of the new server directories |
| 85 |
# |
| 86 |
# |
| 87 |
# Create the new server directories |
| 88 |
# |
| 89 |
# |
| 90 |
# Move files from the default directories to the new server directories |
| 91 |
# |
| 92 |
# |
| 93 |
# Restart the server with the new server directories |
| 94 |
# |
| 95 |
# |
| 96 |
# Set innodb_redo_log_archive_dirs to the server directories |
| 97 |
# |
| 98 |
|
| 99 |
|
| 100 |
SET @@global.innodb_redo_log_archive_dirs = '1:MYSQLTEST_VARDIR/mysqld.1/data//xxx;2:MYSQLTEST_VARDIR/log/innodb_data_home_dir/xxx;3:MYSQLTEST_VARDIR/log/innodb_directories;4:MYSQLTEST_VARDIR/log/innodb_log_group_home_dir;5:MYSQLTEST_VARDIR/log/innodb_temp_tablespaces_dir;6:MYSQLTEST_VARDIR/log/tmp;7:MYSQLTEST_VARDIR/log/tmp/innodb_tmpdir/xxx;8:MYSQLTEST_VARDIR/log/innodb_undo_directory;9:SECURE_FILE_PRIV/xxx'; |
| 101 |
# |
| 102 |
# Try to start redo log archiving with each of the server directories |
| 103 |
# |
| 104 |
DO innodb_redo_log_archive_start('1'); |
| 105 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/mysqld.1/data//xxx' is in, under, or over server directory 'datadir' - 'MYSQLTEST_VARDIR/mysqld.1/data/' |
| 106 |
DO innodb_redo_log_archive_start('2'); |
| 107 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/innodb_data_home_dir/xxx' is in, under, or over server directory 'innodb_data_home_dir' - 'MYSQLTEST_VARDIR/log/innodb_data_home_dir/' |
| 108 |
DO innodb_redo_log_archive_start('3'); |
| 109 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/innodb_directories' is in, under, or over server directory 'innodb_directories' - 'MYSQLTEST_VARDIR/log/innodb_directories/' |
| 110 |
DO innodb_redo_log_archive_start('4'); |
| 111 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/innodb_log_group_home_dir' is in, under, or over server directory 'innodb_log_group_home_dir' - 'MYSQLTEST_VARDIR/log/innodb_log_group_home_dir/' |
| 112 |
DO innodb_redo_log_archive_start('5'); |
| 113 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/innodb_temp_tablespaces_dir' is in, under, or over server directory 'innodb_temp_tablespaces_dir' - 'MYSQLTEST_VARDIR/log/innodb_temp_tablespaces_dir/' |
| 114 |
DO innodb_redo_log_archive_start('6'); |
| 115 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/tmp' is in, under, or over server directory 'innodb_tmpdir' - 'MYSQLTEST_VARDIR/log/tmp/innodb_tmpdir/' |
| 116 |
DO innodb_redo_log_archive_start('7'); |
| 117 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/tmp/innodb_tmpdir/xxx' is in, under, or over server directory 'innodb_tmpdir' - 'MYSQLTEST_VARDIR/log/tmp/innodb_tmpdir/' |
| 118 |
DO innodb_redo_log_archive_start('8'); |
| 119 |
ERROR HY000: Redo log archive directory 'MYSQLTEST_VARDIR/log/innodb_undo_directory' is in, under, or over server directory 'innodb_undo_directory' - 'MYSQLTEST_VARDIR/log/innodb_undo_directory/' |
| 120 |
DO innodb_redo_log_archive_start('9'); |
| 121 |
ERROR HY000: Redo log archive directory 'SECURE_FILE_PRIV/xxx' is in, under, or over server directory 'secure_file_priv' - 'SECURE_FILE_PRIV' |
| 122 |
# |
| 123 |
# Stop server |
| 124 |
# |
| 125 |
# |
| 126 |
# Move files back to the default directories |
| 127 |
# |
| 128 |
# |
| 129 |
# Remove the new server directories |
| 130 |
# |
| 131 |
# |
| 132 |
# Restart the server with default directories |
| 133 |
# |
| 134 |
|
| 135 |
# |
| 136 |
# Set innodb_redo_log_archive_dirs for the following tests. |
| 137 |
# |
| 138 |
SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1;label2:IRLA_DIRECTORY_2'; |
| 139 |
|
| 140 |
# |
| 141 |
# Create the redo log archive directory for the following tests. |
| 142 |
# |
| 143 |
|
| 144 |
# |
| 145 |
# Create connection con1 for the following tests. |
| 146 |
# |
| 147 |
|
| 148 |
# |
| 149 |
# Start with active logging. |
| 150 |
# |
| 151 |
DO innodb_redo_log_archive_start('label1'); |
| 152 |
DO innodb_redo_log_archive_start('label1'); |
| 153 |
ERROR HY000: Redo log archiving has been started on 'IRLA_PATHNAME_1' - Call innodb_redo_log_archive_stop() first |
| 154 |
DO innodb_redo_log_archive_stop(); |
| 155 |
|
| 156 |
# |
| 157 |
# Stop with inactive logging. |
| 158 |
# |
| 159 |
DO innodb_redo_log_archive_stop(); |
| 160 |
ERROR HY000: Redo log archiving is not active |
| 161 |
|
| 162 |
# |
| 163 |
# Start with active logging from other session. |
| 164 |
# |
| 165 |
DO innodb_redo_log_archive_start('label1'); |
| 166 |
[connection con1] |
| 167 |
DO innodb_redo_log_archive_start('label2'); |
| 168 |
ERROR HY000: Redo log archiving has been started on 'IRLA_PATHNAME_1' - Call innodb_redo_log_archive_stop() first |
| 169 |
[connection default] |
| 170 |
DO innodb_redo_log_archive_stop(); |
| 171 |
|
| 172 |
# |
| 173 |
# Stop from wrong session |
| 174 |
# |
| 175 |
DO innodb_redo_log_archive_start('label1'); |
| 176 |
[connection con1] |
| 177 |
DO innodb_redo_log_archive_stop(); |
| 178 |
ERROR HY000: Redo log archiving has not been started by this session |
| 179 |
[connection default] |
| 180 |
DO innodb_redo_log_archive_stop(); |
| 181 |
|
| 182 |
# |
| 183 |
# Session ends without stop |
| 184 |
# |
| 185 |
[connection con1] |
| 186 |
DO innodb_redo_log_archive_start('label1'); |
| 187 |
# Redo log archive file exists |
| 188 |
# |
| 189 |
# Disconnect con1 |
| 190 |
# |
| 191 |
[connection default] |
| 192 |
# Redo log archive file does not exist any more |
| 193 |
|
| 194 |
# |
| 195 |
# Stop after error - reports the previous error |
| 196 |
# |
| 197 |
DO innodb_redo_log_archive_stop(); |
| 198 |
ERROR HY000: Redo log archiving failed: Session terminated with active redo log archiving - stopped redo log archiving and deleted the file. |
| 199 |
|
| 200 |
# |
| 201 |
# File exists |
| 202 |
# |
| 203 |
# Create a file with the name of the redo log archive file |
| 204 |
# |
| 205 |
DO innodb_redo_log_archive_start('label1'); |
| 206 |
ERROR HY000: Cannot create redo log archive file 'IRLA_PATHNAME_1' (OS errno: ## - ###) |
| 207 |
|
| 208 |
# |
| 209 |
# Call redo log archiving start & stop repeatedly |
| 210 |
# This could catch race conditions between start and stop. |
| 211 |
# |
| 212 |
DO innodb_redo_log_archive_start("label1"); |
| 213 |
DO innodb_redo_log_archive_stop(); |
| 214 |
DO innodb_redo_log_archive_start("label1"); |
| 215 |
DO innodb_redo_log_archive_stop(); |
| 216 |
DO innodb_redo_log_archive_start("label1"); |
| 217 |
DO innodb_redo_log_archive_stop(); |
| 218 |
DO innodb_redo_log_archive_start("label1"); |
| 219 |
DO innodb_redo_log_archive_stop(); |
| 220 |
DO innodb_redo_log_archive_start("label1"); |
| 221 |
DO innodb_redo_log_archive_stop(); |
| 222 |
DO innodb_redo_log_archive_start("label1"); |
| 223 |
DO innodb_redo_log_archive_stop(); |
| 224 |
DO innodb_redo_log_archive_start("label1"); |
| 225 |
DO innodb_redo_log_archive_stop(); |
| 226 |
DO innodb_redo_log_archive_start("label1"); |
| 227 |
DO innodb_redo_log_archive_stop(); |
| 228 |
DO innodb_redo_log_archive_start("label1"); |
| 229 |
DO innodb_redo_log_archive_stop(); |
| 230 |
DO innodb_redo_log_archive_start("label1"); |
| 231 |
DO innodb_redo_log_archive_stop(); |
| 232 |
DO innodb_redo_log_archive_start("label1"); |
| 233 |
DO innodb_redo_log_archive_stop(); |
| 234 |
DO innodb_redo_log_archive_start("label1"); |
| 235 |
DO innodb_redo_log_archive_stop(); |
| 236 |
DO innodb_redo_log_archive_start("label1"); |
| 237 |
DO innodb_redo_log_archive_stop(); |
| 238 |
DO innodb_redo_log_archive_start("label1"); |
| 239 |
DO innodb_redo_log_archive_stop(); |
| 240 |
DO innodb_redo_log_archive_start("label1"); |
| 241 |
DO innodb_redo_log_archive_stop(); |
| 242 |
DO innodb_redo_log_archive_start("label1"); |
| 243 |
DO innodb_redo_log_archive_stop(); |
| 244 |
DO innodb_redo_log_archive_start("label1"); |
| 245 |
DO innodb_redo_log_archive_stop(); |
| 246 |
DO innodb_redo_log_archive_start("label1"); |
| 247 |
DO innodb_redo_log_archive_stop(); |
| 248 |
DO innodb_redo_log_archive_start("label1"); |
| 249 |
DO innodb_redo_log_archive_stop(); |
| 250 |
DO innodb_redo_log_archive_start("label1"); |
| 251 |
DO innodb_redo_log_archive_stop(); |
| 252 |
|
| 253 |
# |
| 254 |
# Try to disable redo logging from other session. |
| 255 |
# |
| 256 |
DO innodb_redo_log_archive_start('label1'); |
| 257 |
|
| 258 |
ALTER INSTANCE DISABLE INNODB REDO_LOG; |
| 259 |
ERROR HY000: Cannot perform operation as InnoDB is archiving redo log. Please retry after stopping redo archive by invoking innodb_redo_log_archive_stop() |
| 260 |
|
| 261 |
SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled'; |
| 262 |
VARIABLE_NAME VARIABLE_VALUE |
| 263 |
Innodb_redo_log_enabled ON |
| 264 |
|
| 265 |
DO innodb_redo_log_archive_stop(); |
| 266 |
|
| 267 |
# |
| 268 |
# Try to start redo archiving when Innodb redo logging is diabled |
| 269 |
# |
| 270 |
ALTER INSTANCE DISABLE INNODB REDO_LOG; |
| 271 |
|
| 272 |
SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled'; |
| 273 |
VARIABLE_NAME VARIABLE_VALUE |
| 274 |
Innodb_redo_log_enabled OFF |
| 275 |
|
| 276 |
DO innodb_redo_log_archive_start('label1'); |
| 277 |
ERROR HY000: Cannot perform operation as InnoDB redo logging is disabled. Please retry after enabling redo log with ALTER INSTANCE |
| 278 |
|
| 279 |
ALTER INSTANCE ENABLE INNODB REDO_LOG; |
| 280 |
|
| 281 |
SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled'; |
| 282 |
VARIABLE_NAME VARIABLE_VALUE |
| 283 |
Innodb_redo_log_enabled ON |
| 284 |
|
| 285 |
# |
| 286 |
# Cleanup |
| 287 |
# |
| 288 |
SET @@global.innodb_redo_log_archive_dirs = ''; |