"Cannot open datafile for read-only:" "OS error: 71"
Hi all,
I'm getting these errors in `mysql.err`:
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.
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.
Please sign in to leave a comment.
Comments
0 comments