mySQL crashing

[gennacrab]

Having the same issue today. Its fully crashing. nothing has changed since yesterday, although i could not connect to my server yesterday through php script, and I couldn't find any other errors.

I have done the steps you mentioned above and this is what the output was.

mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-04-18 17:02:26 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.
2023-04-18 17:02:26 0 [Note] mysqld (mysqld 10.4.27-MariaDB) starting as process 29292 ...
Cannot find checkpoint record at LSN (1,0x6948)
2023-04-18 17:02:26 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2023-04-18 17:02:26 0 [ERROR] Plugin 'Aria' init function returned error.
2023-04-18 17:02:26 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-04-18 17:02:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-18 17:02:26 0 [Note] InnoDB: Uses event mutexes
2023-04-18 17:02:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-04-18 17:02:26 0 [Note] InnoDB: Number of pools: 1
2023-04-18 17:02:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-18 17:02:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-18 17:02:26 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-18 17:02:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-18 17:02:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-18 17:02:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-18 17:02:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-18 17:02:26 0 [Note] InnoDB: Waiting for purge to start
2023-04-18 17:02:26 0 [Note] InnoDB: 10.4.27 started; log sequence number 512255; transaction id 699
2023-04-18 17:02:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-18 17:02:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-18 17:02:26 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2023-04-18 17:02:26 0 [Note] InnoDB: Buffer pool(s) load completed at 230418 17:02:26
2023-04-18 17:02:26 0 [ERROR] Failed to initialize plugins.
2023-04-18 17:02:26 0 [ERROR] Aborting

[Altrea]

Hi,

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

For some users, simply deleting the file \xampp\mysql\data\aria_log_control did fix it.
Some others needed to delete the aria_log.00000001, aria_log.00000002, etc. files in the same folder too.
Some users needed to execute the command aria_chk -r mysql\*.MAI in the XAMPP shell too.