Debian Codegraph @

mysql-test/suite/innodb/t/redo_log_archive_05.test

raw
1 #
2 # Test the Redo-Log Archiving feature. Disk full.
3 #
4
5 if (!$IRLA_SMALL_DIR) {
6 --skip Run with env \$IRLA_SMALL_DIR set to dir with max 100MB space
7 #
8 # If the skip is skipped, fail.
9 #
10 --echo
11 --echo ######################################################################
12 --echo # THIS TEST MUST BE SKIPPED IF \$IRLA_SMALL_DIR IS NOT SET (TO A SMALL
13 --echo # FILE SYSTEM). OTHERWISE IT CANNOT REACH A DISK FULL CONDITION.
14 --echo ######################################################################
15 --echo
16 --file_exists $IRLA_SMALL_DIR
17 }
18
19 --disable_query_log
20 CALL mtr.add_suppression("Retry attempts for writing partial data failed");
21 CALL mtr.add_suppression("bytes should have been written, only");
22 CALL mtr.add_suppression("Error number .* means");
23 # When log-bin, skip-log-bin and binlog-format options are specified, mask the warning
24 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* You need to use --log-bin to make --binlog-format work.");
25 --enable_query_log
26
27 --let $saved_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
28 --let $SERVER_UUID = `SELECT @@global.server_uuid`
29 --let $IRLA_FILENAME = archive.$SERVER_UUID.000001.log
30 --let $IRLA_DIRECTORY_1 = $IRLA_SMALL_DIR/redo_log_archive.$MASTER_MYPORT
31 --let $IRLA_DIRECTORY_2 = $MYSQLTEST_VARDIR/log/redo_log_archive_2
32 --let $IRLA_PATHNAME_1 = $IRLA_DIRECTORY_1/$IRLA_FILENAME
33
34 --error 0, 1
35 --remove_file $IRLA_PATHNAME_1
36 --error 0, 1
37 --force-rmdir $IRLA_DIRECTORY_1
38
39 --echo #
40 --echo # Prepare the server for redo log archiving.
41 --echo #
42 --mkdir $IRLA_DIRECTORY_1
43 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1 $IRLA_DIRECTORY_2 IRLA_DIRECTORY_2
44 eval SET @@global.innodb_redo_log_archive_dirs = '1:$IRLA_DIRECTORY_1;2:$IRLA_DIRECTORY_2';
45 --echo
46
47 --echo #
48 --echo # Start redo log archiving
49 --echo #
50 DO innodb_redo_log_archive_start('1');
51 --echo
52
53 --echo #
54 --echo # Create a lot of InnoDB redo log.
55 --echo #
56 --disable_warnings
57 DROP DATABASE IF EXISTS db1;
58 --enable_warnings
59 CREATE DATABASE db1;
60 CREATE TABLE db1.t1(id int, b longblob) ENGINE=InnoDB;
61 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
62 DELETE FROM db1.t1;
63 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
64 DELETE FROM db1.t1;
65 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
66 DELETE FROM db1.t1;
67 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
68 DELETE FROM db1.t1;
69 INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024));
70 DELETE FROM db1.t1;
71 DROP TABLE db1.t1;
72 DROP DATABASE db1;
73 --echo
74
75 --echo #
76 --echo # Start redo log archiving after failure fails
77 --echo #
78 --replace_result $IRLA_PATHNAME_1 IRLA_PATHNAME_1
79 --error ER_INNODB_REDO_LOG_ARCHIVE_ACTIVE
80 DO innodb_redo_log_archive_start('2');
81 --echo
82
83 --echo #
84 --echo # Stop redo log archiving
85 --echo #
86 --replace_result $IRLA_PATHNAME_1 IRLA_PATHNAME_1
87 --replace_regex /offset [0-9]+/offset ###/
88 --error ER_INNODB_REDO_LOG_ARCHIVE_FAILED
89 DO innodb_redo_log_archive_stop();
90 --echo
91
92 --echo #
93 --echo # Redo log archive file does not exist any more.
94 --echo #
95 --error 1
96 --remove_file $IRLA_PATHNAME_1
97 --echo
98
99 --echo #
100 --echo # Cleanup
101 --echo #
102 --rmdir $IRLA_DIRECTORY_1
103 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_dirs';