| 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=../../tmp/backup_aria_log_dir_path_rel |
| 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=../../tmp/backup_aria_log_dir_path_rel |
| 27 |
# starting server |
| 28 |
# restart: --aria-log-file-size=8388608 --aria-log-purge-type=external --loose-aria-log-dir-path=../../tmp/backup_aria_log_dir_path_rel |
| 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 |