Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby grifon » 28. February 2015 21:09

Hi,

I have never worked with XAMPP, so I am sorry for my maybe stupid questions. I have downloaded the programme and I wanted to start MySQL, but an error message appeared, which said that the port: 3306 would be already taken. I have restarted the programme and un- and reinstalled the MySQL Service. Now another error message appears:

Code: Select all
21:07:55  [mysql]    Attempting to start MySQL service...
21:07:56  [mysql]    Status change detected: running
21:08:01  [mysql]    Status change detected: stopped
21:08:01  [mysql]    Error: MySQL shutdown unexpectedly.
21:08:01  [mysql]    This may be due to a blocked port, missing dependencies,
21:08:01  [mysql]    improper privileges, a crash, or a shutdown by another method.
21:08:01  [mysql]    Press the Logs button to view error logs and check
21:08:01  [mysql]    the Windows Event Viewer for more clues
21:08:01  [mysql]    If you need more help, copy and post this
21:08:01  [mysql]    entire log window on the forums


Here is also the Log-File:

Code: Select all
2015-02-28 15:07:06 7676 [Note] Plugin 'FEDERATED' is disabled.
2015-02-28 15:07:06 1df4 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-02-28 15:07:06 7676 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-28 15:07:06 7676 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-28 15:07:06 7676 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-28 15:07:06 7676 [Note] InnoDB: Memory barrier is not used
2015-02-28 15:07:06 7676 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-28 15:07:06 7676 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-28 15:07:06 7676 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-28 15:07:06 7676 [Note] InnoDB: Completed initialization of buffer pool
2015-02-28 15:07:06 7676 [Note] InnoDB: The first specified data file D:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2015-02-28 15:07:06 7676 [Note] InnoDB: Setting file D:\xampp\mysql\data\ibdata1 size to 10 MB
2015-02-28 15:07:06 7676 [Note] InnoDB: Database physically writes the file full: wait...
2015-02-28 15:07:06 7676 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile101 size to 5 MB
2015-02-28 15:07:06 7676 [ERROR] InnoDB: Cannot create D:\xampp\mysql\data\ib_logfile1
2015-02-28 15:07:06 7676 [ERROR] Plugin 'InnoDB' init function returned error.
2015-02-28 15:07:06 7676 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-28 15:07:06 7676 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-02-28 15:07:06 7676 [ERROR] Aborting

2015-02-28 15:07:06 7676 [Note] Binlog end
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'partition'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'ARCHIVE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MyISAM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MEMORY'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'CSV'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'sha256_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'mysql_old_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'mysql_native_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'binlog'
2015-02-28 15:07:06 7676 [Note] d:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-02-28 15:07:22 6052 [Note] Plugin 'FEDERATED' is disabled.
2015-02-28 15:07:22 1f58 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-02-28 15:07:22 6052 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-28 15:07:22 6052 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-28 15:07:22 6052 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-28 15:07:22 6052 [Note] InnoDB: Memory barrier is not used
2015-02-28 15:07:22 6052 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-28 15:07:22 6052 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-28 15:07:22 6052 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-28 15:07:22 6052 [Note] InnoDB: Completed initialization of buffer pool
2015-02-28 15:07:22 6052 [Note] InnoDB: Restoring page 0 of tablespace 0
2015-02-28 15:07:22 6052 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2015-02-28 15:07:22 6052 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp\mysql\data\ibdata1
2015-02-28 15:07:22 6052 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2015-02-28 15:07:22 6052 [ERROR] Plugin 'InnoDB' init function returned error.
2015-02-28 15:07:22 6052 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-28 15:07:22 6052 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-02-28 15:07:22 6052 [ERROR] Aborting

2015-02-28 15:07:22 6052 [Note] Binlog end
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'partition'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'ARCHIVE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MyISAM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MEMORY'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'CSV'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'sha256_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'mysql_old_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'mysql_native_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'binlog'
2015-02-28 15:07:22 6052 [Note] D:\xampp\mysql\bin\mysqld.exe: Shutdown complete


I am sorry, if this problem has already been solved here, but I have not found it.

Please help me, I do not have an idea what it could be.
grifon
 
Posts: 7
Joined: 28. February 2015 15:14
Operating System: Windows 7

Re: Error: MySQL shutdown unexpectedly.

Postby mark.mcdonald » 13. March 2015 17:01

If you can reproduce the "3306 is taken". Run Command Prompt -> Type in: NetStat -o
This will show you a list of services using that port associated with a PID.
Start Task Manager -> Go to Services Tab and search for the same PID and this is what is using that port.
Stop the service and make sure it is not set to start up automatically otherwise you will encounter this issue again.
This should allow you to start MySQL without issue.

Make sure the MySQL service is uninstalled first ->
Re-Download XAMPP and copy over any missing files. Make sure this file exists: "D:\xampp\mysql\data\ib_logfile1"
-2015-02-28 15:07:06 7676 [ERROR] InnoDB: Cannot create D:\xampp\mysql\data\ib_logfile1

Replace this file: D:\xampp\mysql\data\ibdata1
2015-02-28 15:07:22 6052 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp\mysql\data\ibdata1

I would suggest you download a fresh copy of xampp (same version) and replace the mysql folder to start fresh.
I would highly recommend downloading the latest version of XAMPP and getting a fresh start if there is not much developed.
mark.mcdonald
 
Posts: 160
Joined: 13. March 2015 15:48
Location: Edmonton
Operating System: Windows Server 2012 R2


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 73 guests