Restart MariaBD Error

Hi,
I such to restart MariaDB, but the restart return a Error. However the DB is working on production.
You can see the error message :

Code:

root@SRVIS:/var/www/admin.fr/web# systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.6 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Mon 2021-07-26 14:29:15 CEST; 1h 24min ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 29467 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 29470 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 29472 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 29524 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 29524 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [Note] InnoDB: 10.5.6 started; log sequence number 35025; transaction id 9
Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [Note] Plugin 'FEEDBACK' is disabled.
Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [ERROR] Failed to initialize plugins.
Jul 26 14:29:13 SRVIS mariadbd[29524]: 2021-07-26 14:29:13 0 [ERROR] Aborting
Jul 26 14:29:15 SRVIS systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 26 14:29:15 SRVIS systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 26 14:29:15 SRVIS systemd[1]: Failed to start MariaDB 10.5.6 database server.
root@SRVIS:/var/www/admin.achatnet.fr/web# systemctl restart mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@SRVIS:/var/www/admin.fr/web# systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.6 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Mon 2021-07-26 15:54:33 CEST; 26s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 10786 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 10799 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 10802 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 10862 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 10862 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [Note] InnoDB: 10.5.6 started; log sequence number 35037; transaction id 9
Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [Note] Plugin 'FEEDBACK' is disabled.
Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [Note] InnoDB: Buffer pool(s) load completed at 210726 15:54:31
Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [ERROR] Failed to initialize plugins.
Jul 26 15:54:31 SRVIS mariadbd[10862]: 2021-07-26 15:54:31 0 [ERROR] Aborting
Jul 26 15:54:33 SRVIS systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 26 15:54:33 SRVIS systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 26 15:54:33 SRVIS systemd[1]: Failed to start MariaDB 10.5.6 database server.

The status maria is write in Down, but this is working !!!


You can see :

Code:

df -h
Filesystem      Size  Used Avail Use% Mounted on
udev             16G     0   16G   0% /dev
tmpfs           3.2G  362M  2.8G  12% /run
/dev/md1        468G  141G  304G  32% /
tmpfs            16G     0   16G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs            16G     0   16G   0% /sys/fs/cgroup
/dev/md0        282M  108M  155M  42% /boot
tmpfs           3.2G     0  3.2G   0% /run/user/1000

And

Code:

free -h
              total        used        free      shared  buff/cache   available
Mem:           31Gi       7.0Gi       6.1Gi       1.0Gi        18Gi        22Gi

Have you a idea to help me ?
I don't want to make a mistake

Thank you a lot

 

Have you tried rebooting?
What OS is this?
You show ERROR lines for mariadb, but the lines are cut so full message might be more informative.

 

Thank for your reply.
I Edit my first post to past the full error

Code:

lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 10 (buster)
Release:        10
Codename:       buster

I'm afraid to reboot the server (because is in production) that te MYSQL don't mount.

 

Debian 10 has

Code:

$ LANG=C apt policy mariadb-common
mariadb-common:
  Installed: 1:10.3.29-0+deb10u1
  Candidate: 1:10.3.29-0+deb10u1

I suspect MariaDB 10.5.6 has been installed from outside of Debian, and this causes the issues you have. Downgrading database may be very complicated, I do not have easy solutions.
How did this Debian 10 system end up with MariaDB 10.5.6 version?