Debian Codegraph @

mysql-test/suite/mariabackup/innodb_force_recovery.test

raw
1 # This test checks if "innodb_force_recovery" is only allowed with "--prepare"
2 # (for mariabackup) and "--apply-log" (for innobackupex), and is limited to
3 # "SRV_FORCE_IGNORE_CORRUPT" only.
4
5 # Setup.
6 --source include/have_innodb.inc
7
8 --let targetdir=$MYSQLTEST_VARDIR/tmp/backup
9 --let backuplog=$MYSQLTEST_VARDIR/tmp/backup.log
10
11 CREATE TABLE t(i INT) ENGINE INNODB;
12 INSERT INTO t VALUES(1);
13
14 # Check for command line arguments.
15 --echo # "innodb_force_recovery=1" should be allowed with "--prepare" only (mariabackup)
16 --disable_result_log
17 --error 1
18 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --innodb-force-recovery=1 --target-dir=$targetdir >$backuplog;
19 --enable_result_log
20 --let SEARCH_PATTERN=should only be used with "--prepare"
21 --let SEARCH_FILE=$backuplog
22 --source include/search_pattern_in_file.inc
23
24 --echo # "innodb_force_recovery=1" should be allowed with "--apply-log" only (innobackupex)
25 --disable_result_log
26 --error 1
27 exec $XTRABACKUP --innobackupex --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp --innodb-force-recovery=1 $targetdir >$backuplog;
28 --enable_result_log
29 --let SEARCH_PATTERN=should only be used with "--apply-log"
30 --let SEARCH_FILE=$backuplog
31 --source include/search_pattern_in_file.inc
32
33 --disable_result_log
34 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
35 --enable_result_log
36 --echo # "innodb_force_recovery" should be limited to "SRV_FORCE_IGNORE_CORRUPT" (mariabackup)
37 --disable_result_log
38 exec $XTRABACKUP --prepare --innodb-force-recovery=2 --target-dir=$targetdir >$backuplog;
39 --enable_result_log
40 --let SEARCH_PATTERN=innodb_force_recovery = 1
41 --let SEARCH_FILE=$backuplog
42 --source include/search_pattern_in_file.inc
43 rmdir $targetdir;
44
45 --disable_result_log
46 exec $XTRABACKUP --innobackupex --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;
47 --enable_result_log
48 --echo # "innodb_force_recovery" should be limited to "SRV_FORCE_IGNORE_CORRUPT" (innobackupex)
49 --disable_result_log
50 exec $XTRABACKUP --innobackupex --apply-log --innodb-force-recovery=2 $targetdir >$backuplog;
51 --enable_result_log
52 --let SEARCH_PATTERN=innodb_force_recovery = 1
53 --let SEARCH_FILE=$backuplog
54 --source include/search_pattern_in_file.inc
55 --echo #
56 --echo # This fragment was added for MDEV-31505 Deprecate mariabackup --innobackupex mode
57 --echo #
58 --let SEARCH_PATTERN=Deprecated program name
59 --source include/search_pattern_in_file.inc
60 --let SEARCH_PATTERN=[-][-]innobackupex.*is deprecated and will be removed in a future release
61 --source include/search_pattern_in_file.inc
62 --echo #
63 --echo # End of the MDEV-31505 fragment
64 --echo #
65 rmdir $targetdir;
66
67 # Check for default file ("backup-my.cnf").
68 --disable_result_log
69 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
70 --enable_result_log
71 perl;
72 my $cfg_path="$ENV{'targetdir'}/backup-my.cnf";
73 open(my $fd, '>>', "$cfg_path");
74 print $fd "innodb_force_recovery=1\n";
75 close $fd;
76 EOF
77 --echo # "innodb_force_recovery" should be read from "backup-my.cnf" (mariabackup)
78 --disable_result_log
79 exec $XTRABACKUP --defaults-file=$targetdir/backup-my.cnf --prepare --export --target-dir=$targetdir >$backuplog;
80 --enable_result_log
81 --let SEARCH_PATTERN=innodb_force_recovery = 1
82 --let SEARCH_FILE=$backuplog
83 --source include/search_pattern_in_file.inc
84 rmdir $targetdir;
85
86 --disable_result_log
87 exec $XTRABACKUP --innobackupex --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;
88 --enable_result_log
89 perl;
90 my $cfg_path="$ENV{'targetdir'}/backup-my.cnf";
91 open(my $fd, '>>', "$cfg_path");
92 print $fd "innodb_force_recovery=2\n";
93 close $fd;
94 EOF
95 --echo # "innodb_force_recovery=1" should be read from "backup-my.cnf" (innobackupex)
96 --disable_result_log
97 exec $XTRABACKUP --innobackupex --defaults-file=$targetdir/backup-my.cnf --apply-log --export $targetdir >$backuplog;
98 --enable_result_log
99 --let SEARCH_PATTERN=innodb_force_recovery = 1
100 --let SEARCH_FILE=$backuplog
101 --source include/search_pattern_in_file.inc
102 rmdir $targetdir;
103
104 # Check for command line argument precedence.
105 --disable_result_log
106 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
107 --enable_result_log
108 perl;
109 my $cfg_path="$ENV{'targetdir'}/backup-my.cnf";
110 open(my $fd, '>>', "$cfg_path");
111 print $fd "innodb_force_recovery=1\n";
112 close $fd;
113 EOF
114 --echo # "innodb_force_recovery" from the command line should override "backup-my.cnf" (mariabackup)
115 --disable_result_log
116 exec $XTRABACKUP --defaults-file=$targetdir/backup-my.cnf --prepare --innodb-force-recovery=0 --target-dir=$targetdir >$backuplog;
117 --enable_result_log
118 --let SEARCH_PATTERN=innodb_force_recovery = 1
119 --let SEARCH_FILE=$backuplog
120 --source include/search_pattern_in_file.inc
121 rmdir $targetdir;
122
123 --disable_result_log
124 exec $XTRABACKUP --innobackupex --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;
125 --enable_result_log
126 perl;
127 my $cfg_path="$ENV{'targetdir'}/backup-my.cnf";
128 open(my $fd, '>>', "$cfg_path");
129 print $fd "innodb_force_recovery=2\n";
130 close $fd;
131 EOF
132 --echo # "innodb_force_recovery" from the command line should override "backup-my.cnf" (innobackupex)
133 --disable_result_log
134 exec $XTRABACKUP --innobackupex --defaults-file=$targetdir/backup-my.cnf --apply-log --innodb-force-recovery=0 --export $targetdir >$backuplog;
135 --enable_result_log
136 --let SEARCH_PATTERN=innodb_force_recovery = 1
137 --let SEARCH_FILE=$backuplog
138 --source include/search_pattern_in_file.inc
139
140 --source include/restart_and_restore.inc
141
142 # Check for restore.
143 SELECT * FROM t;
144
145 # Clean-up.
146 DROP TABLE t;
147 --rmdir $targetdir
148 --remove_file $backuplog