- follow steps from report (sorry, don't have dbdeployer on this box) rm -rf 96476 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/96476 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96476 --core-file --socket=/tmp/mysql_5727.sock --port=6666 --log-error=$PWD/96476/log.err --log-error-verbosity=3 --secure-file-priv="" 2>&1 & - terminal 1 bin/mysql -uroot -S /tmp/mysql_5727.sock <<< "CREATE DATABASE test_jfg" bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< " > CREATE TABLE test_jfg.t(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY); > ALTER TABLE test_jfg.t ADD COLUMN v VARCHAR(255);" for i in $(seq 9); do > bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "ALTER TABLE test_jfg.t ADD COLUMN c$i CHAR(255) DEFAULT ''" > done seq -f "INSERT INTO t(v) VALUES ('%f');" 1 1000000 | sed -e '1~1000s/^/COMMIT;BEGIN;/' | bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -- terminal 2 : bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "FLUSH TABLE t FOR EXPORT; DO SLEEP(100)" & \ > sleep 2; \ > for s in cfg ibd; do cp $PWD/96476/test_jfg/t{,_}.$s; done; \ > kill %1 [1] 8569 : : [1]+ Terminated bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "FLUSH TABLE t FOR EXPORT; DO SLEEP(100)" : : bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "CREATE TABLE t2 LIKE t; ALTER TABLE t2 DISCARD TABLESPACE"; \ > for s in cfg ibd; do cp $PWD/96476/test_jfg/t{_,2}.$s; done; \ > bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -N <<< "ALTER TABLE t2 IMPORT TABLESPACE"& \ > sleep 5; \ > kill %1; \ > time bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -N <<< "ALTER TABLE t2 IMPORT TABLESPACE" [1] 8883 ERROR 1813 (HY000) at line 1: Tablespace 'test_jfg/t2' exists. [1]+ Terminated bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -N <<< "ALTER TABLE t2 IMPORT TABLESPACE" real 0m2.529s user 0m0.003s sys 0m0.004s : : : : bin/mysql -uroot -S /tmp/mysql_5727.sock <<< "DROP TABLE test_jfg.t2" : : bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "CREATE TABLE t2 LIKE t; ALTER TABLE t2 DISCARD TABLESPACE"; \ > for s in cfg ibd; do cp $PWD/96476/test_jfg/t{_,2}.$s; done; \ > bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -N <<< "ALTER TABLE t2 IMPORT TABLESPACE"& \ > sleep 5; \ > kill %1; \ > for s in cfg ibd; do mv $PWD/96476/test_jfg/t{2,3}.$s; done; \ > bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "DROP TABLE t2; CREATE TABLE t2 LIKE t; ALTER TABLE t2 DISCARD TABLESPACE"; \ > for s in cfg ibd; do mv $PWD/96476/test_jfg/t{3,2}.$s; done; \ > time bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -N <<< "ALTER TABLE t2 IMPORT TABLESPACE" [1] 8902 [1]+ Terminated bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg -N <<< "ALTER TABLE t2 IMPORT TABLESPACE" ERROR 1815 (HY000) at line 1: Internal error: Cannot reset LSNs in table `test_jfg`.`t2` : Data structure corruption real 0m0.008s user 0m0.000s sys 0m0.003s : : : bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg <<< "CREATE TABLE t2 LIKE t; ALTER TABLE t2 DISCARD TABLESPACE"; \ > for s in cfg ibd; do cp $PWD/96476/test_jfg/t{_,2}.$s; done; ERROR 1050 (42S01) at line 1: Table 't2' already exists : : : bin/mysql -uroot -S /tmp/mysql_5727.sock test_jfg Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 24 Server version: 5.7.27 MySQL Community Server (GPL) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ALTER TABLE t2 IMPORT TABLESPACE; ^C^C -- query aborted ERROR 1815 (HY000): Internal error: Cannot reset LSNs in table `test_jfg`.`t2` : Operation interrupted mysql> ^C mysql> ALTER TABLE t2 IMPORT TABLESPACE; ERROR 1815 (HY000): Internal error: Cannot reset LSNs in table `test_jfg`.`t2` : Data structure corruption mysql> mysql> DROP TABLE t2; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE t2 LIKE t; ERROR 1813 (HY000): Tablespace '`test_jfg`.`t2`' exists. mysql> mysql>