mySQL does not start anymore

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

mySQL does not start anymore

Postby maxbobse » 23. September 2022 21:56

Hi,

Without having made any major changes to the DB, it stopped starting now after I have restarted the computer. The log shows

Code: Select all
2022-09-23 22:48:40 22952 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2022-09-23 22:48:40 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2022-09-23 22:48:40 0 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.4.21-MariaDB) starting as process 23104 ...
2022-09-23 22:48:40 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2022-09-23 22:48:40 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-23 22:48:40 0 [Note] InnoDB: Uses event mutexes
2022-09-23 22:48:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 22:48:40 0 [Note] InnoDB: Number of pools: 1
2022-09-23 22:48:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 22:48:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-23 22:48:40 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 22:48:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4061302
2022-09-23 22:48:40 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 4061302 between the checkpoint 4061302 and the end 4061311.
2022-09-23 22:48:40 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-09-23 22:48:40 0 [Note] InnoDB: Starting shutdown...
2022-09-23 22:48:40 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-09-23 22:48:40 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-09-23 22:48:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 22:48:40 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-09-23 22:48:40 0 [ERROR] Aborting
2022-09-23 22:48:40 22952 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/MacBook-Pro.local.pid ended


I have already tried to install a fresh version of XAMPP and that launched the mySQL server properly but when I replace the xamppfiles/var/mysql folder with the one from the old XAMPP installation, it crashes again.

Any idea how to fix this?

Max
maxbobse
 
Posts: 2
Joined: 20. May 2019 19:43
XAMPP version: 8.1.6
Operating System: Ubuntu/macOS

Re: mySQL does not start anymore

Postby JDLH » 25. September 2022 11:05

Someone reported a problem with a similar error message at https://dba.stackexchange.com/questions/163445/innodb-ignoring-the-redo-log-due-to-missing-mlog-checkpoint .

There is a solution posted there, which is to delete the redo log's files at `/Applications/XAMPP/xamppfiles/var/mysql/ib_logfile*`. But a comment warns, 'Please be aware that when you remove these files you are deleting the redo log, which means if the server was very active when it went down you will lose transactions and possibly corrupt the server. Some have reported that "it works for me" because it's harmless on a server with no load, but in production trying to start a crashed server by removing the innodb log files will almost certainly result in data loss and other problems.' So, make your own risk assessment and your own decision.
JDLH
 
Posts: 23
Joined: 11. September 2022 02:27
XAMPP version: 7.4
Operating System: macOS 12.6


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 27 guests