MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: MySQL Server 8.0.22 Missing sys folder database upgrade fails
Posted by: Peter Brawley
Date: October 31, 2020 11:51AM

"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."

-- https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL Server 8.0.22 Missing sys folder database upgrade fails
2315
Daniel Retief
October 31, 2020 04:14AM
Re: MySQL Server 8.0.22 Missing sys folder database upgrade fails
797
Peter Brawley
October 31, 2020 11:51AM
Re: MySQL Server 8.0.22 Missing sys folder database upgrade fails
721
Daniel Retief
October 31, 2020 01:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.