mariadb.service - MariaDB 10.3.27 database server Active: failed (Result: exit-code)

Discussion in 'Installation/Configuration' started by alexanderdev, Sep 30, 2021.

Tags:
  1. alexanderdev

    alexanderdev New Member

    Hello,

    When I unzip a folder on web3, which is the clone of web1, the server crashes. So, the mariadb error occurs, I delete the content of web 3, I restart the service "sudo service mysql start" and it works again. Here are some mistakes.

    Code:
    root@**:/var/www/clients/client0/web3/web# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.27 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mysql.service.d
           └─limits.conf
   Active: failed (Result: exit-code) since Thu 2021-09-30 08:40:38 UTC; 1min 56s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 25118 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 25121 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 25122 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 ||  Process: 25167 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 25167 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Sep 30 08:40:31 **systemd[1]: Starting MariaDB 10.3.27 database server...
Sep 30 08:40:31 **mysqld[25167]: 2021-09-30  8:40:31 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 25167 ...
Sep 30 08:40:38 **systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 30 08:40:38 **systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 30 08:40:38 **systemd[1]: Failed to start MariaDB 10.3.27 database server.
    --------------------------------------------------------------------------------------------------
    Code:
    root@**:/var/www/clients/client0/web3/web# sudo service mysql start
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
    --------------------------------------------------------------------------------------------------

    Thanks
     
    alexanderdev, Sep 30, 2021
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Is the hard disk full? Check all partitions with:

    df -h

    And this config issue on your server is not development-related, so I moved it to the installation and configuration forum.
     
    till, Sep 30, 2021
    #2
  3. alexanderdev

    alexanderdev New Member

    Ok till

    Code:
    web1@**:~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
udev             16G     0   16G   0% /dev
tmpfs           3.2G  305M  2.9G  10% /run
/dev/md2        469G  412G   33G  93% /
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/nvme0n1p1  511M  5.2M  506M   2% /boot/efi
tmpfs           3.2G     0  3.2G   0% /run/user/0
tmpfs           3.2G     0  3.2G   0% /run/user/5004
     
    alexanderdev, Oct 1, 2021
    #3

Share This Page