Debian Codegraph @

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

raw
1 #
2 # Prepare the server for redo log archiving.
3 #
4 SET @@global.innodb_redo_log_archive_dirs = '1:IRLA_DIRECTORY_1;2:IRLA_DIRECTORY_2';
5
6 #
7 # Start redo log archiving
8 #
9 DO innodb_redo_log_archive_start('1');
10
11 #
12 # Create a lot of InnoDB redo log.
13 #
14 DROP DATABASE IF EXISTS db1;
15 CREATE DATABASE db1;
16 CREATE TABLE db1.t1(id int, b longblob) ENGINE=InnoDB;
17 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
18 DELETE FROM db1.t1;
19 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
20 DELETE FROM db1.t1;
21 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
22 DELETE FROM db1.t1;
23 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
24 DELETE FROM db1.t1;
25 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
26 DELETE FROM db1.t1;
27 DROP TABLE db1.t1;
28 DROP DATABASE db1;
29
30 #
31 # Start redo log archiving after failure fails
32 #
33 DO innodb_redo_log_archive_start('2');
34 ERROR HY000: Redo log archiving has been started on 'IRLA_PATHNAME_1' - Call innodb_redo_log_archive_stop() first
35
36 #
37 # Stop redo log archiving
38 #
39 DO innodb_redo_log_archive_stop();
40 ERROR HY000: Redo log archiving failed: Cannot write to file 'IRLA_PATHNAME_1' at offset ### (OS errno: 28 - No space left on device) - stopped redo log archiving and deleted the file.
41
42 #
43 # Redo log archive file does not exist any more.
44 #
45
46 #
47 # Cleanup
48 #
49 SET @@global.innodb_redo_log_archive_dirs = '';