MySQL Forums
Forum List  »  InnoDB

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Server 8.0.22 Missing sys folder database upgrade fails
23
October 31, 2020 11:51AM


Sorry, only registered users may post in this forum.

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.