mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files

While I have started the XAMPP after a long break up to 1/2 months and I got the error ‘mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files’.

To fix this error I have deleted the file aria_log.00000001 from location D:\xampp\mysql\data\


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

 

Advertisements

Author: Mahesh Waghmare

I'm a professional WordPress theme/plugin developer since 2012.

One thought on “mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files”

  1. Thank you so much for this post. Had tried different solutions, but this one worked for me. MySql started fine but I get similar error for Apache 🙂

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.