MySQL错误: returned OS error 765

Question

Mysql返回错误

[ERROR] InnoDB: File table_name.ibd: 'Windows aio' returned OS error 765. Cannot continue operation

我使用SHOW GLOBAL VARIABLES LIKE '%open%';来检查打开的文件计数。显示 2000。

当这个问题发生时，mysql会自动关闭。

编辑:此问题有时会发生，但不会出现在同一个表中。此外，大小超过 125GB 的表也存在此问题。

有什么办法可以解决这个问题吗？

Answer 1

听起来很像您的文件可能已损坏。

ERROR_WAIT_FOR_OPLOCK

765 (0x2FD)
An operation is blocked waiting for an oplock.

The cause of Error_wait_for_oplock error code?

A Error_wait_for_oplock error may be because of Windows system data file failure. Broken system entries can be a real risk to the health and wellbeing of your computer system.

There are numerous situations that will cause file errors. An unfinished installation steup, an unfinished uninstall, bad deletion of programs or equipment. It can also be brought about when a personal computer is contaminated with malware or adware or spyware infection or through an incorrect shutdown of the computer system. Any one of the preceeding actions can result in the removal or data corruption of Windows system files. This damaged system file will cause missing or incorrectly linked information and data files essential for the optimal operation of the software.

我首先从上次备份中恢复该数据库。