XAMPP MySQL shutdown unexpectedly. Please help.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP MySQL shutdown unexpectedly. Please help.

Postby SQLfriendly » 18. May 2022 15:30

Hi, please help me fix this error. I don't know what to do. Here is the error log. Thanks!

Cannot find checkpoint record at LSN (1,0x55ae)
2022-05-18 22:45:43 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-05-18 22:45:43 0 [ERROR] Plugin 'Aria' init function returned error.
2022-05-18 22:45:43 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-05-18 22:45:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-05-18 22:45:43 0 [Note] InnoDB: Uses event mutexes
2022-05-18 22:45:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-18 22:45:43 0 [Note] InnoDB: Number of pools: 1
2022-05-18 22:45:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-05-18 22:45:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-05-18 22:45:43 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-18 22:45:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-05-18 22:45:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-18 22:45:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-18 22:45:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-05-18 22:45:44 0 [Note] InnoDB: Waiting for purge to start
2022-05-18 22:45:44 0 [Note] InnoDB: 10.4.24 started; log sequence number 42143099; transaction id 16685
2022-05-18 22:45:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-05-18 22:45:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-18 22:45:44 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-05-18 22:45:44 0 [ERROR] Failed to initialize plugins.
2022-05-18 22:45:44 0 [ERROR] Aborting
SQLfriendly
 
Posts: 1
Joined: 18. May 2022 15:18
XAMPP version: x-64-8.1.5
Operating System: Windows

Re: XAMPP MySQL shutdown unexpectedly. Please help.

Postby Winfif » 24. June 2022 15:33

I think you should read about the 321 backup strategy. In this case, it can help you solve your file recovery problem.
Winfif
 
Posts: 5
Joined: 17. June 2022 18:06
XAMPP version: 8.0.19
Operating System: Windows 10

Re: XAMPP MySQL shutdown unexpectedly. Please help.

Postby Froosh » 25. June 2022 19:47

Having good backups is always a good idea. If you are unsure what to do based on the error, is it because you are not up on SQL or MySQL? If so, then correcting the error might present a bit of a challenge. If you search around on the board, others have had this issue, and there are solutions, but those expect that you are comfortable with using mysql from the command line. Rather than repeating the information here, search the board.

Not sure if this specifically applies to the issue you are experiencing, or your situation, but previously I had MySQL database corruption issues where the database would not start. This happened a number of times, despite my having use the XAMPP Control Panel to stop MySQL. Each time the database had issues, I was able to correct from the command line, but often just days later I would again have a crashed database. About two months back, when the issue last happened, I switched to running MySQL as a Windows Service. Since then, I have not encountered any issues with the database. I highly recommend that if you are using XAMPP on Windows, that you configure at least MySQL to run as a Windows Service.
User avatar
Froosh
 
Posts: 138
Joined: 27. March 2022 17:56
XAMPP version: 8.2.0
Operating System: Windows 11 Pro

Re: XAMPP MySQL shutdown unexpectedly. Please help.

Postby GabrielLuke » 28. June 2022 08:21

I restarted, and xampp now runs without errors. So xampp is now fully operational. When I try to open phpMyAdmin,

I did choose to install MySQL as a service, and both (mysql and Apache) are now listed as "started" in the Windows Services menu. I no longer have any port errors. The new problem is connecting phpMyAdmin to xampp. If anyone could explain that error and its solution, I'd be grateful.
GabrielLuke
 
Posts: 12
Joined: 02. August 2021 12:20
XAMPP version: 3.2.4
Operating System: Windows 10

Re: XAMPP MySQL shutdown unexpectedly. Please help.

Postby Nobbie » 28. June 2022 13:13

I dont see any problem.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 115 guests