Unable to start mysql server with Innodb. The error log is as below

2017-09-18  9:15:46 139644115483392 [Note] /usr/sbin/mysqld: Normal shutdown
 
2017-09-18  9:15:46 139644115483392 [Note] Event Scheduler: Purging the queue. 0 events
2017-09-18  9:15:46 139644115483392 [Note] /usr/sbin/mysqld: Shutdown complete
 
Error in my_thread_global_end(): 1 threads didn't exit
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
 
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Using Linux native AIO
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Using SSE crc32 instructions
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Completed initialization of buffer pool
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-18  9:15:51 140423824382208 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49271808652
2017-09-18  9:15:52 140423824382208 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Set innodb_force_recovery to ignore this error.
2017-09-18  9:15:52 140423824382208 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-18  9:15:52 140423824382208 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-18  9:15:52 140423824382208 [Note] Plugin 'FEEDBACK' is disabled.
2017-09-18  9:15:52 140423824382208 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-09-18  9:15:52 140423824382208 [ERROR] Aborting
 
Error in my_thread_global_end(): 1 threads didn't exit
2017-09-18  9:24:50 140716406409472 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
 
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Using Linux native AIO
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Using SSE crc32 instructions
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Completed initialization of buffer pool
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49271808652
2017-09-18  9:24:51 140716406409472 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Set innodb_force_recovery to ignore this error.
2017-09-18  9:24:51 140716406409472 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-18  9:24:51 140716406409472 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-18  9:24:51 140716406409472 [Note] Plugin 'FEEDBACK' is disabled.
2017-09-18  9:24:51 140716406409472 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-09-18  9:24:51 140716406409472 [ERROR] Aborting
 
Error in my_thread_global_end(): 1 threads didn't exit
like0

Answers

This question hasn't been answered yet. Login or create an account to be the first to answer it!