CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB row_format=compressed encrypted=yes;

insert into t1 values(1, repeat('Nesamani', 10));

select count(*) from t1;

count(*)

1

show create table t1;

Table	Create Table

t1	CREATE TABLE `t1` (

  `id` int(11) NOT NULL,

  `a` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED `encrypted`=yes

# Wait max 10 min for key encryption threads to encrypt all spaces

--let $wait_timeout= 600

--let $wait_condition=SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND ROTATING_OR_FLUSHING <> 0

--source include/wait_condition.inc

--source include/shutdown_mysqld.inc

--source include/start_mysqld.inc

let MYSQLD_DATADIR =`SELECT @@datadir`;

--list_files $MYSQLD_DATADIR/test

FLUSH TABLES t1 FOR EXPORT;

perl;

do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";

ib_backup_tablespaces("test", "t1");

EOF

--list_files $MYSQLD_DATADIR/test

UNLOCK TABLES;

DROP TABLE t1;

create table t1(id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB row_format=compressed encrypted=yes;

alter table t1 discard tablespace;

perl;

do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";

ib_discard_tablespaces("test", "t1");

ib_restore_tablespaces("test", "t1");

EOF

ALTER TABLE t1 IMPORT TABLESPACE;

failed: 1296: Got error 39 'Data structure corruption' from ./test/t1.ibd

2019-06-05 13:35:01 139993520764672 [Note] InnoDB: Importing tablespace for table 'test/t1' that was exported from host 'thiru-Lenovo-Y520-15IKBN'

2019-06-05 13:35:01 139993520764672 [Note] InnoDB: Phase I - Update all pages

2019-06-05 13:35:01 139993520764672 [Note] InnoDB: Sync to disk

2019-06-05 13:35:01 139993520764672 [Note] InnoDB: Sync to disk - done!

2019-06-05 13:35:01 139993520764672 [ERROR] InnoDB: Refusing to load './test/t1.ibd' (id=4, flags=0x29); dictionary contains id=5, flags=0x29

2019-06-05 13:35:01 139993520764672 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2019-06-05 13:35:01 139993520764672 [ERROR] InnoDB: The error means the system cannot find the path specified.

2019-06-05 13:35:01 139993520764672 [ERROR] InnoDB: Could not find a valid tablespace file for `test/t1`. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.

2019-06-05 13:35:01 139993520764672 [Note] InnoDB: Discarding tablespace of table `test`.`t1`: Data structure corruption

2019-06-05 13:35:01 139993520764672 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it

                        /* When tablespace is encrypted or compressed its

                        first page (i.e. page 0) is not encrypted or

                        compressed and there is no need to copy frame. */

                        if (encrypted && block->page.id.page_no() != 0) {

                                byte *local_frame = callback.get_frame(block);

                                ut_ad((writeptr + (i * size)) != local_frame);

                                memcpy((writeptr + (i * size)), local_frame, size);

                        }