MYSQL problem

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

MYSQL problem

Postby mojojojo » 20. April 2016 02:32

LOG


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

2016-04-20 02:15:29 2374 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.
2016-04-20 2:15:30 9076 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-04-20 2:15:30 9076 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-20 2:15:30 9076 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-04-20 2:15:30 9076 [Note] InnoDB: Memory barrier is not used
2016-04-20 2:15:30 9076 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-20 2:15:30 9076 [Note] InnoDB: Using generic crc32 instructions
2016-04-20 2:15:30 9076 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-04-20 2:15:30 9076 [Note] InnoDB: Completed initialization of buffer pool
2016-04-20 2:15:30 9076 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-20 2:15:31 9076 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-20 2:15:31 9076 [Note] InnoDB: Waiting for purge to start
2016-04-20 2:15:31 9076 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1835037
2016-04-20 2:15:31 6072 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-04-20 2:15:31 9076 [Note] Plugin 'FEEDBACK' is disabled.
2016-04-20 2:15:31 9076 [Note] Server socket created on IP: '::'.
2016-04-20 2:15:31 9076 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-04-20 2:15:31 9076 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-04-20 2:15:31 9076 [ERROR] Aborting

2016-04-20 02:22:13 2f90 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.
2016-04-20 2:22:14 12176 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-04-20 2:22:14 12176 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-20 2:22:14 12176 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-04-20 2:22:14 12176 [Note] InnoDB: Memory barrier is not used
2016-04-20 2:22:14 12176 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-20 2:22:14 12176 [Note] InnoDB: Using generic crc32 instructions
2016-04-20 2:22:14 12176 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-04-20 2:22:14 12176 [Note] InnoDB: Completed initialization of buffer pool
2016-04-20 2:22:14 12176 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-20 2:22:15 12176 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-20 2:22:15 12176 [Note] InnoDB: Waiting for purge to start
2016-04-20 2:22:15 12176 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1835047
2016-04-20 2:22:15 9912 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-04-20 2:22:15 12176 [Note] Plugin 'FEEDBACK' is disabled.
2016-04-20 2:22:15 12176 [Note] Server socket created on IP: '::'.
2016-04-20 2:22:15 12176 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-04-20 2:22:15 12176 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-04-20 2:22:15 12176 [ERROR] Aborting

2016-04-20 02:24:06 2ca4 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.
2016-04-20 2:24:06 11428 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-04-20 2:24:06 11428 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-20 2:24:06 11428 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-04-20 2:24:06 11428 [Note] InnoDB: Memory barrier is not used
2016-04-20 2:24:06 11428 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-20 2:24:06 11428 [Note] InnoDB: Using generic crc32 instructions
2016-04-20 2:24:06 11428 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-04-20 2:24:06 11428 [Note] InnoDB: Completed initialization of buffer pool
2016-04-20 2:24:06 11428 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-20 2:24:07 11428 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-20 2:24:07 11428 [Note] InnoDB: Waiting for purge to start
2016-04-20 2:24:07 11428 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1835057
2016-04-20 2:24:07 8276 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-04-20 2:24:07 11428 [Note] Plugin 'FEEDBACK' is disabled.
2016-04-20 2:24:07 11428 [Note] Server socket created on IP: '::'.
2016-04-20 2:24:07 11428 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-04-20 2:24:07 11428 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-04-20 2:24:07 11428 [ERROR] Aborting
mojojojo
 
Posts: 3
Joined: 20. April 2016 02:29
XAMPP version: 3.2.2
Operating System: windows

Re: MYSQL problem

Postby Altrea » 20. April 2016 06:04

mojojojo wrote:2016-04-20 2:24:07 11428 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-04-20 2:24:07 11428 [ERROR] Aborting

So do you? Obviously there is a program already blocking port 3306, commonly another MariaDB or MySQL Server.
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: MYSQL problem

Postby mojojojo » 20. April 2016 11:49

Altrea wrote:
mojojojo wrote:2016-04-20 2:24:07 11428 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-04-20 2:24:07 11428 [ERROR] Aborting

So do you? Obviously there is a program already blocking port 3306, commonly another MariaDB or MySQL Server.


I have another MYSQL program but I stopped it running and it still gives me the same error.
mojojojo
 
Posts: 3
Joined: 20. April 2016 02:29
XAMPP version: 3.2.2
Operating System: windows

Re: MYSQL problem

Postby Altrea » 20. April 2016 13:05

Well, you should check which process is capturing your port 3306.
MySQL/MariaDB cannot start without having this port free
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 109 guests