Windows 10

Pszola, can you please provide the exact commands for repeating this error, starting from the initial CREATE TABLE before FLUSH TABLES?

Note: There is a known bug MDEV-18543, but your description sounds like the problem may be different.

Hello Marko Mäkela,
when trying to provide the exact commands to create a typical table (with WITH SYSTEM VERSIONING), I noticed that everything works as expected with a table created newly. After inserting some rows and updating these, I could copy the tablespace and recreate the table. Therefore, the detailed commands probably won't be helpful. But: I am not able to transfer the ORIGINAL table to a new server, as the IMPORT TABLE SPACE doesn't work. After recreating a table and inserting the rows via mariadump the historical data will be lost which cannot be accepted. So, to my conclusion there must be differences between the newly created tables and the original tables, but I have no idea how to figure that out.

--source include/have_innodb.inc

CREATE TABLE t1 (pk INT, a INT, PRIMARY KEY(pk)) ENGINE=InnoDB;

ALTER TABLE t1 DROP a;

INSERT INTO t1 VALUES (1),(2); # Optional

--let $datadir= `select @@datadir`

FLUSH TABLES t1 FOR EXPORT;

--copy_file $datadir/test/t1.ibd $MYSQLTEST_VARDIR/t1.ibd

--copy_file $datadir/test/t1.cfg $MYSQLTEST_VARDIR/t1.cfg

UNLOCK TABLES;

DROP TABLE t1;

CREATE TABLE t1 (pk INT, PRIMARY KEY(pk)) ENGINE=InnoDB;

ALTER TABLE t1 DISCARD TABLESPACE;

--copy_file $MYSQLTEST_VARDIR/t1.ibd $datadir/test/t1.ibd

--copy_file $MYSQLTEST_VARDIR/t1.cfg $datadir/test/t1.cfg

ALTER TABLE t1 IMPORT TABLESPACE;

# Cleanup

DROP TABLE t1;

 query 'ALTER TABLE t1 IMPORT TABLESPACE' failed: 1808: Schema mismatch (Index field count 3 doesn't match tablespace metadata file value 4)

Reproducible on 10.4, 10.5. INSERT in the test case is unimportant, I put it there to make the point that the table doesn't have to be empty to get the failure.

The problem appeared in 10.4 after this commit:

commit ea2b19dee6a6ed69faffa368c9b1ce9338556299

Author: Marko Mäkelä

Date:   Fri Sep 27 16:01:55 2019 +0300

    MDEV-20117: Fix another scenario

See also MDEV-24515.

elenst, thank you. Your test case looks like a duplicate of MDEV-18543.

Pszola, a new release where MDEV-18543 has been fixed is expected to be available in the next few days. Can you please test if 10.4.22, 10.5.13, or 10.6.5 will import the tablespace?