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

Hammy Havoc

Registered
Mar 26, 2022
1
0
1
Liverpool, United Kingdom
cPanel Access Level
Website Owner
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

Jurassic Moderator
Staff member
Oct 19, 2014
10,360
1,632
363
cPanel Access Level
Root Administrator
Hey there! It looks like this is a known issue with MySQL that hasn't been addressed, as I found this entry:


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?