XAMPP, Mysql Error Shutdown Unexpectedly

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

XAMPP, Mysql Error Shutdown Unexpectedly

Postby farhanz95 » 11. January 2016 04:35

Hi, my xampp keeps on giving error by saying this message in red font text whenever i tried to start mysql

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



I have tried many solution such as deleting the ibdata1 file and done lots of other solution found on the internet but the problem still occur


This is my log file during the problem occur

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

2016-01-11 10:46:49 324 [Note] Binlog end
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'partition'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'CSV'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'binlog'
2016-01-11 10:46:49 324 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

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

2016-01-11 10:46:51 2440 [Note] Binlog end
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'partition'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'CSV'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'binlog'
2016-01-11 10:46:51 2440 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-11 10:48:39 3472 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:48:39 12a8 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-01-11 10:48:39 3472 [Note] InnoDB: Started in read only mode
2016-01-11 10:48:39 3472 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:48:39 3472 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:48:39 3472 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:48:39 3472 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:48:39 3472 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:48:39 3472 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:48:39 3472 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:48:39 3472 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:48:39 3472 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:48:39 12a8 InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:48:39 3472 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:50:15 6188 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:50:15 628 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-01-11 10:50:15 6188 [Note] InnoDB: Started in read only mode
2016-01-11 10:50:15 6188 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:50:15 6188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:50:15 6188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:50:15 6188 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:50:15 6188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:50:15 6188 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:50:15 6188 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:50:15 6188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:50:15 6188 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:50:15 628 InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:50:15 6188 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:50:30 2640 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:50:30 39c 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-01-11 10:50:30 2640 [Note] InnoDB: Started in read only mode
2016-01-11 10:50:30 2640 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:50:30 2640 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:50:30 2640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:50:30 2640 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:50:30 2640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:50:30 2640 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:50:30 2640 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:50:30 2640 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:50:30 2640 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:50:30 39c InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:50:30 2640 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:50:31 6540 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:50:31 364 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-01-11 10:50:31 6540 [Note] InnoDB: Started in read only mode
2016-01-11 10:50:31 6540 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:50:31 6540 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:50:31 6540 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:50:31 6540 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:50:31 6540 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:50:31 6540 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:50:31 6540 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:50:31 6540 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:50:31 6540 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:50:31 364 InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:50:31 6540 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:51:35 5972 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:35 16b4 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-01-11 10:51:35 5972 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:35 5972 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:35 5972 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:35 5972 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:35 5972 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:35 5972 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:35 5972 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:35 5972 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:35 5972 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-11 10:51:35 5972 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-11 10:51:35 5972 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-11 10:51:35 5972 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-11 10:51:35 5972 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-11 10:51:35 5972 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-11 10:51:35 5972 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-11 10:51:35 5972 [ERROR] Aborting

