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

How to execute PHP files on LOCALHOST using WAMP, MAMP or XAMPP?

In this tutorial I will show you how to Execute PHP files using WAMP.

Note: Execution procedure of PHP files on WAMP, MAMP and XAMPP are similler.

Continue reading “How to execute PHP files on LOCALHOST using WAMP, MAMP or XAMPP?”