mirror of
https://github.com/MariaDB/server.git
synced 2025-04-12 02:05:34 +02:00

- 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.
21 lines
602 B
Text
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;
|