mirror of
https://github.com/MariaDB/server.git
synced 2025-04-04 22:35:33 +02:00
2469963f05
- During prepare of incremental backup, mariabackup does create new file in target directory with default file size of 4 * innodb_page_size. While applying .delta file to corresponding data file, it encounters the FSP_SIZE modification on page0 and tries to extend the file to the size which is 4 in our case. Since the table is in compressed row format, page_size for the table is 8k. This lead to shrinking of tablespace file from 65536 to 32768. This issue happens only in windows because os_file_set_size() doesn't check for the current size and shrinks the file. Solution: ======== xtrabackup_apply_delta(): Check for the current size before doing setting size for the file.
33 lines
1.3 KiB
Text
33 lines
1.3 KiB
Text
--source include/have_innodb.inc
|
|
--source include/have_partition.inc
|
|
--source include/innodb_undo_tablespaces.inc
|
|
|
|
let $basedir=$MYSQLTEST_VARDIR/tmp/backup;
|
|
let $incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1;
|
|
|
|
--echo #
|
|
--echo # MDEV-18589 Assertion ...physical_size(flags) == info.page_size
|
|
--echo # failed in xb_delta_open_matching_space
|
|
--echo #
|
|
|
|
CREATE TABLE t (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
|
|
|
|
--exec $XTRABACKUP --backup --target-dir=$basedir --protocol=tcp --port=$MASTER_MYPORT --user=root
|
|
|
|
ALTER TABLE t PARTITION BY KEY(pk);
|
|
|
|
--echo # Incremental backup
|
|
--exec $XTRABACKUP --backup --target-dir=$incremental_dir --incremental-basedir=$basedir --protocol=tcp --port=$MASTER_MYPORT --user=root > $incremental_dir.log 2>&1
|
|
--echo # Prepare fullbackup
|
|
--exec $XTRABACKUP --prepare --target-dir=$basedir --user=root > $MYSQL_TMP_DIR/backup_prepare_0.log 2>&1
|
|
--echo # Prepare incremental backup
|
|
--exec $XTRABACKUP --prepare --target-dir=$basedir --incremental-dir=$incremental_dir --user=root > $MYSQL_TMP_DIR/backup_prepare_1.log 2>&1
|
|
let $targetdir=$basedir;
|
|
-- source include/restart_and_restore.inc
|
|
SHOW CREATE TABLE t;
|
|
DROP TABLE t;
|
|
remove_file $incremental_dir.log;
|
|
remove_file $MYSQL_TMP_DIR/backup_prepare_0.log;
|
|
remove_file $MYSQL_TMP_DIR/backup_prepare_1.log;
|
|
rmdir $basedir;
|
|
rmdir $incremental_dir;
|