PlaceOweb Dotclear

MySQL (MariaDB) ne se lance plus, dans son fichier de log : mysql_error.log Il indique :

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

Pour ma part, en effaçant les fichier : aria_log.00000001, aria_log_control, master-*, mysql-relay-bin-* cela m'a permis de relancer le service MariaDB.

Supposément la suppression de uniquement les fichiers aria_log.* aurait plus adéquate comme indiqué dans le log.

MySQL not starting up

Delete all the files from /Applications/AMPPS/var/ like mysql-bin.*, mysql-bin.index, ib*, etc and try starting the mysql server. DONT REMOVE ANY FOLDER.

Mais le problème est de retour !

MariaDB [(none)]> REPAIR TABLE `mysql`.`columns_priv`;
+--------------------+--------+----------+--------------------------------------------------------------------------------------------------------+
| Table              | Op     | Msg_type | Msg_text                                                                                               |
+--------------------+--------+----------+--------------------------------------------------------------------------------------------------------+
| mysql.columns_priv | repair | error    | aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384  rows: 234  sort_length: 1006 |
| mysql.columns_priv | repair | error    | Create index by sort failed                                                                            |
| mysql.columns_priv | repair | info     | Retrying repair with keycache                                                                          |
| mysql.columns_priv | repair | status   | OK                                                                                                     |
+--------------------+--------+----------+--------------------------------------------------------------------------------------------------------+



ALTER TABLE `columns_priv` ADD INDEX(`User`);
ALTER TABLE `columns_priv` DROP INDEX `User`; 

INSERT INTO `columns_priv` (`Host`, `Db`, `User`, `Table_name`, `Column_name`, `Timestamp`, `Column_priv`) VALUES
('60', 'node_js_express_mysql', 'dqs', 'qsd', 'qsd', '2025-06-29 11:20:39', 'Select,Insert,Update');

MariaDB [(none)]> REPAIR TABLE `mysql`.`columns_priv`;
+--------------------+--------+----------+----------+ne
| Table              | Op     | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| mysql.columns_priv | repair | status   | OK       |
+--------------------+--------+----------+----------+
1 row in set (0.007 sec)

DELETE FROM `columns_priv` WHERE `columns_priv`.`Host` = '60' AND `columns_priv`.`Db` = 'node_js_express_mysql' AND `columns_priv`.`User` = 'dqs' AND `columns_priv`.`Table_name` = 'qsd' AND `columns_priv`.`Column_name` = 'qsd';

MariaDB [(none)]> REPAIR TABLE `mysql`.`columns_priv`;
+--------------------+--------+----------+----------+ne
| Table              | Op     | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| mysql.columns_priv | repair | status   | OK       |
+--------------------+--------+----------+----------+
1 row in set (0.006 sec)

MariaDB [(none)]> ANALYZE TABLE `mysql`.`columns_priv`;
+--------------------+---------+----------+-----------------------------+
| Table              | Op      | Msg_type | Msg_text                    |
+--------------------+---------+----------+-----------------------------+
| mysql.columns_priv | analyze | status   | Table is already up to date |
+--------------------+---------+----------+-----------------------------+
1 row in set (0.001 sec)

MariaDB [(none)]> select version();
+-----------------+
| version()       |
+-----------------+
| 10.4.32-MariaDB |
+-----------------+

MariaDB [(none)]> SHOW VARIABLES LIKE '%sort_buffer_size';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| aria_sort_buffer_size   | 268434432 | -- https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_sort_buffer_size
| innodb_sort_buffer_size | 1048576   |
| myisam_sort_buffer_size | 8388608   |
| sort_buffer_size        | 524288    |
+-------------------------+-----------+
4 rows in set (0.001 sec)

MariaDB [(none)]> SHUTDOWN;
Query OK, 0 rows affected (0.000 sec)


REPAIR TABLE `mysql`.`columns_priv`;
+--------------------+--------+----------+--------------------------------------------------------------------------------------------------------+
| Table              | Op     | Msg_type | Msg_text                                                                                               |
+--------------------+--------+----------+--------------------------------------------------------------------------------------------------------+
| mysql.columns_priv | repair | error    | aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384  rows: 234  sort_length: 1006 |
| mysql.columns_priv | repair | error    | Create index by sort failed                                                                            |
| mysql.columns_priv | repair | info     | Retrying repair with keycache                                                                          |
| mysql.columns_priv | repair | status   | OK                                                                                                     |
+--------------------+--------+----------+--------------------------------------------------------------------------------------------------------+
4 rows in set (0.010 sec)

D:\xampp_82\mysql\data\mysql>..\..\bin\aria_chk -r columns_priv
..\..\bin\aria_chk: Got error 'Can't find file' when trying to use aria control file '.\aria_log_control'
- recovering (with sort) Aria-table 'columns_priv'
Data records: 0
- Fixing index 1
aria_chk: error: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384  rows: 234  sort_length: 1006
aria_chk: error: Create index by sort failed
State updated
Aria table 'columns_priv' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

Fix mysqld.exe: Aria recovery failed. Please run aria_chk -r

Lately I have been working on a virtual windows machine where XAMPP is more stable than it is on macOS. 
But all of a sudden, it started throwing errors. I was not able to start MySQL.

I checked mysql_error.log and I saw the issue saying:
mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables

Here is the fix if you ever come across such error:

You should go to your xampp folder.

Find folder xampp/mysql/data

There you will find the file:

aria_log_control

Xampp database broken two or three times per week The issue disappeared when I uninstalled the local MySQL server (not the one included in the Xampp installation). If you have a separate MySQL installation, you should try removing it from the environment variables. The MySQL server included in Xampp works perfectly after t

aria_chk -r cannot work on default system tables as aria_sort_buffer_size too small

XAMPP MariaDB crashed during editing Elementor page and now won't restart et How can I solve "Error: MySQL shutdown unexpectedly"?