Page 2 of 2

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 10. May 2016 19:32
by Altrea
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.

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 11. May 2016 11:28
by vishalp@lexcis.com
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

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 11. May 2016 13:32
by Altrea
the mysql_error.log entries please, not the control panel log entries.

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 11. May 2016 13:42
by vishalp@lexcis.com
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