ERROR by MySQL

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

ERROR by MySQL

Postby ItsJustSem » 01. May 2016 16:15

2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

_________________

What do I have to do. please help me
ItsJustSem
 
Posts: 1
Joined: 01. May 2016 16:13
XAMPP version: 3.2.2
Operating System: Windows 10

Re: ERROR by MySQL

Postby JJ_Tagy » 01. May 2016 18:12

Depends on what you think the problem is. I don't see any errors.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: ERROR by MySQL

Postby Joergi » 02. May 2016 15:21

There is this warning about InnoDB in the log:

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.

You can solve this by simply removing the line with innodb_additional_mem_pool_size from your my.ini file.

I have already reported this issue at viewtopic.php?f=16&t=71532. However, it seems like no one cares.
Joergi
 
Posts: 10
Joined: 16. August 2015 21:12
Operating System: W

Re: ERROR by MySQL

Postby Nobbie » 02. May 2016 15:52

Joergi wrote:I have already reported this issue at viewtopic.php?f=16&t=71532. However, it seems like no one cares.


Its only a warning and it does not change the behaviour of the Xampp Installation. It is definately not the reason for any reported problems.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: ERROR by MySQL

Postby KavanaLiberty » 12. October 2016 13:17

You can solve this by simply removing the line with innodb_additional_mem_pool_size from your my.ini file.


After i do this i try to start MySQL up and it still gives the error.
I am also left with this part of the note messages and added error messages in the log:

[Note] InnoDB: Using mutexes to ref count buffer pool pages
[Note] InnoDB: The InnoDB memory heap is disabled
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Memory barrier is not used
[Note] InnoDB: Compressed tables use zlib 1.2.3
[Note] InnoDB: Not using CPU crc32 instructions
[Note] InnoDB: Initializing buffer pool, size = 16.0M
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: Highest supported file format is Barracuda.
[Note] InnoDB: The log sequence numbers 958722572 and 958722572 in ibdata files do not match the log sequence number 4779447055 in the ib_logfiles!
[Note] InnoDB: Database was not shutdown normally!
[Note] InnoDB: Starting crash recovery.
[Note] InnoDB: Reading tablespace information from the .ibd files...
[Note] InnoDB: Restoring possible half-written data pages
[Note] InnoDB: from the doublewrite buffer...
[Note] InnoDB: 128 rollback segment(s) are active.
[Note] InnoDB: Waiting for purge to start
[Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 4779447055
[Note] Plugin 'FEEDBACK' is disabled.
[Note] Server socket created on IP: '::'.


What to do now?
KavanaLiberty
 
Posts: 2
Joined: 12. October 2016 12:40
XAMPP version: 3.2.1
Operating System: win 10

Re: ERROR by MySQL

Postby Altrea » 12. October 2016 20:03

There is no error message in that log.
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

Re: ERROR by MySQL

Postby KavanaLiberty » 13. October 2016 12:14

and added error messages in the log
sorry, this part was wrong. There are no error messages in my log any more. Just what i posted and MySQL still stops working after a second.
KavanaLiberty
 
Posts: 2
Joined: 12. October 2016 12:40
XAMPP version: 3.2.1
Operating System: win 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 131 guests