mysql immediate shutdown error

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

mysql immediate shutdown error

Postby buggy29 » 10. November 2013 23:24

i need some help and i tried looking for a solution through searching and couldnt find one so if someone can help me please and if this has been answered before i apologize i was unable to find the answer


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



131110 14:08:04 [Note] Plugin 'FEDERATED' is disabled.
131110 14:08:04 InnoDB: The InnoDB memory heap is disabled
131110 14:08:04 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:08:04 InnoDB: Compressed tables use zlib 1.2.3
131110 14:08:04 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:08:04 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
131110 14:08:04 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131110 14:08:04 InnoDB: Error: all log files must be created at the same time.
131110 14:08:04 InnoDB: All log files must be created also in database creation.
131110 14:08:04 InnoDB: If you want bigger or smaller log files, shut down the
131110 14:08:04 InnoDB: database and make sure there were no errors in shutdown.
131110 14:08:04 InnoDB: Then delete the existing log files. Edit the .cnf file
131110 14:08:04 InnoDB: and start the database again.
131110 14:08:04 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:08:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:08:04 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:08:04 [ERROR] Aborting

131110 14:08:04 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:08:07 [Note] Plugin 'FEDERATED' is disabled.
131110 14:08:07 InnoDB: The InnoDB memory heap is disabled
131110 14:08:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:08:07 InnoDB: Compressed tables use zlib 1.2.3
131110 14:08:07 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:08:07 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:08:07 InnoDB: Could not open or create data files.
131110 14:08:07 InnoDB: If you tried to add new data files, and it failed here,
131110 14:08:07 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:08:07 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:08:07 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:08:07 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:08:07 InnoDB: remove old data files which contain your precious data!
131110 14:08:07 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:08:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:08:07 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:08:07 [ERROR] Aborting

131110 14:08:07 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:08:09 [Note] Plugin 'FEDERATED' is disabled.
131110 14:08:09 InnoDB: The InnoDB memory heap is disabled
131110 14:08:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:08:09 InnoDB: Compressed tables use zlib 1.2.3
131110 14:08:09 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:08:09 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:08:09 InnoDB: Could not open or create data files.
131110 14:08:09 InnoDB: If you tried to add new data files, and it failed here,
131110 14:08:09 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:08:09 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:08:09 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:08:09 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:08:09 InnoDB: remove old data files which contain your precious data!
131110 14:08:09 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:08:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:08:09 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:08:09 [ERROR] Aborting

131110 14:08:09 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:08:10 [Note] Plugin 'FEDERATED' is disabled.
131110 14:08:10 InnoDB: The InnoDB memory heap is disabled
131110 14:08:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:08:10 InnoDB: Compressed tables use zlib 1.2.3
131110 14:08:10 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:08:10 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:08:10 InnoDB: Could not open or create data files.
131110 14:08:10 InnoDB: If you tried to add new data files, and it failed here,
131110 14:08:10 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:08:10 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:08:10 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:08:10 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:08:10 InnoDB: remove old data files which contain your precious data!
131110 14:08:10 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:08:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:08:10 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:08:10 [ERROR] Aborting

131110 14:08:10 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:09:11 [Note] Plugin 'FEDERATED' is disabled.
131110 14:09:11 InnoDB: The InnoDB memory heap is disabled
131110 14:09:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:09:11 InnoDB: Compressed tables use zlib 1.2.3
131110 14:09:11 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:09:11 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:09:11 InnoDB: Could not open or create data files.
131110 14:09:11 InnoDB: If you tried to add new data files, and it failed here,
131110 14:09:11 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:09:11 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:09:11 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:09:11 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:09:11 InnoDB: remove old data files which contain your precious data!
131110 14:09:11 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:09:11 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:09:11 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:09:11 [ERROR] Aborting

131110 14:09:11 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:09:13 [Note] Plugin 'FEDERATED' is disabled.
131110 14:09:13 InnoDB: The InnoDB memory heap is disabled
131110 14:09:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:09:13 InnoDB: Compressed tables use zlib 1.2.3
131110 14:09:13 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:09:13 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:09:13 InnoDB: Could not open or create data files.
131110 14:09:13 InnoDB: If you tried to add new data files, and it failed here,
131110 14:09:13 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:09:13 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:09:13 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:09:13 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:09:13 InnoDB: remove old data files which contain your precious data!
131110 14:09:13 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:09:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:09:13 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:09:13 [ERROR] Aborting

131110 14:09:13 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:16:57 [Note] Plugin 'FEDERATED' is disabled.
131110 14:16:57 InnoDB: The InnoDB memory heap is disabled
131110 14:16:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:16:57 InnoDB: Compressed tables use zlib 1.2.3
131110 14:16:57 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:16:57 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:16:57 InnoDB: Could not open or create data files.
131110 14:16:57 InnoDB: If you tried to add new data files, and it failed here,
131110 14:16:57 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:16:57 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:16:57 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:16:57 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:16:57 InnoDB: remove old data files which contain your precious data!
131110 14:16:57 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:16:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:16:57 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:16:57 [ERROR] Aborting

131110 14:16:57 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

131110 14:23:35 [Note] Plugin 'FEDERATED' is disabled.
131110 14:23:35 InnoDB: The InnoDB memory heap is disabled
131110 14:23:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131110 14:23:35 InnoDB: Compressed tables use zlib 1.2.3
131110 14:23:35 InnoDB: Initializing buffer pool, size = 16.0M
131110 14:23:35 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
131110 14:23:35 InnoDB: Could not open or create data files.
131110 14:23:35 InnoDB: If you tried to add new data files, and it failed here,
131110 14:23:35 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131110 14:23:35 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131110 14:23:35 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131110 14:23:35 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131110 14:23:35 InnoDB: remove old data files which contain your precious data!
131110 14:23:35 [ERROR] Plugin 'InnoDB' init function returned error.
131110 14:23:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131110 14:23:35 [ERROR] Unknown/unsupported storage engine: InnoDB
131110 14:23:35 [ERROR] Aborting

131110 14:23:35 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
buggy29
 
Posts: 1
Joined: 10. November 2013 23:20
Operating System: windows 8 pro

Re: mysql immediate shutdown error

Postby JJ_Tagy » 11. November 2013 07:37

buggy29 wrote:...
2:23:36 PM [mysql] If you need more help, copy and post this
2:23:36 PM [mysql] entire log window on the forums
...
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 101 guests