Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby Anushree » 26. August 2013 06:42

Hello All,

Help me out, why this error is coming.


2013-08-26 10:34:02 8772 [Note] Plugin 'FEDERATED' is disabled.
2013-08-26 10:34:02 20e8 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.
2013-08-26 10:34:02 8772 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-26 10:34:02 8772 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-26 10:34:02 8772 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-26 10:34:02 8772 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-26 10:34:02 8772 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-08-26 10:34:02 8772 [Note] InnoDB: Completed initialization of buffer pool
2013-08-26 10:34:02 8772 [Note] InnoDB: The first specified data file C:\xampp1\mysql\data\ibdata1 did not exist: a new database to be created!
2013-08-26 10:34:02 8772 [Note] InnoDB: Setting file C:\xampp1\mysql\data\ibdata1 size to 10 MB
2013-08-26 10:34:02 8772 [Note] InnoDB: Database physically writes the file full: wait...
2013-08-26 10:34:02 8772 [Note] InnoDB: Setting log file C:\xampp1\mysql\data\ib_logfile101 size to 5 MB
2013-08-26 10:34:02 8772 [Note] InnoDB: Setting log file C:\xampp1\mysql\data\ib_logfile1 size to 5 MB
2013-08-26 10:34:03 8772 [Note] InnoDB: Renaming log file C:\xampp1\mysql\data\ib_logfile101 to C:\xampp1\mysql\data\ib_logfile0
2013-08-26 10:34:03 8772 [Warning] InnoDB: New log files created, LSN=45781
2013-08-26 10:34:03 8772 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-08-26 10:34:03 8772 [Note] InnoDB: Doublewrite buffer created
2013-08-26 10:34:04 8772 [Note] InnoDB: 128 rollback segment(s) are active.
2013-08-26 10:34:04 8772 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-08-26 10:34:04 8772 [Note] InnoDB: Foreign key constraint system tables created
2013-08-26 10:34:04 8772 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-08-26 10:34:04 8772 [Note] InnoDB: Tablespace and datafile system tables created.
2013-08-26 10:34:04 8772 [Note] InnoDB: Waiting for purge to start
2013-08-26 10:34:04 8772 [Note] InnoDB: 5.6.11 started; log sequence number 0
2013-08-26 10:34:04 8772 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ee17a4cf-0e0c-11e3-9e7b-e8393536c4f2.
2013-08-26 10:34:04 8772 [Note] Server hostname (bind-address): '*'; port: 3306
2013-08-26 10:34:04 8772 [Note] IPv6 is available.
2013-08-26 10:34:04 8772 [Note] - '::' resolves to '::';
2013-08-26 10:34:04 8772 [Note] Server socket created on IP: '::'.
2013-08-26 10:34:04 8772 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2013-08-26 10:34:04 8772 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2013-08-26 10:34:04 8772 [ERROR] Aborting

2013-08-26 10:34:04 8772 [Note] Binlog end
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'partition'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_METRICS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_CMP'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'INNODB_TRX'
2013-08-26 10:34:04 8772 [Note] Shutting down plugin 'InnoDB'
2013-08-26 10:34:04 8772 [Note] InnoDB: FTS optimize thread exiting.
2013-08-26 10:34:04 8772 [Note] InnoDB: Starting shutdown...
2013-08-26 10:34:06 8772 [Note] InnoDB: Shutdown completed; log sequence number 1600614
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'BLACKHOLE'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'ARCHIVE'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'MRG_MYISAM'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'MyISAM'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'MEMORY'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'CSV'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'sha256_password'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'mysql_old_password'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'mysql_native_password'
2013-08-26 10:34:06 8772 [Note] Shutting down plugin 'binlog'
2013-08-26 10:34:06 8772 [Note] c:\xampp1\mysql\bin\mysqld.exe: Shutdown complete

2013-08-26 10:52:07 2384 [Note] Plugin 'FEDERATED' is disabled.
2013-08-26 10:52:07 2684 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.
2013-08-26 10:52:07 2384 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-26 10:52:07 2384 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-26 10:52:07 2384 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-26 10:52:07 2384 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-26 10:52:07 2384 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-08-26 10:52:07 2384 [Note] InnoDB: Completed initialization of buffer pool
2013-08-26 10:52:07 2384 [Note] InnoDB: Highest supported file format is Barracuda.
2013-08-26 10:52:07 2384 [Note] InnoDB: 128 rollback segment(s) are active.
2013-08-26 10:52:07 2384 [Note] InnoDB: Waiting for purge to start
2013-08-26 10:52:07 2384 [Note] InnoDB: 5.6.11 started; log sequence number 1600614
2013-08-26 10:52:07 2384 [Note] Server hostname (bind-address): '*'; port: 3306
2013-08-26 10:52:07 2384 [Note] IPv6 is available.
2013-08-26 10:52:07 2384 [Note] - '::' resolves to '::';
2013-08-26 10:52:07 2384 [Note] Server socket created on IP: '::'.
2013-08-26 10:52:07 2384 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2013-08-26 10:52:07 2384 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2013-08-26 10:52:07 2384 [ERROR] Aborting

2013-08-26 10:52:07 2384 [Note] Binlog end
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'partition'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_METRICS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_CMP'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'INNODB_TRX'
2013-08-26 10:52:07 2384 [Note] Shutting down plugin 'InnoDB'
2013-08-26 10:52:07 2384 [Note] InnoDB: FTS optimize thread exiting.
2013-08-26 10:52:07 2384 [Note] InnoDB: Starting shutdown...
2013-08-26 10:52:09 2384 [Note] InnoDB: Shutdown completed; log sequence number 1600624
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'BLACKHOLE'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'ARCHIVE'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'MRG_MYISAM'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'MyISAM'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'MEMORY'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'CSV'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'sha256_password'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'mysql_old_password'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'mysql_native_password'
2013-08-26 10:52:09 2384 [Note] Shutting down plugin 'binlog'
2013-08-26 10:52:09 2384 [Note] c:\xampp1\mysql\bin\mysqld.exe: Shutdown complete

Not getting
Anushree
 
Posts: 1
Joined: 26. August 2013 06:37
XAMPP Version: 1.8.3-3
Operating System: windows 7

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 26. August 2013 08:09

Hi Anushree,

Anushree wrote:2013-08-26 10:34:04 8772 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2013-08-26 10:34:04 8772 [ERROR] Do you already have another mysqld server running on port: 3306 ?

:?:

so please check if your port 3306 is free or already blocked by another program.

best wishes,
Altrea
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: 6692
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests