How to fix Error: MySQL shutdown unexpectedly on Xampp due to Plugin 'Aria'

Question

These were the logs:

[ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files [ERROR] Plugin 'Aria' init function returned error. [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

Solution 1

The solution is Removing the aria_log_control file allowed MariaDB to start again. You can find this file in \xampp\mysql\data. Then restart or start xammp.

Solution 2

If XAMPP generated following logs

[Note] Plugin 'FEEDBACK' is disabled.

[ERROR] j:\xampp\mysql\bin\mysqld.exe: unknown option '--skip-federated'

[ERROR] Aborting

Try to run MySQL with the following command

**mysqld.exe --skip-federated**

Hope this helps!! Good Luck!!

Comments

[Oscar]

why happend this?

[Avinash]

This works! Thanks! But why this is happening suddenly??

[Mahendra Jella]

It's worked for me and what's the permanent solution for this issue.

[Obmerk Kronen]

+1 worked for me, in my case the file i renamed was aria_log.00000001 and upon relaunch there was another file created immediately with prefix .00000002 . still would be great to know what causes it

[MazeStricks]

This worked from my end also. I wonder what is causing this issue. But thanks for the solution!

[Võ Minh]

just wondered, is it a bug in xampp when use it for long time and log stack up cause the error.

[Haritsinh Gohil]

@ObmerkKronen,@MazeStricks i have faced same issue, so in my case probably it happened because i have opened xampp multiple times, i am not sure it happened because of that but maybe running xampp multiple time can be cause of that.

[Obmerk Kronen]

@HaritsinhGohil . thiss should not be a problem because the the UI is just a UI, it just verify the services / ports and gives you buttons to open / stop. YOu can open 3 GUI's ( at least I did ) and nothing should change.

[Haritsinh Gohil]

Yes, @ObmerkKronen, its just UI, But UI is the way to start a process, for e.g. if you have opened xampp two times then localhost will not work , you have to quit from both of them , then you have to start it again to run localhost, in my case i have auto start apache and mysql services on opening of xampp. but if you dont have auto-start services then it will not be a problem to open it multiple times.

[Obmerk Kronen]

@HaritsinhGohil . if the problem is that you have double services then just delete ( or just uncheck them in the ui - never tried myself but I imagine should work ) but as far as the original solution - it did work for me several times.

[Haritsinh Gohil]

@ObmerkKronen , the above solution also worked for me but i am only saying that because of running double services can be the cause of this unexpected shutdown.

[Admin]

how would that be on ampps?

[Zobia Kanwal]

@German Alfonso Thanks a bunch! It resolved my issue.

[user2587656]

This didn't work for me. The aria error disappeared but my database remained defect. The message in the Xampp console remained the same. There was only a difference in the messages in the mysql_error.log file.