Unable to load MySQL Service

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unable to load MySQL Service

Postby loaoa » 26. June 2018 12:05

Hi,

I'm using XAMPP v3.2.2 and i'm unable to load MySQL Service. I have run aria_chk -r but it doesn't do anything

Here is the mysql_error.log
Code: Select all
2018-06-26 11:59:09 1f78 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-06-26 11:59:09 8056 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-26 11:59:09 8056 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-26 11:59:09 8056 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-26 11:59:09 8056 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-06-26 11:59:09 8056 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-06-26 11:59:09 8056 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-06-26 11:59:09 8056 [Note] InnoDB: Using generic crc32 instructions
2018-06-26 11:59:09 8056 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-06-26 11:59:09 8056 [Note] InnoDB: Completed initialization of buffer pool
2018-06-26 11:59:09 8056 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-26 11:59:10 8056 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-26 11:59:10 8056 [Note] InnoDB: Waiting for purge to start
2018-06-26 11:59:10 8056 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 199731285
2018-06-26 11:59:10 7632 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20b7)

2018-06-26 11:59:10 8056 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2018-06-26 11:59:10 8056 [ERROR] Plugin 'Aria' init function returned error.
2018-06-26 11:59:10 8056 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2018-06-26 11:59:10 8056 [Note] Plugin 'FEEDBACK' is disabled.
2018-06-26 11:59:10 8056 [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-06-26 11:59:10 8056 [ERROR] Aborting


Also i have backup
xampp/htdocs
xampp/mysql/data

Thanks
loaoa
 
Posts: 4
Joined: 29. September 2017 22:07
XAMPP version: 3.1.0
Operating System: Win

Re: Unable to load MySQL Service

Postby TonyVier » 26. June 2018 16:54

The solution is Removing the aria_log_control file allowed MariaDB to start again. You can find this file in \xampp\mysql\data. Then restart or start xammp.


I googled it :shock:

https://stackoverflow.com/questions/411 ... lugin-aria
TonyVier
 
Posts: 43
Joined: 24. May 2018 11:22
XAMPP version: 7.2.5-0
Operating System: Windows 10 pro

Re: Unable to load MySQL Service

Postby loaoa » 27. June 2018 22:01

Thanks, it works again.
(I did search on google before making the question but didn't found any solution)
loaoa
 
Posts: 4
Joined: 29. September 2017 22:07
XAMPP version: 3.1.0
Operating System: Win


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 57 guests