CentOS 7.x mariadb fail to start issue resolution

From Notes_Wiki
Revision as of 10:02, 14 October 2017 by Saurabh (talk | contribs) (Created page with "<yambe:breadcrumb>CentOS_7.x_mariadb|CentOS 7.x mariadb</yambe:breadcrumb> =CentOS 7.x mariadb fail to start issue resolution= Sometimes MySQL might fail to start with follow...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

<yambe:breadcrumb>CentOS_7.x_mariadb|CentOS 7.x mariadb</yambe:breadcrumb>

CentOS 7.x mariadb fail to start issue resolution

Sometimes MySQL might fail to start with following log lines:

2017-07-20T06:43:18.460583Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
2017-07-20T06:48:39.661099Z mysqld_safe Starting mysqld daemon with databases from /dbdata/mysql
2017-07-20T06:48:39.871229Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-20T06:48:39.872727Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.13-log) starting as process 4524 ...
2017-07-20T06:48:39.879135Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-07-20T06:48:39.879167Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-07-20T06:48:39.879177Z 0 [Note] InnoDB: Uses event mutexes
2017-07-20T06:48:39.879189Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-07-20T06:48:39.879198Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-07-20T06:48:39.879205Z 0 [Note] InnoDB: Using Linux native AIO
2017-07-20T06:48:39.880144Z 0 [Note] InnoDB: Number of pools: 1
2017-07-20T06:48:39.880325Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-07-20T06:48:39.882523Z 0 [Note] InnoDB: Initializing buffer pool, total size = 12G, instances = 8, chunk size = 128M
2017-07-20T06:48:40.888960Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-07-20T06:48:41.003890Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-07-20T06:48:41.016253Z 0 [ERROR] InnoDB: Only one log file found.
2017-07-20T06:48:41.016281Z 0 [ERROR] InnoDB: Plugin initialization aborted with error not found
2017-07-20T06:48:41.617026Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-07-20T06:48:41.617064Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-07-20T06:48:41.617074Z 0 [ERROR] Failed to initialize plugins.
2017-07-20T06:48:41.617103Z 0 [ERROR] Aborting
2017-07-20T06:48:41.617132Z 0 [Note] Binlog end
2017-07-20T06:48:41.617697Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

The issue can be resolved by renaming ib_logfile0 and ib_logfile1 to some other names.

Refer:



<yambe:breadcrumb>CentOS_7.x_mariadb|CentOS 7.x mariadb</yambe:breadcrumb>