Unable to start SQL service

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

Unable to start SQL service

Postby pieter » 12. February 2015 12:03

I am unable start the MYSQL service. I seems to remember the first time i installed it the MySQL started and the Apache serive did not. I then re-installed it and ever since, only the apache serivce will start.
Here is the logs for MySQL, I have no idea what I am looking at. Please can someone assist me with this, it would be greatly appreciated.

2015-02-09 13:53:27 3916 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 13:53:27 e64 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.
2015-02-09 13:53:27 3916 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 13:53:27 3916 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 13:53:27 3916 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-09 13:53:27 3916 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 13:53:27 3916 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 13:53:27 3916 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-09 13:53:27 3916 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 13:53:27 3916 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 13:53:27 e64 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-09 13:53:27 3916 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-09 13:53:33 3652 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 13:53:33 c4 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.
2015-02-09 13:53:33 3652 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 13:53:33 3652 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 13:53:33 3652 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-09 13:53:33 3652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 13:53:33 3652 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 13:53:33 3652 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-09 13:53:33 3652 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 13:53:33 3652 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 13:53:33 c4 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-09 13:53:33 3652 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-09 14:07:54 1968 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 14:07:54 374 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.
2015-02-09 14:07:54 1968 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 14:07:54 1968 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 14:07:54 1968 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-09 14:07:54 1968 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 14:07:54 1968 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 14:07:54 1968 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-09 14:07:54 1968 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 14:07:54 1968 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 14:07:54 374 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-09 14:07:54 1968 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-09 14:07:56 5420 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 14:07:56 780 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.
2015-02-09 14:07:56 5420 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 14:07:56 5420 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 14:07:56 5420 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-09 14:07:56 5420 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 14:07:56 5420 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 14:07:56 5420 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-09 14:07:56 5420 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 14:07:56 5420 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 14:07:56 780 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-09 14:07:56 5420 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-09 16:23:42 5940 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 16:23:42 c34 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.
2015-02-09 16:23:42 5940 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 16:23:42 5940 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 16:23:42 5940 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-09 16:23:42 5940 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 16:23:42 5940 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 16:23:42 5940 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-09 16:23:42 5940 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 16:23:42 5940 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 16:23:42 c34 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-09 16:23:42 5940 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-09 16:23:52 2584 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 16:23:52 830 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.
2015-02-09 16:23:52 2584 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 16:23:52 2584 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 16:23:52 2584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-09 16:23:52 2584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 16:23:52 2584 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 16:23:52 2584 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-09 16:23:52 2584 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 16:23:52 2584 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 16:23:52 830 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-09 16:23:52 2584 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-12 12:30:36 7336 [Note] Plugin 'FEDERATED' is disabled.
2015-02-12 12:30:36 1d2c 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.
2015-02-12 12:30:36 7336 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-12 12:30:36 7336 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-12 12:30:36 7336 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-12 12:30:36 7336 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-12 12:30:36 7336 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-12 12:30:36 7336 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-12 12:30:36 7336 [Note] InnoDB: Completed initialization of buffer pool
2015-02-12 12:30:36 7336 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-12 12:30:36 1d2c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-12 12:30:36 7336 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-02-12 12:30:38 7320 [Note] Plugin 'FEDERATED' is disabled.
2015-02-12 12:30:38 1c6c 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.
2015-02-12 12:30:38 7320 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-12 12:30:38 7320 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-12 12:30:38 7320 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-12 12:30:38 7320 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-12 12:30:38 7320 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-12 12:30:38 7320 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-12 12:30:38 7320 [Note] InnoDB: Completed initialization of buffer pool
2015-02-12 12:30:38 7320 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-12 12:30:38 1c6c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-02-12 12:30:38 7320 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
pieter
 
Posts: 2
Joined: 12. February 2015 11:39
Operating System: Windows 8.1

Re: Unable to start SQL service

Postby pieter » 17. February 2015 13:03

bump? :cry:
pieter
 
Posts: 2
Joined: 12. February 2015 11:39
Operating System: Windows 8.1

Re: Unable to start SQL service

Postby Altrea » 17. February 2015 19:57

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 137 guests