Server does not remove #sql*.frm files after crash during ALTER TABLE

innodb.log_file_name 'innodb'            w1 [ fail ]

        Test ended at 2017-10-09 06:52:48

CURRENT_TEST: innodb.log_file_name

--- D:/win32-debug/build/src/mysql-test/suite/innodb/r/log_file_name.result	2017-10-09 05:53:43.564389700 +0000

+++ D:\win32-debug\build\src\mysql-test\suite\innodb\r\log_file_name.reject	2017-10-09 06:52:47.598666800 +0000

@@ -98,5 +98,7 @@

 FOUND 1 /\[Warning\] InnoDB: Tablespace \d+ was not found at .*u[1-5].ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!.*/ in mysqld.1.err

 DROP TABLE u1,u2,u3,u6;

 # List of files:

+#sql-1a18_1e.frm

+#sql-1bc8_9.frm

 SHOW TABLES;

 Tables_in_test

mysqltest: Result length mismatch

 - saving 'D:/win32-debug/build/mysql-test/var/1/log/innodb.log_file_name-innodb/' to 'D:/win32-debug/build/mysql-test/var/log/innodb.log_file_name-innodb/'

Retrying test innodb.log_file_name, attempt(2/3)...

***Warnings generated in error logs during shutdown after running tests: innodb.log_file_name

2017-10-09  6:52:11 0 [ERROR] InnoDB: Cannot rename '.\test\t1.ibd' to '.\test\t2.ibd' for space ID 928 because the target file exists. Remove the target file and try again.

2017-10-09  6:52:11 0 [ERROR] InnoDB:  Cannot replay file rename. Remove either file and try again.

2017-10-09  6:52:11 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Generic error

2017-10-09  6:52:11 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:11 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:14 0 [ERROR] InnoDB: Tablespace 929 was not found at .\test\t3.ibd.

2017-10-09  6:52:14 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.

2017-10-09  6:52:14 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Tablespace not found

2017-10-09  6:52:14 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:14 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:17 0 [ERROR] InnoDB: Tablespace 928 was not found at .\test\t1.ibd.

2017-10-09  6:52:17 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.

2017-10-09  6:52:17 0 [ERROR] InnoDB: Tablespace 929 was not found at .\test\t3.ibd.

2017-10-09  6:52:17 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Tablespace not found

2017-10-09  6:52:17 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:17 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:20 0 [ERROR] InnoDB: Tablespace 928 was not found at .\test\t1.ibd.

2017-10-09  6:52:20 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.

2017-10-09  6:52:20 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Tablespace not found

2017-10-09  6:52:21 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:23 0 [ERROR] InnoDB: Tablespace 928 was not found at .\test\t1.ibd.

2017-10-09  6:52:23 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.

2017-10-09  6:52:23 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Tablespace not found

2017-10-09  6:52:23 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:23 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:26 0 [ERROR] InnoDB: Cannot read first page of '.\test\t2.ibd' I/O error

2017-10-09  6:52:26 0 [ERROR] InnoDB: Cannot read first page in datafile: .\test\t2.ibd, Space ID:4294967295, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:26 0 [ERROR] InnoDB: Datafile '.\test\t2.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.

2017-10-09  6:52:26 0 [ERROR] InnoDB: Tablespace 928 was not found at .\test\t1.ibd.

2017-10-09  6:52:26 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.

2017-10-09  6:52:26 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Tablespace not found

2017-10-09  6:52:26 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:31 8 [ERROR] InnoDB: Operating system error number 80 in a file operation.

2017-10-09  6:52:31 8 [ERROR] InnoDB: Cannot create file '.\test\t0.ibd'

2017-10-09  6:52:32 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\test\u1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:32 0 [ERROR] InnoDB: Datafile '.\test\u1.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.

2017-10-09  6:52:32 0 [ERROR] InnoDB: Cannot read first page of '.\test\u2.ibd' I/O error

