Debian Codegraph @

mysql-test/suite/mariabackup/aria_log_dir_path.result

raw
1 #
2 # MDEV-30968 mariadb-backup does not copy Aria logs if aria_log_dir_path is used
3 #
4 # Restart mariadbd with the test specific parameters
5 # restart: --aria-log-file-size=8388608 --aria-log-purge-type=external --loose-aria-log-dir-path=MYSQLTEST_VARDIR/tmp/backup_aria_log_dir_path
6 # Create and populate an Aria table (and Aria logs)
7 CREATE TABLE t1 (id INT, txt LONGTEXT) ENGINE=Aria;
8 BEGIN NOT ATOMIC
9 FOR id IN 0..9 DO
10 INSERT INTO test.t1 (id, txt) VALUES (id, REPEAT(id,1024*1024));
11 END FOR;
12 END;
13 $$
14 # Testing aria log files before --backup
15 SET @@global.aria_checkpoint_interval=DEFAULT /*Force checkpoint*/;
16 SHOW ENGINE aria logs;
17 Type Name Status
18 Aria aria_log.00000001 free
19 Aria aria_log.00000002 in use
20 # mariadb-backup --backup
21 # mariadb-backup --prepare
22 # shutdown server
23 # remove datadir
24 # remove aria-log-dir-path
25 # mariadb-backup --copy-back
26 # with parameters: --defaults-file=MYSQLTEST_VARDIR/my.cnf --copy-back --datadir=MYSQLTEST_VARDIR/mysqld.1/data/ --target-dir=MYSQLTEST_VARDIR/tmp/backup --parallel=2 --throttle=1 --aria-log-dir-path=MYSQLTEST_VARDIR/tmp/backup_aria_log_dir_path
27 # starting server
28 # restart: --aria-log-file-size=8388608 --aria-log-purge-type=external --loose-aria-log-dir-path=MYSQLTEST_VARDIR/tmp/backup_aria_log_dir_path
29 # Check that the table is there after --copy-back
30 SELECT COUNT(*) from t1;
31 COUNT(*)
32 10
33 DROP TABLE t1;
34 # Testing aria log files after --copy-back
35 SET @@global.aria_checkpoint_interval=DEFAULT /*Force checkpoint*/;
36 SHOW ENGINE aria logs;
37 Type Name Status
38 Aria aria_log.00000002 in use
39 # Restarting mariadbd with default parameters
40 # restart