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

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

  1. alexanderdev

    alexanderdev New Member


    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.

    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
       Active: failed (Result: exit-code) since Thu 2021-09-30 08:40:38 UTC; 1min 56s ago
         Docs: man:mysqld(8)
      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.
    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.

  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.
  3. alexanderdev

    alexanderdev New Member

    Ok till

    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

Share This Page