CentOS 7.x mariadb fail to start issue resolution

<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:

• https://support.plesk.com/hc/en-us/articles/213398969-Unable-to-start-MySQL-service-Plugin-InnoDB-registration-as-a-STORAGE-ENGINE-failed-
• https://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/

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