Page 1 of 1

MYSQL problem

PostPosted: 20. April 2016 02:32
by mojojojo
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

Re: MYSQL problem

PostPosted: 20. April 2016 06:04
by Altrea
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.

Re: MYSQL problem

PostPosted: 20. April 2016 11:49
by mojojojo
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.

Re: MYSQL problem

PostPosted: 20. April 2016 13:05
by Altrea
Well, you should check which process is capturing your port 3306.
MySQL/MariaDB cannot start without having this port free