Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14029

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

    Details

    • Sprint:
      10.1.29

      Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/5751/steps/test/logs/stdio

      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?
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                elenst Elena Stepanova
                Reporter:
                alice Alice Sherepa
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: