When starting MySQL server it crashes, there is full log:
2021-08-16T11:49:20.983309Z 0 [System] [MY-010116] [Server] c:\openserver\modules\database\MySQL-8.0-Win10\bin\mysqld.exe (mysqld 8.0.24) starting as process 9160
2021-08-16T11:49:21.044642Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-08-16T11:50:11.932767Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 1117 in a file operation.
2021-08-16T11:50:11.934157Z 1 [ERROR] [MY-012646] [InnoDB] File (unknown): 'flush' returned OS error 1217. Cannot continue operation
2021-08-16T11:50:11.934525Z 1 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
After countless google pages i did not find a solution...and this log is "very" informative, so no useful information about error from this... also according to MSDN:
ERROR_INVALID_MESSAGENAME
1217 (0x4C1)
The format of the specified message name is invalid.
also not very useful... What i tried:
1.Delete log files (ib_logfile0, ib_logfile1, ib_logfile101)
2.Delete tmp file (ibtmp1)
3.Reinstall MySQL server
4.Try every value of innodb_force_recovery parameter from 1 to 6
5.Check permissions of MySQL folder and all of its file for write and read
6.Check available disk space
7.Run chkdsk /F /R, rebooting computer and repeating all of the above
I`m running Windows 10 Home 20H2
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.
