mirror of
https://github.com/MariaDB/server.git
synced 2025-06-20 03:31:36 +02:00
9b431d714f
Allow ALTER TABLE ... IMPORT TABLESPACE without creating the table followed by discarding the tablespace. That is, assuming we want to import table t1 to t2, instead of CREATE TABLE t2 LIKE t1; ALTER TABLE t2 DISCARD TABLESPACE; FLUSH TABLES t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd UNLOCK TABLES; ALTER TABLE t2 IMPORT TABLESPACE; We can simply do FLUSH TABLES t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd UNLOCK TABLES; ALTER TABLE t2 IMPORT TABLESPACE; We achieve this by creating a "stub" table in the second scenario while opening the table, where t2 does not exist but needs to import from t1. The "stub" table is similar to a table that is created but then instructed to discard its tablespace. We include tests with various row formats, encryption, with indexes and auto-increment.
80 lines
4.2 KiB
Text
80 lines
4.2 KiB
Text
#
|
|
# MDEV-26137 ALTER TABLE IMPORT enhancement
|
|
#
|
|
call mtr.add_suppression('InnoDB: Tablespace for table `test`.`t1` is set as discarded.');
|
|
call mtr.add_suppression('InnoDB: Tablespace for table `test`.`t2` is set as discarded.');
|
|
call mtr.add_suppression('InnoDB: Tablespace for table `test`.`t3` is set as discarded.');
|
|
call mtr.add_suppression('InnoDB: ./test/t3.ibd: Page 0 at offset 0 looks corrupted.');
|
|
call mtr.add_suppression("mariadbd.*: Index for table 't3' is corrupt; try to repair it");
|
|
call mtr.add_suppression("InnoDB: Expected tablespace id \\d+ but found \\d+ in the file ./test/t3.ibd");
|
|
call mtr.add_suppression("InnoDB: Corrupted page \\[page id: space=.*, page number=0\\] of datafile './test/t3.ibd' could not be found in the doublewrite buffer.");
|
|
call mtr.add_suppression('InnoDB: Tablespace for table `test`.`t4` is set as discarded.');
|
|
call mtr.add_suppression('InnoDB: ./test/t4.ibd: Page 0 at offset 0 looks corrupted.');
|
|
call mtr.add_suppression("mariadbd.*: Index for table 't4' is corrupt; try to repair it");
|
|
call mtr.add_suppression("InnoDB: Corrupted page \\[page id: space=.*, page number=0\\] of datafile './test/t4.ibd' could not be found in the doublewrite buffer.");
|
|
# Recovery from crashes
|
|
## t1: Creation of stub succeeds; server crashes; second import attempt succeeds
|
|
## t2: Creation of stub succeeds; server crashes; drop table
|
|
## t3: Creation of stub succeeds; server crashes; ibd corrupted; second import attempt fails; drop table
|
|
## t4: Did not copy .cfg; creation of stub succeeds; server crashes; ibd corrupted; second import attempt fails; drop table
|
|
CREATE TABLE t (a int) ENGINE=InnoDB;
|
|
INSERT INTO t VALUES(42);
|
|
FLUSH TABLES t FOR EXPORT;
|
|
UNLOCK TABLES;
|
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
|
|
SET GLOBAL innodb_max_dirty_pages_pct=0.0;
|
|
connect hang1,localhost,root;
|
|
SET DEBUG_SYNC='ib_after_create_stub_for_import SIGNAL hung WAIT_FOR ever';
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
connection default;
|
|
SET DEBUG_SYNC='now WAIT_FOR hung';
|
|
connect hang2,localhost,root;
|
|
SET DEBUG_SYNC='ib_after_create_stub_for_import SIGNAL hung WAIT_FOR ever';
|
|
ALTER TABLE t2 IMPORT TABLESPACE;
|
|
connection default;
|
|
SET DEBUG_SYNC='now WAIT_FOR hung';
|
|
connect hang3,localhost,root;
|
|
SET DEBUG_SYNC='ib_after_create_stub_for_import SIGNAL hung WAIT_FOR ever';
|
|
ALTER TABLE t3 IMPORT TABLESPACE;
|
|
connection default;
|
|
SET DEBUG_SYNC='now WAIT_FOR hung';
|
|
connect hang4,localhost,root;
|
|
SET DEBUG_SYNC='ib_after_create_stub_for_import SIGNAL hung WAIT_FOR ever';
|
|
ALTER TABLE t4 IMPORT TABLESPACE;
|
|
connection default;
|
|
SET DEBUG_SYNC='now WAIT_FOR hung';
|
|
# corrupting the 0th page
|
|
# Restart mysqld after the crash and reconnect.
|
|
# restart
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`a` int(11) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
SELECT * FROM t1;
|
|
a
|
|
42
|
|
ALTER TABLE t3 IMPORT TABLESPACE;
|
|
ERROR HY000: Internal error: Error importing tablespace for table `test`.`t3` : Data structure corruption
|
|
ALTER TABLE t4 IMPORT TABLESPACE;
|
|
ERROR HY000: Schema mismatch (Expected FSP_SPACE_FLAGS=0x15, .ibd file contains 0x1010115.)
|
|
DROP TABLE t, t1, t2, t3, t4;
|
|
# Recovery from corruption only, no server restart
|
|
## t5: Recovery from corruption, with cfg
|
|
## t6: Recovery from corruption, without cfg
|
|
call mtr.add_suppression('InnoDB: ./test/t5.ibd: Page 0 at offset 0 looks corrupted.');
|
|
call mtr.add_suppression("mariadbd.*: Index for table 't5' is corrupt; try to repair it");
|
|
call mtr.add_suppression("InnoDB: Corrupted page \\[page id: space=.*, page number=0\\] of datafile './test/t5.ibd' could not be found in the doublewrite buffer.");
|
|
call mtr.add_suppression("InnoDB: Corrupted page \\[page id: space=.*, page number=0\\] of datafile './test/t6.ibd' could not be found in the doublewrite buffer.");
|
|
call mtr.add_suppression("mariadbd.*: Index for table 't6' is corrupt; try to repair it");
|
|
CREATE TABLE t (a int) ENGINE=InnoDB;
|
|
INSERT INTO t VALUES(42);
|
|
FLUSH TABLES t FOR EXPORT;
|
|
UNLOCK TABLES;
|
|
# corrupting the 0th page
|
|
ALTER TABLE t5 IMPORT TABLESPACE;
|
|
ERROR HY000: Internal error: Error importing tablespace for table `test`.`t5` : Data structure corruption
|
|
ALTER TABLE t6 IMPORT TABLESPACE;
|
|
ERROR HY000: Schema mismatch (Expected FSP_SPACE_FLAGS=0x15, .ibd file contains 0x1010115.)
|
|
DROP TABLE t, t5, t6;
|