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:

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

Options: ReplyQuote


Subject
Views
Written By
Posted
OS Error 1217 on startup
2458
August 16, 2021 08:54AM
618
August 16, 2021 12:05PM
463
August 17, 2021 12:32AM
578
August 17, 2021 09:43AM
490
August 18, 2021 03:19AM
550
August 18, 2021 03:27AM
498
August 18, 2021 08:07AM


Sorry, you can't reply to this topic. It has been closed.

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.