When you start the XAMPP after a long break of up to 1/2 months.
You will get the error:
mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
Advertisement
MySql errors:
2018-05-07 19:36:12 1f84 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-05-07 19:36:12 8068 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2018-05-07 19:36:12 8068 [Note] InnoDB: The InnoDB memory heap is disabled 2018-05-07 19:36:12 8068 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-05-07 19:36:12 8068 [Note] InnoDB: Memory barrier is not used 2018-05-07 19:36:12 8068 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-07 19:36:12 8068 [Note] InnoDB: Using generic crc32 instructions 2018-05-07 19:36:12 8068 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2018-05-07 19:36:12 8068 [Note] InnoDB: Completed initialization of buffer pool 2018-05-07 19:36:12 8068 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-07 19:36:15 8068 [Note] InnoDB: 128 rollback segment(s) are active. 2018-05-07 19:36:15 8068 [Note] InnoDB: Waiting for purge to start 2018-05-07 19:36:15 8068 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 736124072 2018-05-07 19:36:15 4532 [Note] InnoDB: Dumping buffer pool(s) not yet started Cannot find checkpoint record at LSN (1,0x2e77) 2018-05-07 19:36:15 8068 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files 2018-05-07 19:36:15 8068 [ERROR] Plugin 'Aria' init function returned error. 2018-05-07 19:36:15 8068 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2018-05-07 19:36:15 8068 [Note] Plugin 'FEEDBACK' is disabled. 2018-05-07 19:36:15 8068 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables 2018-05-07 19:36:15 8068 [ERROR] Aborting
Solution Solution
To fix this error do:
- Step 1: Go to \mysql\data\ where the xampp is installed.
In my case, it was installed at D:\xampp\mysql\data\ - Step 2: Find and Deleted the file aria_log.00000001