Cannot Open Datafile
With innodb_file_per_table
enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd
file) is missing:
[ERROR] InnoDB: Operating system error number 2 in a file operation.
[ERROR] InnoDB: The error means the system cannot find the path specified.
[ERROR] InnoDB: Cannot open datafile for read-only: './test/t1.ibd' OS error: 71
[Warning] InnoDB: Ignoring tablespace `test/t1` because it could not be opened.
To address the these messages, issue DROP TABLE
statement to remove data about the missing table from the data dictionary.