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 use PHP for Developing Dynamic Website?

[ NOTE: This article just show concept of how to use php for developing dynamic Websites.]

 [ NOTE: If you want to know how php execute practically, Please visit our PRACTICLE tutorial “How to execute PHP files on LOCALHOST using WAMP, MAMP or XAMPP?”  It shows you how to execute php files on LOCAL computer. It also show which software’s and tools used for doing it. ]

Continue reading “How to use PHP for Developing Dynamic Website?”

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?”

How to install wordpress on WAMP, MAMP or XAMPP?

Follow these few COMMON steps to install wordpress on WAMP, MAMP and XAMPP.

Section-1 Download & Unzip wordpress on localhost

Section-2 Creating database for wordpress

Section-3 Installation of wordpress

Section-4 Change Default theme of wordpress

Continue reading “How to install wordpress on WAMP, MAMP or XAMPP?”