mysql just dont start anymore

[raderack]

here is the log

Code: Select all

Cannot find checkpoint record at LSN (1,0x5ce7)
2020-05-30 14:49:10 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2020-05-30 14:49:10 0 [ERROR] Plugin 'Aria' init function returned error.
2020-05-30 14:49:10 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2020-05-30 14:49:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-30 14:49:10 0 [Note] InnoDB: Uses event mutexes
2020-05-30 14:49:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-30 14:49:10 0 [Note] InnoDB: Number of pools: 1
2020-05-30 14:49:10 0 [Note] InnoDB: Using generic crc32 instructions
2020-05-30 14:49:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-05-30 14:49:10 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-30 14:49:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-30 14:49:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-30 14:49:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-05-30 14:49:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-05-30 14:49:10 0 [Note] InnoDB: Waiting for purge to start
2020-05-30 14:49:10 0 [Note] InnoDB: 10.4.11 started; log sequence number 11028549; transaction id 12242
2020-05-30 14:49:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-05-30 14:49:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-30 14:49:10 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-05-30 14:49:10 0 [ERROR] Failed to initialize plugins.
2020-05-30 14:49:10 0 [ERROR] Aborting


[raderack]

did the aria_chk -r in command line,didint work

[raderack]

no one to help?

[raderack]

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.