Error: MySQL shutdown unexpectedly

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

Error: MySQL shutdown unexpectedly

Postby shahajad » 30. May 2018 17:18

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

2018-05-30 21:39:52 41f0 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.
2018-05-30 21:39:52 16880 [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.

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


2018-05-30 21:39:54 16880 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-05-30 21:39:54 16880 [ERROR] Aborting

2018-05-30 21:41:04 bc8 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.
2018-05-30 21:41:04 3016 [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.

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


2018-05-30 21:41:06 3016 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-05-30 21:41:06 3016 [ERROR] Aborting
shahajad
 
Posts: 1
Joined: 30. May 2018 17:13
XAMPP version: 3.2.2
Operating System: window 10

Re: Error: MySQL shutdown unexpectedly

Postby dominopuzle » 04. June 2018 10:40

Hi to all, I have the same problem maybee someone could help:

2018-06-04 12:19:27 211c 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.
180604 12:19:27 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180604 12:19:27 [Note] InnoDB: The InnoDB memory heap is disabled
180604 12:19:27 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
180604 12:19:27 [Note] InnoDB: Memory barrier is not used
180604 12:19:27 [Note] InnoDB: Compressed tables use zlib 1.2.3
180604 12:19:27 [Note] InnoDB: Not using CPU crc32 instructions
180604 12:19:27 [Note] InnoDB: Initializing buffer pool, size = 16.0M
180604 12:19:27 [Note] InnoDB: Completed initialization of buffer pool
180604 12:19:27 [Note] InnoDB: Highest supported file format is Barracuda.
180604 12:19:27 [Note] InnoDB: Log scan progressed past the checkpoint lsn 402620321
180604 12:19:27 [Note] InnoDB: Database was not shutdown normally!
180604 12:19:27 [Note] InnoDB: Starting crash recovery.
180604 12:19:27 [Note] InnoDB: Reading tablespace information from the .ibd files...
180604 12:19:28 [Note] InnoDB: Restoring possible half-written data pages
180604 12:19:28 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 402620331
180604 12:19:28 [Note] InnoDB: 128 rollback segment(s) are active.
180604 12:19:28 [Note] InnoDB: Waiting for purge to start
180604 12:19:28 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 402620331
180604 12:19:28 [Note] Plugin 'FEEDBACK' is disabled.
180604 12:19:28 [Note] Server socket created on IP: '::'.
dominopuzle
 
Posts: 1
Joined: 04. June 2018 10:31
XAMPP version: v3.2.1
Operating System: W10, 64 bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 140 guests