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