Error: MySQL shutdown unexpectedly.

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

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 10. May 2016 19:32

Okay, this can be a bit tricky to resolve. You have multiple problems with your MySQl Database.
Please now set innodb_force_recovery = 4 (not lower, not higher, exactly to 4) and try to start MySQL again.
Again we need a fresh log.
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: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Error: MySQL shutdown unexpectedly.

Postby vishalp@lexcis.com » 11. May 2016 11:28

Below are the logs after ' innodb_force_recovery=4' use

3:54:07 PM [mysql] Attempting to start MySQL app...
3:54:17 PM [mysql] Status change detected: running
3:54:18 PM [mysql] Status change detected: stopped
3:54:18 PM [mysql] Error: MySQL shutdown unexpectedly.
3:54:18 PM [mysql] This may be due to a blocked port, missing dependencies,
3:54:18 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:54:18 PM [mysql] Press the Logs button to view error logs and check
3:54:18 PM [mysql] the Windows Event Viewer for more clues
3:54:18 PM [mysql] If you need more help, copy and post this
3:54:18 PM [mysql] entire log window on the forums
vishalp@lexcis.com
 
Posts: 9
Joined: 09. May 2016 09:42
XAMPP version: 3.2.1
Operating System: windows

Re: Error: MySQL shutdown unexpectedly.

Postby Altrea » 11. May 2016 13:32

the mysql_error.log entries please, not the control panel log entries.
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: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Error: MySQL shutdown unexpectedly.

Postby vishalp@lexcis.com » 11. May 2016 13:42

Sorry for inconvenience Altrea.

Below are the log:-
2016-05-11 18:09:46 7108 [Note] Plugin 'FEDERATED' is disabled.
2016-05-11 18:09:46 3dc 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-05-11 18:09:46 7108 [Note] InnoDB: Started in read only mode
2016-05-11 18:09:46 7108 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-11 18:09:46 7108 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-11 18:09:46 7108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-11 18:09:46 7108 [Note] InnoDB: Memory barrier is not used
2016-05-11 18:09:46 7108 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-11 18:09:46 7108 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-11 18:09:46 7108 [Note] InnoDB: Disabling background IO write threads.
2016-05-11 18:09:46 7108 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-11 18:09:46 7108 [Note] InnoDB: Completed initialization of buffer pool
2016-05-11 18:09:46 7108 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-11 18:09:46 7108 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665548 in the ib_logfiles!
2016-05-11 18:09:46 7108 [ERROR] InnoDB: Can't initiate database recovery, running in read-only-mode.
2016-05-11 18:09:46 7108 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-11 18:09:46 7108 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-11 18:09:46 7108 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-11 18:09:46 7108 [ERROR] Aborting

2016-05-11 18:09:46 7108 [Note] Binlog end
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'partition'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'ARCHIVE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'MyISAM'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'MEMORY'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'CSV'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'sha256_password'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'mysql_old_password'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'mysql_native_password'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'binlog'
2016-05-11 18:09:46 7108 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
vishalp@lexcis.com
 
Posts: 9
Joined: 09. May 2016 09:42
XAMPP version: 3.2.1
Operating System: windows

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 179 guests