mirror of
https://github.com/MariaDB/server.git
synced 2025-07-07 11:58:20 +02:00
89445b64fe
Import operation without .cfg file fails when there is mismatch of index between metadata table and .ibd file. Moreover, MDEV-19022 shows that InnoDB can end up with index tree where non-leaf page has only one child page. So it is unsafe to find the secondary index root page. This patch does the following when importing the table without .cfg file: 1) If the metadata contains more than one index then InnoDB stops the import operation and report the user to drop all secondary indexes before doing import operation. 2) When the metadata contain only clustered index then InnoDB finds the index id by reading page 0 & page 3 instead of traversing the whole tablespace.
22 lines
771 B
Text
22 lines
771 B
Text
#
|
|
# MDEV-26131 SEGV in ha_innobase::discard_or_import_tablespace
|
|
#
|
|
CREATE TABLE t1(f1 int,f2 text)ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES(1, "InnoDB");
|
|
CREATE TABLE t2 LIKE t1;
|
|
ALTER TABLE t2 ADD KEY idx (f2(13));
|
|
ALTER TABLE t2 DISCARD TABLESPACE;
|
|
FLUSH TABLES t1 FOR EXPORT;
|
|
UNLOCK TABLES;
|
|
ALTER TABLE t2 IMPORT TABLESPACE;
|
|
ERROR HY000: Internal error: Drop all secondary indexes before importing table test/t2 when .cfg file is missing.
|
|
ALTER TABLE t2 DROP KEY idx;
|
|
Warnings:
|
|
Warning 1814 Tablespace has been discarded for table `t2`
|
|
ALTER TABLE t2 IMPORT TABLESPACE;
|
|
Warnings:
|
|
Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t2.cfg', will attempt to import without schema verification
|
|
SELECT * FROM t2;
|
|
f1 f2
|
|
1 InnoDB
|
|
DROP TABLE t1, t2;
|