mirror of
https://github.com/MariaDB/server.git
synced 2025-08-28 13:21:36 +02:00
626d5bf832
Problem:
========
- Mariabackup ignores tables-file option because it fails to
register the new entry in database hash cells. This issue was
caused by the commit 3c312d247c (MDEV-35190).
xb_register_filter_entry() fails to stop when it encounters the
empty list.
Solution:
=========
xb_register_filter_entry(): If there is no next member to
deference then it return pointer to existing element.
39 lines
881 B
Text
39 lines
881 B
Text
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;
|
|
# xtrabackup backup
|
|
t1.new
|
|
t21.new
|
|
# xtrabackup prepare
|
|
t1.cfg
|
|
t21.cfg
|
|
ALTER TABLE t1 DISCARD TABLESPACE;
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
SELECT * FROM t1;
|
|
i
|
|
1
|
|
# MDEV-33023 Crash in mariadb-backup --prepare --export after --prepare
|
|
t1.cfg
|
|
t21.cfg
|
|
ALTER TABLE t1 DISCARD TABLESPACE;
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
SELECT * FROM t1;
|
|
i
|
|
1
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
DROP TABLE t21;
|
|
#
|
|
# MDEV-36287 maribackup ignores tables-file option
|
|
#
|
|
CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB;
|
|
CREATE TABLE t2(f1 INT NOT NULL)ENGINE=InnoDB;
|
|
INSERT INTO t1 values(1);
|
|
# Only backup table t1 by creating tables_file
|
|
# Backup with --tables-file option
|
|
# table t2 is skipped. Shows only t1
|
|
t1.frm
|
|
t1.new
|
|
DROP TABLE t2, t1;
|