MySQL Forums
Forum List  »  InnoDB

OS Error 1217 on startup
Posted by: asd asd
Date: August 16, 2021 08:54AM

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:

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

Options: ReplyQuote

Written By
OS Error 1217 on startup
August 16, 2021 08:54AM
August 16, 2021 12:05PM
August 17, 2021 12:32AM
August 17, 2021 09:43AM
August 18, 2021 03:19AM
August 18, 2021 03:27AM
August 18, 2021 08:07AM

Sorry, only registered users may post in this forum.

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.