Can't Restart MySQL Service on Windows After Crash
Posted by: James A
Date: April 03, 2023 01:06AM
Date: April 03, 2023 01:06AM
I have a MySQL database that has been working for months. Whilst running a query yesterday my PC crashed. Since then I have not been able to restart it. Each time I try to start it using services.msc I get the following error:
"the MySQL service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs"
Can anyone help?
I'm running MySQL 8.0 on Windows 8.1.
The error log since the crash shows:
2023-04-01T09:16:59.330492Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T12:47:23.484593Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T12:57:22.799292Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T13:06:12.263407Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T13:06:38.642850Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T17:17:10.076066Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 2284
2023-04-01T17:17:10.567686Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T17:17:11.974356Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T17:17:11.975240Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T17:17:11.979128Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T17:17:11.980945Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T17:17:11.981433Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T17:17:11.986035Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T17:27:46.194854Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 1444
2023-04-01T17:27:46.234416Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T17:27:46.613639Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T17:27:46.614138Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T17:27:46.618477Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T17:27:46.619105Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T17:27:46.619338Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T17:27:46.619799Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T17:30:13.925780Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6300
2023-04-01T17:30:14.246929Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T17:30:15.561959Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T17:30:15.578061Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T17:30:15.582452Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T17:30:15.584373Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T17:30:15.584927Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T17:30:15.589602Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T18:00:51.791475Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 1056
2023-04-01T18:00:51.856327Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T18:00:52.167483Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T18:00:52.167960Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T18:00:52.172104Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T18:00:52.172707Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T18:00:52.172927Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T18:00:52.173356Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T18:22:27.737310Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6280
2023-04-01T18:22:27.773725Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T18:22:28.095318Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T18:22:28.095753Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T18:22:28.099885Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T18:22:28.100490Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T18:22:28.100705Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T18:22:28.101330Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T18:30:34.856231Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 1548
2023-04-01T18:30:34.873069Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T18:30:35.185906Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T18:30:35.186341Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T18:30:35.190625Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T18:30:35.191239Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T18:30:35.191455Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T18:30:35.191885Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T19:13:02.685134Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6460
2023-04-01T19:13:02.709970Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T19:13:03.040373Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T19:13:03.040808Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T19:13:03.044552Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T19:13:03.045161Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T19:13:03.045377Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T19:13:03.045792Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T19:34:50.903802Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6284
2023-04-01T19:34:50.925394Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T19:34:51.238441Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T19:34:51.238938Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T19:34:51.242823Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T19:34:51.243420Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T19:34:51.243638Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T19:34:51.244055Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T19:49:25.260107Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 2372
2023-04-01T19:49:25.892349Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T19:49:27.680383Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T19:49:27.681995Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T19:49:27.686597Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T19:49:27.690385Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T19:49:27.690923Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T19:49:27.698297Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T20:09:12.859682Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 5080
2023-04-01T20:09:12.895346Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T20:09:13.215283Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T20:09:13.215719Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T20:09:13.219217Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T20:09:13.219822Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T20:09:13.220038Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T20:09:13.220484Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-02T08:51:27.794025Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 3688
2023-04-02T08:51:28.059470Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-02T08:51:29.274932Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-02T08:51:29.275376Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-02T08:51:29.278807Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-02T08:51:29.279417Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-02T08:51:29.279635Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-02T08:51:29.280072Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-02T09:02:39.433923Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 9096
2023-04-02T09:02:39.463961Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-02T09:02:39.782388Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-02T09:02:39.782870Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-02T09:02:39.786918Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-02T09:02:39.787514Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-02T09:02:39.787732Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-02T09:02:39.788147Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
"the MySQL service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs"
Can anyone help?
I'm running MySQL 8.0 on Windows 8.1.
The error log since the crash shows:
2023-04-01T09:16:59.330492Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T12:47:23.484593Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T12:57:22.799292Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T13:06:12.263407Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T13:06:38.642850Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-04-01T17:17:10.076066Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 2284
2023-04-01T17:17:10.567686Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T17:17:11.974356Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T17:17:11.975240Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T17:17:11.979128Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T17:17:11.980945Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T17:17:11.981433Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T17:17:11.986035Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T17:27:46.194854Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 1444
2023-04-01T17:27:46.234416Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T17:27:46.613639Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T17:27:46.614138Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T17:27:46.618477Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T17:27:46.619105Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T17:27:46.619338Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T17:27:46.619799Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T17:30:13.925780Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6300
2023-04-01T17:30:14.246929Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T17:30:15.561959Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T17:30:15.578061Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T17:30:15.582452Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T17:30:15.584373Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T17:30:15.584927Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T17:30:15.589602Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T18:00:51.791475Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 1056
2023-04-01T18:00:51.856327Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T18:00:52.167483Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T18:00:52.167960Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T18:00:52.172104Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T18:00:52.172707Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T18:00:52.172927Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T18:00:52.173356Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T18:22:27.737310Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6280
2023-04-01T18:22:27.773725Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T18:22:28.095318Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T18:22:28.095753Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T18:22:28.099885Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T18:22:28.100490Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T18:22:28.100705Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T18:22:28.101330Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T18:30:34.856231Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 1548
2023-04-01T18:30:34.873069Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T18:30:35.185906Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T18:30:35.186341Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T18:30:35.190625Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T18:30:35.191239Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T18:30:35.191455Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T18:30:35.191885Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T19:13:02.685134Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6460
2023-04-01T19:13:02.709970Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T19:13:03.040373Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T19:13:03.040808Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T19:13:03.044552Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T19:13:03.045161Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T19:13:03.045377Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T19:13:03.045792Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T19:34:50.903802Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 6284
2023-04-01T19:34:50.925394Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T19:34:51.238441Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T19:34:51.238938Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T19:34:51.242823Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T19:34:51.243420Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T19:34:51.243638Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T19:34:51.244055Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T19:49:25.260107Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 2372
2023-04-01T19:49:25.892349Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T19:49:27.680383Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T19:49:27.681995Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T19:49:27.686597Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T19:49:27.690385Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T19:49:27.690923Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T19:49:27.698297Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-01T20:09:12.859682Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 5080
2023-04-01T20:09:12.895346Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-01T20:09:13.215283Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-01T20:09:13.215719Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-01T20:09:13.219217Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-01T20:09:13.219822Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-01T20:09:13.220038Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-01T20:09:13.220484Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-02T08:51:27.794025Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 3688
2023-04-02T08:51:28.059470Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-02T08:51:29.274932Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-02T08:51:29.275376Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-02T08:51:29.278807Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-02T08:51:29.279417Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-02T08:51:29.279635Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-02T08:51:29.280072Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-04-02T09:02:39.433923Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 9096
2023-04-02T09:02:39.463961Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-02T09:02:39.782388Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo86767 has start_lsn 284035622912 but expected 284140414976 (end_lsn of the previous redo log file).
2023-04-02T09:02:39.782870Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-04-02T09:02:39.786918Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-04-02T09:02:39.787514Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-02T09:02:39.787732Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-02T09:02:39.788147Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
Subject
Written By
Posted
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.