(Solved) mysqld exe aria recovery failed

Advertisement

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

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

Leave a Reply