mariadb/mysql-test/suite/mariabackup/incremental_compressed.result
Thirunarayanan Balathandayuthapani 2469963f05 MDEV-36270 mariabackup.incremental_compressed fails in 10.11+
- 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.
2025-03-25 11:56:35 +01:00

21 lines
602 B
Text

#
# MDEV-18589 Assertion ...physical_size(flags) == info.page_size
# failed in xb_delta_open_matching_space
#
CREATE TABLE t (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE t PARTITION BY KEY(pk);
# Incremental backup
# Prepare fullbackup
# Prepare incremental backup
# shutdown server
# remove datadir
# xtrabackup move back
# restart
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`pk` int(11) NOT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPRESSED
PARTITION BY KEY (`pk`)
DROP TABLE t;