2016-01-11 10:51:35 5972 [Note] Binlog end
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'partition'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'CSV'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'binlog'
2016-01-11 10:51:35 5972 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-11 10:51:38 6188 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:38 b4c 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-01-11 10:51:38 6188 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:38 6188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:38 6188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:38 6188 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:38 6188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:38 6188 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:38 6188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:38 6188 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:38 6188 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:51:38 6188 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:51:38 6188 [Note] InnoDB: Database was not shutdown normally!
2016-01-11 10:51:38 6188 [Note] InnoDB: Starting crash recovery.
2016-01-11 10:51:38 6188 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-11 10:51:41 2640 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:41 d58 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-01-11 10:51:41 2640 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:41 2640 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:41 2640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:41 2640 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:41 2640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:41 2640 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:41 2640 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:41 2640 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:41 2640 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:51:41 2640 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:51:41 2640 [Note] InnoDB: Database was not shutdown normally!
2016-01-11 10:51:41 2640 [Note] InnoDB: Starting crash recovery.
2016-01-11 10:51:41 2640 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-11 10:51:43 2640 [Note] InnoDB: Restoring possible half-written data pages
2016-01-11 10:51:43 2640 [Note] InnoDB: from the doublewrite buffer...
2016-01-11 10:51:43 d58 InnoDB: Assertion failure in thread 3416 in file fsp0fsp.cc line 1887
InnoDB: Failing assertion: inode
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
02:51:43 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
127a500 mysqld.exe!my_thread_name()
14b392d mysqld.exe!my_mb_ctype_mb()
135c937 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
132c0f9 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13db796 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12f5356 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12ae22a mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
102a200 mysqld.exe!?ha_initialize_handlerton@@YAHPAUst_plugin_int@@@Z()
106434e mysqld.exe!?plugin_lock_by_name@@YAPAUst_plugin_int@@PAVTHD@@PBUst_mysql_lex_string@@H@Z()
1068a81 mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
10217bb mysqld.exe!?init_common_variables@@YAHXZ()
10224c8 mysqld.exe!?win_main@@YAHHPAPAD@Z()
1022a37 mysqld.exe!?mysql_service@@YAHPAX@Z()
14ae48a mysqld.exe!my_mb_ctype_mb()
74d2338a kernel32.dll!BaseThreadInitThunk()
77079f72 ntdll.dll!RtlInitializeExceptionChain()
77079f45 ntdll.dll!RtlInitializeExceptionChain()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2016-01-11 10:51:59 6804 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:59 5c4 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-01-11 10:51:59 6804 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:59 6804 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:59 6804 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:59 6804 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:59 6804 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:59 6804 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:59 6804 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:59 6804 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:59 6804 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:51:59 6804 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:51:59 6804 [Note] InnoDB: Database was not shutdown normally!
2016-01-11 10:51:59 6804 [Note] InnoDB: Starting crash recovery.
2016-01-11 10:51:59 6804 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-11 10:51:59 6804 [Note] InnoDB: Restoring possible half-written data pages
2016-01-11 10:51:59 6804 [Note] InnoDB: from the doublewrite buffer...
2016-01-11 10:51:59 5c4 InnoDB: Assertion failure in thread 1476 in file fsp0fsp.cc line 1887
InnoDB: Failing assertion: inode
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
02:51:59 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
127a500 mysqld.exe!my_thread_name()
14b392d mysqld.exe!my_mb_ctype_mb()
135c937 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
132c0f9 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13db796 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12f5356 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12ae22a mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
102a200 mysqld.exe!?ha_initialize_handlerton@@YAHPAUst_plugin_int@@@Z()
106434e mysqld.exe!?plugin_lock_by_name@@YAPAUst_plugin_int@@PAVTHD@@PBUst_mysql_lex_string@@H@Z()
1068a81 mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
10217bb mysqld.exe!?init_common_variables@@YAHXZ()
10224c8 mysqld.exe!?win_main@@YAHHPAPAD@Z()
1022a37 mysqld.exe!?mysql_service@@YAHPAX@Z()
14ae48a mysqld.exe!my_mb_ctype_mb()
74d2338a kernel32.dll!BaseThreadInitThunk()
77079f72 ntdll.dll!RtlInitializeExceptionChain()
77079f45 ntdll.dll!RtlInitializeExceptionChain()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2016-01-11 10:55:59 5924 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:55:59 1a08 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-01-11 10:55:59 5924 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:55:59 5924 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:55:59 5924 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:55:59 5924 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:55:59 5924 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:55:59 5924 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:55:59 5924 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:55:59 5924 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:55:59 5924 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:56:00 5924 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-11 10:56:00 5924 [Note] InnoDB: Waiting for purge to start
2016-01-11 10:56:00 5924 [Note] InnoDB: 5.6.20 started; log sequence number 3460453250
2016-01-11 10:56:00 5924 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2016-01-11 10:56:00 5924 [Note] Server hostname (bind-address): '*'; port: 3306
2016-01-11 10:56:00 5924 [Note] IPv6 is available.
2016-01-11 10:56:00 5924 [Note] - '::' resolves to '::';
2016-01-11 10:56:00 5924 [Note] Server socket created on IP: '::'.
2016-01-11 10:56:00 5924 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2016-01-11 10:56:00 5924 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-11 10:56:00 5924 [ERROR] Aborting

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

Hope someone can help me , I am new to this :(
farhanz95
 
Posts: 1
Joined: 11. January 2016 04:19
Operating System: Windows 7 Professional

Re: XAMPP, Mysql Error Shutdown Unexpectedly

Postby Seyi723 » 16. January 2016 12:58

Boy o boy...Quite a damage here!!! ''Delete'' is the last button you wanna press on stuffs like this. Sorry, you lost me
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: XAMPP, Mysql Error Shutdown Unexpectedly

Postby eric99 » 16. January 2016 16:22

Edit: The Windows event viewer says:

Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed

I have both myisam and innodb tables in the database. According to the MySQL site, REPAIR only works on Myisam tables. What works on Innodb tables?

Could anyone please provide the commands so I can manually repair?

***********************************************************

I too am having this problem. Yesterday things were operating swimmingly and I left everything running overnight. A Windows10 update then reboot occurred and now I'm getting this error message. Apache runs fine.

10:14:46 AM [mysql] Checking default ports...
10:14:46 AM [mysql] Attempting to start MySQL app...
10:14:46 AM [mysql] Executing ""d:\xampp\mysql\bin\mysqld.exe" --defaults-file="d:\xampp\mysql\bin\my.ini" --standalone"
10:14:46 AM [mysql] Return code: 0
10:14:46 AM [mysql] Status change detected: running
10:14:47 AM [mysql] Status change detected: stopped
10:14:47 AM [mysql] Error: MySQL shutdown unexpectedly.
10:14:47 AM [mysql] This may be due to a blocked port, missing dependencies,
10:14:47 AM [mysql] improper privileges, a crash, or a shutdown by another method.
10:14:47 AM [mysql] Press the Logs button to view error logs and check
10:14:47 AM [mysql] the Windows Event Viewer for more clues
10:14:47 AM [mysql] If you need more help, copy and post this
10:14:47 AM [mysql] entire log window on the forums
eric99
 
Posts: 8
Joined: 20. December 2014 16:46
Operating System: Windows 8.1

Re: XAMPP, Mysql Error Shutdown Unexpectedly

Postby eric99 » 17. January 2016 16:12

Looks like everyone is stumped and is clueless as to how to proceed. Even a pointer to a website would be beneficial.

I hate to have to uninstall xampp, reinstall it then recreate my databases. There goes a day.
eric99
 
Posts: 8
Joined: 20. December 2014 16:46
Operating System: Windows 8.1


Return to XAMPP for Windows

Who is online

Users browsing this forum: dogmatic and 33 guests