mysql crashes instantly - InnoDB: Missing MLOG_CHECKPOINT

[2nweb]

I've been using XAMPP portable for over 10 years now, and have been getting this and similar crashes only in the past year or so. I had been getting around the repeated mysql\data corruptions by keeping a "fresh" copy of the data folder zipped, and just overwriting it whenever the crashes happened. That's not working any longer. Starting mysql just dumps out immediately, and restoring mysql\data has no effect.

Log:
2022-01-23 9:50:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-23 9:50:04 0 [Note] InnoDB: Uses event mutexes
2022-01-23 9:50:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-23 9:50:04 0 [Note] InnoDB: Number of pools: 1
2022-01-23 9:50:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-23 9:50:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-23 9:50:04 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-23 9:50:04 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 6416151 between the checkpoint 6416151 and the end 6416142.
2022-01-23 9:50:04 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-01-23 9:50:05 0 [Note] InnoDB: Starting shutdown...
2022-01-23 9:50:05 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-01-23 9:50:05 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-01-23 9:50:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-23 9:50:05 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-01-23 9:50:05 0 [ERROR] Aborting

It looks like InnoDB: Missing MLOG_CHECKPOINT at 6416151 between the checkpoint 6416151 and the end 6416142. is the issue, but MLOG_CHECKPOINT doesn't show any results in a search of the forum.

Windows 11
XAMPP 7.4.24 portable

[jklaze]

It's been quite annoying to me too, but I figured out an easy workaround for when it happens: just delete all the 'ib_logfile' files.
I don't really know why this solves the problem but as long as I can work without having to export/import the db every week I won't mind about it.

[2nweb]

Thanks, I'll try that next time.

[skallsen]

The same problem for me, but removing the ib_logfile files is not fixing the issue.
I removed everything from xampp\mysql\data that this suggestion and other sources suggested.
Started Apache and then MySQL again, with these results:
8:58:37 PM [main] The FileZilla module is disabled
8:58:37 PM [main] The Mercury module is disabled
8:58:37 PM [main] The Tomcat module is disabled
8:58:37 PM [main] Starting Check-Timer
8:58:37 PM [main] Control Panel Ready
8:58:44 PM [Apache] Attempting to start Apache app...
8:58:45 PM [Apache] Status change detected: running
8:58:59 PM [mysql] Attempting to start MySQL app...
8:58:59 PM [mysql] Status change detected: running
8:59:01 PM [mysql] Status change detected: stopped
8:59:01 PM [mysql] Error: MySQL shutdown unexpectedly.
8:59:01 PM [mysql] This may be due to a blocked port, missing dependencies,
8:59:01 PM [mysql] improper privileges, a crash, or a shutdown by another method.
8:59:01 PM [mysql] Press the Logs button to view error logs and check
8:59:01 PM [mysql] the Windows Event Viewer for more clues
8:59:01 PM [mysql] If you need more help, copy and post this
8:59:01 PM [mysql] entire log window on the forums

and I end up with this in that same folder:

aria_log.00000004
aria_log_control
ib_buffer_pool
ib_logfile0
ib_logfile1
ibdata1
my.ini
mysql_error.log

The log:
2022-02-11 21:04:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-11 21:04:44 0 [Note] InnoDB: Uses event mutexes
2022-02-11 21:04:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-11 21:04:44 0 [Note] InnoDB: Number of pools: 1
2022-02-11 21:04:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-11 21:04:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-11 21:04:44 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-11 21:04:44 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2022-02-11 21:04:44 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2022-02-11 21:04:44 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2022-02-11 21:04:44 0 [Note] InnoDB: New log files created, LSN=5330462
2022-02-11 21:04:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-11 21:04:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-11 21:04:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-11 21:04:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-11 21:04:44 0 [Note] InnoDB: Waiting for purge to start
2022-02-11 21:04:44 0 [Note] InnoDB: 10.4.22 started; log sequence number 5330956; transaction id 2905
2022-02-11 21:04:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-11 21:04:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-11 21:04:44 0 [Note] Server socket created on IP: '::'.

I also tested it after changing my port to 3308, just to see if that was the issue, but it was not.

Thanks for offering any new advice!

[snehalatha1912]

This worked for me thanks