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

H

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

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:

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

bugs.mysql.com 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?
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
S cannot copy database in phpmyadmin as user or reseller Databases 1
gdimi In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found Databases 7
M max_open_files cannot be changed Databases 1
konrath cannot open Packages database in /var/lib/rpm Databases 1
S tail: cannot open `/var/log/mysqld.log' for reading: No such file or directory Databases 1
Similar threads
cannot copy database in phpmyadmin as user or reseller
In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found
max_open_files cannot be changed
cannot open Packages database in /var/lib/rpm
tail: cannot open `/var/log/mysqld.log' for reading: No such file or directory
Top Bottom