Issue Error mariadb stop because InnoDB storage engine failed

[fferraro87]

Hi,
i've this version plesk 17.5.3 patch #26 installed on a centos 7.4.1708 and this morning i've realized that mariadb service is down because of this :

Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown...
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [Note] Plugin 'FEEDBACK' is disabled.
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Aborting

but my wordpress sites are still working and that's strange...but now what can i do to solve this?

P.S. i've this version of mariadb installed on this VM :
Ver 15.1 Distrib 10.2.9-MariaDB, for Linux (x86_64) using readline 5.1
Thanks

 

[IgorG]

10.2.9-MariaDB

As far as I remember, MariaDB 10.2 version is not supported Software Requirements for Plesk
But anyway, you can try to fix it with help of this KB article Unable to start MySQL service: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

 

[fferraro87]

Hi, i've already try this KB article but it doesn't solve this problem.
So how can i downgrade to a mariadb older version?

And also, if i've mariadb stopped, why wordpress sites are still working?

Thanks

 

[IgorG]

And also, if i've mariadb stopped, why wordpress sites are still working?

Do you have mysql process up and running? Check it with

# ps ax | grep mysql

i've already try this KB article but it doesn't solve this problem.
So how can i downgrade to a mariadb older version?

Contribution - TUTORIAL: downgrade MariaDB 10.2 to MariaDB 10.1
Or contact Plesk Support Team.

 

[fferraro87]

yeah i've somy mysql process running but it's strange because i've mariadb service down

 

[IgorG]

Check that is is really MariaDB process but not additional MySQL instance with something like:

# ps ax | grep mysql
4590 pts/3 S+ 0:00 grep --color=auto mysql
27945 ? Ss 0:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
28130 ? Sl 0:44 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock

# lsof -p 27945
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld_sa 27945 mysql cwd DIR 0,27 4096 111284716 /
mysqld_sa 27945 mysql rtd DIR 0,27 4096 111284716 /
mysqld_sa 27945 mysql txt REG 0,27 960376 39989094 /usr/bin/bash
mysqld_sa 27945 mysql mem REG 0,27 1442824 /usr/bin/bash (path inode=39989094)
mysqld_sa 27945 mysql mem REG 0,27 2127336 39977917 /usr/lib64/libc-2.17.so
mysqld_sa 27945 mysql mem REG 0,27 19776 39977923 /usr/lib64/libdl-2.17.so
mysqld_sa 27945 mysql mem REG 0,27 174576 39989512 /usr/lib64/libtinfo.so.5.9
mysqld_sa 27945 mysql mem REG 0,27 164264 39977910 /usr/lib64/ld-2.17.so
mysqld_sa 27945 mysql 0u CHR 1,3 0t0 231361126 /dev/null
mysqld_sa 27945 mysql 255r REG 0,27 26977 39977840 /usr/bin/mysqld_safe

# rpm -qf /usr/bin/mysqld_safe
mariadb-server-5.5.56-2.el7.x86_64

 

[fferraro87]

it's a MariaDB process :

[root@lev-plesk-02 mariadb]# ps ax | grep mysql
19834 pts/0    S+     0:00 grep --color=auto mysql
32594 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/lev-plesk-02.pid
32700 ?        Sl     0:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/lib/mysql/lev-plesk-02.pid --socket=/var/lib/mysql/mysql.sock
[root@lev-plesk-02 mariadb]# lsof -p 32594
COMMAND     PID USER   FD   TYPE DEVICE  SIZE/OFF   NODE NAME
mysqld_sa 32594 root  cwd    DIR  253,0      4096 655361 /usr
mysqld_sa 32594 root  rtd    DIR  253,0      4096      2 /
mysqld_sa 32594 root  txt    REG  253,0    960608 656052 /usr/bin/bash
mysqld_sa 32594 root  mem    REG  253,0     62184 664308 /usr/lib64/libnss_files-2.17.so
mysqld_sa 32594 root  mem    REG  253,0 106070960 930863 /usr/lib/locale/locale-archive
mysqld_sa 32594 root  mem    REG  253,0   2127336 656086 /usr/lib64/libc-2.17.so
mysqld_sa 32594 root  mem    REG  253,0     19776 664193 /usr/lib64/libdl-2.17.so
mysqld_sa 32594 root  mem    REG  253,0    174576 656160 /usr/lib64/libtinfo.so.5.9
mysqld_sa 32594 root  mem    REG  253,0    164264 664642 /usr/lib64/ld-2.17.so
mysqld_sa 32594 root  mem    REG  253,0     26254 921146 /usr/lib64/gconv/gconv-modules.cache
mysqld_sa 32594 root    0r   CHR    1,3       0t0   1028 /dev/null
mysqld_sa 32594 root  255r   REG  253,0     30179 660996 /usr/bin/mysqld_safe
[root@lev-plesk-02 mariadb]# rpm -qf /usr/bin/mysqld_safe
MariaDB-server-10.2.9-1.el7.centos.x86_64

 

[IgorG]

And

# systemctl status mariadb

?

 

[fferraro87]

And

# systemctl status mariadb

?

[root@lev-plesk-02 mariadb]# systemctl status mariadb
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Tue 2017-10-24 11:01:51 CEST; 1h 20min ago
  Process: 14730 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 14693 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 14691 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 14730 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown...
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [Note] Plugin 'FEEDBACK' is disabled.
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 24 11:01:51 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:51 139851548907648 [ERROR] Aborting
Oct 24 11:01:51 lev-plesk-02 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Oct 24 11:01:51 lev-plesk-02 systemd[1]: Failed to start MariaDB database server.
Oct 24 11:01:51 lev-plesk-02 systemd[1]: Unit mariadb.service entered failed state.
Oct 24 11:01:51 lev-plesk-02 systemd[1]: mariadb.service failed.