Debian Codegraph @

mysql-test/suite/mariabackup/aria_log_rotate_during_backup.test

raw
1 --source include/have_debug.inc
2 --source include/have_aria.inc
3
4 SHOW VARIABLES LIKE 'aria_log_file_size';
5
6 --let $MYSQLD_DATADIR= `select @@datadir`
7 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
8 mkdir $targetdir;
9
10
11 DELIMITER $$;
12 CREATE PROCEDURE display_aria_log_control(ctrl BLOB)
13 BEGIN
14 SELECT HEX(REVERSE(SUBSTRING(ctrl, 42, 4))) AS last_logno;
15 END;
16 $$
17 DELIMITER ;$$
18
19 DELIMITER $$;
20 CREATE PROCEDURE populate_t1()
21 BEGIN
22 FOR id IN 0..9 DO
23 INSERT INTO test.t1 (id, txt) VALUES (id, REPEAT(id,1024*1024));
24 END FOR;
25 END;
26 $$
27 DELIMITER ;$$
28
29
30 CREATE TABLE test.t1(id INT, txt LONGTEXT) ENGINE=Aria;
31
32 --echo # MYSQLD_DATADIR/aria_log_control before --backup
33 --let ARIA_DATADIR=$MYSQLD_DATADIR
34 --source include/aria_log_control_load.inc
35 CALL display_aria_log_control(@aria_log_control);
36
37 let $backuplog= $MYSQLTEST_VARDIR/tmp/backup.log;
38 --echo # Running --backup
39 --let after_scanning_log_files=CALL test.populate_t1
40 --disable_result_log
41 --exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir --dbug=+d,mariabackup_events > $backuplog
42 --let after_scanning_log_files=
43 --enable_result_log
44
45 --echo # MYSQLD_DATADIR/aria_log_control after --backup
46 --let ARIA_DATADIR=$MYSQLD_DATADIR
47 --source include/aria_log_control_load.inc
48 CALL display_aria_log_control(@aria_log_control);
49
50 --echo # targetdir/aria_log_control after --backup
51 --let ARIA_DATADIR=$targetdir
52 --source include/aria_log_control_load.inc
53 CALL display_aria_log_control(@aria_log_control);
54
55
56 --echo # Running --prepare
57 --disable_result_log
58 --exec $XTRABACKUP --prepare --target-dir=$targetdir
59 --enable_result_log
60
61 --echo # targetdir/aria_log_control after --prepare
62 --let ARIA_DATADIR=$targetdir
63 --source include/aria_log_control_load.inc
64 CALL display_aria_log_control(@aria_log_control);
65
66
67 --disable_result_log
68 --source include/restart_and_restore.inc
69 --enable_result_log
70
71 --echo # MYSQLD_DATADIR/aria_log_control after --copy-back
72 --let ARIA_DATADIR=$MYSQLD_DATADIR
73 --source include/aria_log_control_load.inc
74 CALL display_aria_log_control(@aria_log_control);
75
76 --echo # Checking that after --restore all t1 data is there
77 SELECT id, LENGTH(txt) FROM t1 ORDER BY id;
78 DROP TABLE t1;
79 rmdir $targetdir;
80 remove_file $backuplog;
81
82 DROP PROCEDURE populate_t1;
83 DROP PROCEDURE display_aria_log_control;