2017-10-09  6:52:32 0 [ERROR] InnoDB: Cannot read first page in datafile: .\test\u2.ibd, Space ID:4294967295, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:32 0 [ERROR] InnoDB: Datafile '.\test\u2.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.

2017-10-09  6:52:32 0 [ERROR] InnoDB: Cannot rename '.\test\u5.ibd' to '.\test\u6.ibd' for space ID 935 because the target file exists. Remove the target file and try again.

2017-10-09  6:52:32 0 [ERROR] InnoDB:  Cannot replay file rename. Remove either file and try again.

2017-10-09  6:52:32 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Generic error

2017-10-09  6:52:32 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:34 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\test\u1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:34 0 [ERROR] InnoDB: Datafile '.\test\u1.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.

2017-10-09  6:52:34 0 [ERROR] InnoDB: Cannot rename '.\test\u5.ibd' to '.\test\u6.ibd' for space ID 935 because the target file exists. Remove the target file and try again.

2017-10-09  6:52:34 0 [ERROR] InnoDB:  Cannot replay file rename. Remove either file and try again.

2017-10-09  6:52:34 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2200] with error Generic error

2017-10-09  6:52:35 0 [ERROR] Plugin 'InnoDB' init function returned error.

2017-10-09  6:52:35 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-10-09  6:52:37 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\test\u1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:37 0 [ERROR] InnoDB: Datafile '.\test\u1.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.

2017-10-09  6:52:37 0 [Warning] InnoDB: Tablespace 932 was not found at .\test\u1.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!

2017-10-09  6:52:37 0 [Warning] InnoDB: Tablespace 933 was not found at .\test\u2.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!

2017-10-09  6:52:37 0 [Warning] InnoDB: Tablespace 934 was not found at .\test\u3.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!

2017-10-09  6:52:39 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\test\u1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:39 0 [Warning] InnoDB: Ignoring tablespace for `test`.`u1` because it could not be opened.

2017-10-09  6:52:39 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2017-10-09  6:52:39 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\test\u2.ibd' OS error: 71

2017-10-09  6:52:39 0 [Warning] InnoDB: Ignoring tablespace for `test`.`u2` because it could not be opened.

2017-10-09  6:52:39 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2017-10-09  6:52:39 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\test\u3.ibd' OS error: 71

2017-10-09  6:52:39 0 [Warning] InnoDB: Ignoring tablespace for `test`.`u3` because it could not be opened.

2017-10-09  6:52:46 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\test\u1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:46 0 [Warning] InnoDB: Ignoring tablespace for `test`.`u1` because it could not be opened.

2017-10-09  6:52:46 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2017-10-09  6:52:46 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\test\u2.ibd' OS error: 71

2017-10-09  6:52:46 0 [Warning] InnoDB: Ignoring tablespace for `test`.`u2` because it could not be opened.

2017-10-09  6:52:46 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2017-10-09  6:52:46 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\test\u3.ibd' OS error: 71

2017-10-09  6:52:46 0 [Warning] InnoDB: Ignoring tablespace for `test`.`u3` because it could not be opened.

2017-10-09  6:52:47 8 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\test\u1.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

2017-10-09  6:52:47 8 [ERROR] InnoDB: Table test/u1 in the InnoDB data dictionary has tablespace id 932, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?

2017-10-09  6:52:47 8 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2017-10-09  6:52:47 8 [ERROR] InnoDB: Cannot open datafile for read-only: '.\test\u2.ibd' OS error: 71

2017-10-09  6:52:47 8 [ERROR] InnoDB: Table test/u2 in the InnoDB data dictionary has tablespace id 933, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?

2017-10-09  6:52:47 8 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2017-10-09  6:52:47 8 [ERROR] InnoDB: Cannot open datafile for read-only: '.\test\u3.ibd' OS error: 71

2017-10-09  6:52:47 8 [ERROR] InnoDB: Table test/u3 in the InnoDB data dictionary has tablespace id 934, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?