Fix "Aria recovery failed" in MySQL when using XAMPP
This solution should also work if you don't use XAMPP, however I will show you how to fix it in XAMPP in this article.
So this error was a pain to get through, especially if you are not an expert in solving XAMPP issues and also if you have never heard about the Aria storage engine in MySQL. However don't fear it anymore I will show you how to fix this issue in a simple way!
This is the error i get:
| 2023-03-18 13:12:50 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files | |
| 2023-03-18 13:12:50 0 [ERROR] Plugin 'Aria' init function returned error. | |
| 2023-03-18 13:12:50 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Uses event mutexes | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Number of pools: 1 | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Using SSE2 crc32 instructions | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Completed initialization of buffer pool | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Waiting for purge to start | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: 10.4.27 started; log sequence number 5356854; transaction id 1439 | |
| 2023-03-18 13:12:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool | |
| 2023-03-18 13:12:50 0 [Note] Plugin 'FEEDBACK' is disabled. | |
| 2023-03-18 13:12:50 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded | |
| 2023-03-18 13:12:50 0 [ERROR] Failed to initialize plugins. | |
| 2023-03-18 13:12:50 0 [ERROR] Aborting |
We need to fix this over 2 steps.
Step 1 - Delete aria_log files
First stop the Apache server and go to this path in your File Explorer:
| C:\xampp\mysql\data |
In here you want to delete the following files if you see them:
- aria_log.00000001
- aria_log_control
Step 2 - Run repair script
So to repair/check the aria storage engine you need to execute/run the aria_chk.exe file and run it against the mysql folder that contains .MAI files.
To do that, use the following command to navigate to the bin folder:
| cd C:\xampp\mysql\bin |
When you are in the bin folder, run this command to execute the repair/check file:
| .\aria_chk -r C:\xampp\mysql\data\mysql\*.MAI |
You should now be able to start the apache server and also to run MySQL.
Like what you see?
