This web page requires JavaScript to be enabled.

JavaScript is an object-oriented computer programming language commonly used to create interactive effects within web browsers.

How to enable JavaScript?

XAMPP Error: InnoDB/MySQL shutdown unexpectedly won’t start again

Posts December 18, 2021 Nam Le 0

You will get the error message when starting the XAMPP in a beautiful day:

1:37:52 AM  [mysql]     Error: MySQL shutdown unexpectedly.
1:37:52 AM  [mysql]     This may be due to a blocked port, missing dependencies, 
1:37:52 AM  [mysql]     improper privileges, a crash, or a shutdown by another method.
1:37:52 AM  [mysql]     Press the Logs button to view error logs and check
1:37:52 AM  [mysql]     the Windows Event Viewer for more clues
1:37:52 AM  [mysql]     If you need more help, copy and post this
1:37:52 AM  [mysql]     entire log window on the forums

When viewing the Event Application or viewing the mysql_error.log:

2021-12-18  1:37:45 0 [ERROR] Aborting
InnoDB: using atomic writes.
2021-12-18  1:37:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-18  1:37:51 0 [Note] InnoDB: Uses event mutexes
2021-12-18  1:37:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-18  1:37:51 0 [Note] InnoDB: Number of pools: 1
2021-12-18  1:37:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-18  1:37:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-18  1:37:51 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-18  1:37:51 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 302000895 between the checkpoint 302000895 and the end 302000640.
2021-12-18  1:37:51 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-12-18  1:37:51 0 [Note] InnoDB: Starting shutdown...
2021-12-18  1:37:51 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-12-18  1:37:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-12-18  1:37:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-18  1:37:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-12-18  1:37:51 0 [ERROR] Aborting

=> Delete files /mysql/data/ib_logfile* will solve the problem.

-Nam Le


Last modified on March 20th, 2022 at 9:55 pm

Nam Le
lequocnam



0 responds

Leave a Reply

Your email address will not be published.