"Cannot open datafile for read-only:" "OS error: 71"

[Hammy Havoc]

Hi all,

I'm getting these errors in `mysql.err`:


2022-03-26 11:32:31 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-26 11:32:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-03-26 11:32:32 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2022-03-26 11:32:32 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-26 11:32:32 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-26 11:32:32 0 [ERROR] InnoDB: Cannot open datafile for read-only: './site_wordpress/Q2qPP_commentmeta.ibd' OS error: 71
2022-03-26 11:32:32 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2022-03-26 11:32:32 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-26 11:32:32 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-26 11:32:32 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``site_wordpress`.`Q2qPP_commentmeta``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2022-03-26 11:32:32 0 [Warning] InnoDB: Ignoring tablespace for `site_wordpress`.`Q2qPP_commentmeta` because it could not be opened.
2022-03-26 11:32:32 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2022-03-26 11:32:32 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-26 11:32:32 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-26 11:32:32 0 [ERROR] InnoDB: Cannot open datafile for read-only: './site_wordpress/Q2qPP_comments.ibd' OS error: 71
2022-03-26 11:32:32 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2022-03-26 11:32:32 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-26 11:32:32 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.


Perhaps weirdly, the site appears to be working just fine, but my log file is full of these errors (there's way more of them, I didn't include them all).

Any ideas? This is on centOS.

 

[cPRex]

Hey there! It looks like this is a known issue with MySQL that hasn't been addressed, as I found this entry:

MySQL Bugs: #85016: better description for: OS error: 71

bugs.mysql.com

I'm not saying that doesn't mean there are other issues, but that specific error message is a known problem as it's not very specific.

Does that specific InnoDB database exist on the system?