1--source include/have_innodb.inc
2--source include/have_debug_sync.inc
3
4CREATE TABLE t(i INT) ENGINE=INNODB;
5
6INSERT INTO t VALUES
7  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
8  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
9  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
10  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
11  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
12  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
13  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
14  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
15  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
16  (0), (1), (2), (3), (4), (5), (6), (7), (8), (9);
17--echo # Generate enough data to overwrite innodb redo log
18--echo # on the next "INSERT INTO t SELECT * FROM t" execution.
19--let $i = 0
20while ($i < 9) {
21INSERT INTO t SELECT * FROM t;
22--inc $i
23}
24
25--echo # xtrabackup backup
26--let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
27--let $backuplog=$MYSQLTEST_VARDIR/tmp/backup.log
28
29--let before_innodb_log_copy_thread_started=INSERT INTO test.t SELECT * FROM test.t
30
31--disable_result_log
32--error 1
33--exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir --dbug=+d,mariabackup_events > $backuplog
34--enable_result_log
35
36--let SEARCH_PATTERN=failed: redo log block is overwritten
37--let SEARCH_FILE=$backuplog
38--source include/search_pattern_in_file.inc
39--remove_file $backuplog
40--rmdir $targetdir
41
42--let before_innodb_log_copy_thread_started=INSERT INTO test.t VALUES (0), (1), (2), (3), (4), (5), (6), (7), (8), (9)
43
44--disable_result_log
45--error 1
46--exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir --dbug=+d,mariabackup_events,log_checksum_mismatch > $backuplog
47--enable_result_log
48
49--let SEARCH_PATTERN=failed: redo log block checksum does not match
50--let SEARCH_FILE=$backuplog
51--source include/search_pattern_in_file.inc
52--remove_file $backuplog
53--rmdir $targetdir
54
55--let before_innodb_log_copy_thread_started=INSERT INTO test.t SELECT * FROM test.t LIMIT 50000
56
57--disable_result_log
58--error 1
59--exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir --innodb-log-checksums=0 --dbug=+d,mariabackup_events  > $backuplog
60--enable_result_log
61
62--let SEARCH_PATTERN=failed: unknown reason
63--let SEARCH_FILE=$backuplog
64--source include/search_pattern_in_file.inc
65--remove_file $backuplog
66--rmdir $targetdir
67
68--let before_innodb_log_copy_thread_started=
69
70DROP TABLE t;
71