Debian Codegraph @

mysql-test/suite/innodb/r/redo_log_archive_02.result

raw
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 = '';