Error establishing a database connection - Mariadb server is down


#1

Since this morning all my websites are showing:

Error establishing a database connection

with: service mysql restart I get: Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

I do: systemctl status mariadb.service I get: ● mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enable Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Wed 2017-09-13 11:26:44 UTC; 16s ago Process: 4210 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_ST Process: 4055 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||
Process: 4052 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSIT Process: 4050 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysq Main PID: 4210 (code=exited, status=1/FAILURE) Status: “MariaDB server is down” CGroup: /system.slice/mariadb.service └─3803 /usr/sbin/mysqld

I do not want to lose all my database since I have many websites running!

How to I fix this?

Many thanks


#2

i hope i won’t lose all my db!


#3

Someone finally helped me solve the problem. Disk was full and MySQL couldn’t write on it anymore. Deleting my log files did the job.


#4

@HENRI i have the same problem, but i check i still have free disk space. how do i solve this?


#5

Please look at this:

Let me know if it helps.

thx


#6