MySql not starting

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySql not starting

Postby poojashingala » 21. September 2016 14:05

I am attaching the logs. Please tell me how to resolve the error

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-09-21 17:19:17 c64 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-09-21 17:19:17 3172 [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.

2016-09-21 17:19:17 3172 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:17 3172 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:17 3172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:17 3172 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:17 3172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:17 3172 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:17 3172 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ib5478.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:17 c64 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:17 3172 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:17 3172 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:17 3172 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:17 3172 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:17 3172 [ERROR] Aborting

2016-09-21 17:19:38 a30 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-09-21 17:19:38 2608 [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.

2016-09-21 17:19:38 2608 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:38 2608 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:38 2608 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:38 2608 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:38 2608 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:38 2608 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:38 2608 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibA4EA.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:38 a30 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:38 2608 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:38 2608 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:38 2608 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:38 2608 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:38 2608 [ERROR] Aborting

2016-09-21 17:19:49 a24 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-09-21 17:19:49 2596 [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.

2016-09-21 17:19:49 2596 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:49 2596 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:49 2596 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:49 2596 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:49 2596 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:49 2596 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:49 2596 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibCFA3.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:49 a24 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:49 2596 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:49 2596 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:49 2596 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:49 2596 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:49 2596 [ERROR] Aborting

2016-09-21 17:19:50 1598 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-09-21 17:19:50 5528 [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.

2016-09-21 17:19:50 5528 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:50 5528 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:50 5528 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:50 5528 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:50 5528 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:50 5528 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:50 5528 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibD59E.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:50 1598 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:50 5528 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:50 5528 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:50 5528 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:50 5528 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:50 5528 [ERROR] Aborting

2016-09-21 17:19:55 a8c 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-09-21 17:19:55 2700 [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.

2016-09-21 17:19:55 2700 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:55 2700 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:55 2700 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:55 2700 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:55 2700 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:55 2700 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:55 2700 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibE8A9.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:55 a8c InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:55 2700 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:55 2700 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:55 2700 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:55 2700 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:55 2700 [ERROR] Aborting

2016-09-21 18:17:20 1294 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-09-21 18:17:20 4756 [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.

2016-09-21 18:17:20 4756 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 18:17:20 4756 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 18:17:20 4756 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 18:17:20 4756 [Note] InnoDB: Memory barrier is not used
2016-09-21 18:17:20 4756 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 18:17:20 4756 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 18:17:20 4756 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ib78D7.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 18:17:20 1294 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 18:17:20 4756 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 18:17:20 4756 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 18:17:20 4756 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 18:17:20 4756 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 18:17:20 4756 [ERROR] Aborting
poojashingala
 
Posts: 1
Joined: 21. September 2016 13:55
XAMPP version: v3.2.2
Operating System: windows 8

Re: MySql not starting

Postby Nobbie » 21. September 2016 21:22

Did you read these error messages? You should do so. There is one very important error message (its a repeating error), did you see that? It contains a huge hint, what might go wrong, open your eyes and your mind! Help yourself, analyze that message and find out, what is going wrong there.

Tell us, what you found out.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: MySql not starting

Postby Ghafoer86 » 24. September 2016 15:10

MAYBE IT'S CAN SOLVED THE PROBLEM. CHANGE THE SOCKET/PORT FOR MYSQL.
Never Stop Learning. Make Different's Style. Leading The Innovation.
User avatar
Ghafoer86
 
Posts: 22
Joined: 12. August 2013 17:39
Location: Indonesia - southeast ASIA (City : Palu Province : Central Sulawesi)
XAMPP version: online
Operating System: Android

Re: MySql not starting

Postby Altrea » 24. September 2016 15:33

Ghafoer86 wrote:MAYBE IT'S CAN SOLVED THE PROBLEM. CHANGE THE SOCKET/PORT FOR MYSQL.

definitively not. The logs already mentioned the real problem.

btw: You can also use small type. Read more about this wth help of your favorite search engine: "all caps netiquette"
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 not starting

Postby esmeralda_imel » 15. June 2017 14:13

7:55:57 PM [mysql] Error: MySQL shutdown unexpectedly.
7:55:57 PM [mysql] This may be due to a blocked port, missing dependencies,
7:55:57 PM [mysql] improper privileges, a crash, or a shutdown by another method.
7:55:57 PM [mysql] Press the Logs button to view error logs and check
7:55:57 PM [mysql] the Windows Event Viewer for more clues
7:55:57 PM [mysql] If you need more help, copy and post this
7:55:57 PM [mysql] entire log window on the forums

:( :( :( help
esmeralda_imel
 
Posts: 1
Joined: 15. June 2017 14:01
Location: Batam
XAMPP version: 5.6.30.1
Operating System: Windows 7 32 bit

Re: MySql not starting

Postby HokuApps » 24. November 2017 06:59

You can change port number for mysql.
HokuApps
 
Posts: 22
Joined: 11. September 2017 07:23
XAMPP version: 1.8.0
Operating System: Windows

Re: MySql not starting

Postby ILAKKILINGAM » 12. December 2017 14:46

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

2017-12-12 18:47:22 1a90 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.
2017-12-12 18:47:22 6800 [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.

2017-12-12 18:47:22 6800 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:47:22 6800 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:47:22 6800 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:47:22 6800 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:47:22 6800 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:47:22 6800 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:47:22 6800 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:47:22 6800 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:47:23 6800 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:47:23 6800 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:47:23 6800 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:47:23 6800 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835037
2017-12-12 18:47:23 6176 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:47:23 6800 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:47:23 6800 [Note] Server socket created on IP: '::'.
2017-12-12 18:47:23 6800 [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.


2017-12-12 18:47:23 6800 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:47:23 6800 [ERROR] Aborting

2017-12-12 18:47:43 f40 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.
2017-12-12 18:47:43 3904 [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.

2017-12-12 18:47:43 3904 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:47:43 3904 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:47:43 3904 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:47:43 3904 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:47:43 3904 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:47:43 3904 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:47:43 3904 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:47:43 3904 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:47:43 3904 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:47:44 3904 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:47:44 3904 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:47:44 3904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835047
2017-12-12 18:47:44 4408 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:47:44 3904 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:47:44 3904 [Note] Server socket created on IP: '::'.
2017-12-12 18:47:44 3904 [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.


2017-12-12 18:47:44 3904 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:47:44 3904 [ERROR] Aborting

2017-12-12 18:50:47 19a4 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.
2017-12-12 18:50:47 6564 [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.

2017-12-12 18:50:47 6564 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:50:47 6564 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:50:47 6564 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:50:47 6564 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:50:47 6564 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:50:47 6564 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:50:47 6564 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:50:47 6564 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:50:48 6564 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:50:48 6564 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:50:48 6564 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:50:48 6564 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835057
2017-12-12 18:50:48 6176 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:50:48 6564 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:50:48 6564 [Note] Server socket created on IP: '::'.
2017-12-12 18:50:48 6564 [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.


2017-12-12 18:50:48 6564 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:50:48 6564 [ERROR] Aborting

2017-12-12 18:52:03 101c 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.
2017-12-12 18:52:03 4124 [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.

2017-12-12 18:52:03 4124 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:52:03 4124 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:52:03 4124 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:52:03 4124 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:52:03 4124 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:52:03 4124 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:52:03 4124 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:52:03 4124 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:52:03 4124 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:52:03 4124 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:52:03 4124 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:52:03 4124 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835067
2017-12-12 18:52:03 6896 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:52:03 4124 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:52:03 4124 [Note] Server socket created on IP: '::'.
2017-12-12 18:52:03 4124 [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.


2017-12-12 18:52:03 4124 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:52:03 4124 [ERROR] Aborting

2017-12-12 18:52:10 1574 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.
2017-12-12 18:52:10 5492 [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.

2017-12-12 18:52:11 5492 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:52:11 5492 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:52:11 5492 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:52:11 5492 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:52:11 5492 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:52:11 5492 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:52:11 5492 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:52:11 5492 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:52:11 5492 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:52:11 5492 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:52:11 5492 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:52:11 5492 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835077
2017-12-12 18:52:11 6064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:52:11 5492 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:52:11 5492 [Note] Server socket created on IP: '::'.
2017-12-12 18:52:11 5492 [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.


2017-12-12 18:52:11 5492 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:52:11 5492 [ERROR] Aborting

2017-12-12 18:52:45 a84 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.
2017-12-12 18:52:45 2692 [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.

2017-12-12 18:52:45 2692 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:52:45 2692 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:52:45 2692 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:52:45 2692 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:52:45 2692 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:52:45 2692 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:52:45 2692 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:52:45 2692 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:52:45 2692 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:52:46 2692 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:52:46 2692 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:52:46 2692 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835087
2017-12-12 18:52:46 616 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:52:46 2692 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:52:46 2692 [Note] Server socket created on IP: '::'.
2017-12-12 18:52:46 2692 [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.


2017-12-12 18:52:46 2692 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:52:46 2692 [ERROR] Aborting

2017-12-12 18:54:18 ee8 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.
2017-12-12 18:54:18 3816 [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.

2017-12-12 18:54:18 3816 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:54:18 3816 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:54:18 3816 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:54:18 3816 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:54:18 3816 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:54:18 3816 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:54:18 3816 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:54:18 3816 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:54:19 3816 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:54:19 3816 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:54:19 3816 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:54:19 3816 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835097
2017-12-12 18:54:19 7148 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:54:19 3816 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:54:19 3816 [Note] Server socket created on IP: '::'.
2017-12-12 18:54:19 3816 [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.


2017-12-12 18:54:19 3816 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:54:19 3816 [ERROR] Aborting

2017-12-12 18:54:24 12e0 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.
2017-12-12 18:54:24 4832 [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.

2017-12-12 18:54:24 4832 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-12 18:54:24 4832 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-12 18:54:24 4832 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-12 18:54:24 4832 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-12 18:54:24 4832 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-12 18:54:24 4832 [Note] InnoDB: Using generic crc32 instructions
2017-12-12 18:54:24 4832 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-12 18:54:24 4832 [Note] InnoDB: Completed initialization of buffer pool
2017-12-12 18:54:25 4832 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-12 18:54:25 4832 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-12 18:54:25 4832 [Note] InnoDB: Waiting for purge to start
2017-12-12 18:54:25 4832 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835107
2017-12-12 18:54:25 6504 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-12 18:54:25 4832 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-12 18:54:25 4832 [Note] Server socket created on IP: '::'.
2017-12-12 18:54:25 4832 [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.


2017-12-12 18:54:25 4832 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:54:25 4832 [ERROR] Aborting
ILAKKILINGAM
 
Posts: 1
Joined: 12. December 2017 14:33
XAMPP version: v3.2.2
Operating System: windows

Re: MySql not starting

Postby Nobbie » 12. December 2017 21:59

ILAKKILINGAM wrote:2017-12-12 18:54:25 4832 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-12 18:54:25 4832 [ERROR] Aborting
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 10 guests