mirror of
https://github.com/MariaDB/server.git
synced 2025-04-10 09:15:37 +02:00
fb9da7f751
mariadb-backup with --prepare option could result in empty redo log file. When --prepare is followed by --prepare --export, we exit early in srv_start function without opening the ibdata1 tablespace. Later while trying to read rollback segment header page, we hit the debug assert which claims that the system space should already have been opened. There are two assert cases here. Issue-1: System tablespace object is not there in fil space hash i.e. srv_sys_space.open_or_create() is not called. Issue-2: The system tablespace data file ibdata1 is not opened i.e. fil_system.sys_space->open() is not called. Fix: For empty redo log and restore operation, open system tablespace before returning.
79 lines
2.4 KiB
Text
79 lines
2.4 KiB
Text
#--source include/innodb_page_size.inc
|
|
|
|
# Export single table from backup
|
|
# (xtrabackup with --prepare --export)
|
|
|
|
CREATE TABLE t1(i INT) ENGINE INNODB;
|
|
INSERT INTO t1 VALUES(1);
|
|
CREATE TABLE t21(i INT) ENGINE INNODB;
|
|
INSERT INTO t21 VALUES(1);
|
|
|
|
CREATE TABLE t2(i int) ENGINE INNODB;
|
|
|
|
echo # xtrabackup backup;
|
|
|
|
let targetdir=$MYSQLTEST_VARDIR/tmp/backup;
|
|
--disable_result_log
|
|
exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup "--tables=test.*1" --target-dir=$targetdir;
|
|
--enable_result_log
|
|
list_files $targetdir/test *.ibd;
|
|
|
|
# Inject a junk .ibd file into backup dir to
|
|
# see if prepare does not choke on it.
|
|
write_file $targetdir/test/junk.ibd;
|
|
EOF
|
|
write_file $targetdir/test/junk.frm;
|
|
EOF
|
|
|
|
let server_cnf=$targetdir/server.cnf;
|
|
copy_file $MYSQLTEST_VARDIR/my.cnf $server_cnf;
|
|
|
|
# Emulate server config file turnes on binary logs
|
|
perl;
|
|
my $binlog_path="$ENV{'targetdir'}/mysqld-bin";
|
|
my $config_path=$ENV{'server_cnf'};
|
|
open(my $fd, '>>', "$config_path");
|
|
print $fd "\n[mysqld]\n";
|
|
print $fd "log-bin=$binlog_path\n";
|
|
close $fd;
|
|
EOF
|
|
|
|
echo # xtrabackup prepare;
|
|
--disable_result_log
|
|
exec $XTRABACKUP --defaults-file=$server_cnf --defaults-group-suffix=.1 --prepare --export --target-dir=$targetdir;
|
|
--enable_result_log
|
|
|
|
list_files $targetdir/test *.cfg;
|
|
# There must not be binary logs created on --prepare step
|
|
list_files $targetdir/ mysqld-bin.*;
|
|
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
|
ALTER TABLE t1 DISCARD TABLESPACE;
|
|
copy_file $targetdir/test/t1.ibd $MYSQLD_DATADIR/test/t1.ibd;
|
|
copy_file $targetdir/test/t1.cfg $MYSQLD_DATADIR/test/t1.cfg;
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
|
|
SELECT * FROM t1;
|
|
|
|
--echo # MDEV-33023 Crash in mariadb-backup --prepare --export after --prepare
|
|
--disable_result_log
|
|
exec $XTRABACKUP --defaults-file=$server_cnf --defaults-group-suffix=.1 --prepare --target-dir=$targetdir;
|
|
exec $XTRABACKUP --defaults-file=$server_cnf --defaults-group-suffix=.1 --prepare --export --target-dir=$targetdir;
|
|
--enable_result_log
|
|
|
|
list_files $targetdir/test *.cfg;
|
|
# There must not be binary logs created on --prepare step
|
|
list_files $targetdir/ mysqld-bin.*;
|
|
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
|
ALTER TABLE t1 DISCARD TABLESPACE;
|
|
copy_file $targetdir/test/t1.ibd $MYSQLD_DATADIR/test/t1.ibd;
|
|
copy_file $targetdir/test/t1.cfg $MYSQLD_DATADIR/test/t1.cfg;
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
|
|
SELECT * FROM t1;
|
|
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
DROP TABLE t21;
|
|
rmdir $targetdir;
|