Witam, na moim serwerze było 100% zajetosci dysku df -h więc usunąłem stare backupy,
nagle padła mi cała baza, nie mogę odpalić mysql.
service restart mysql
zwraca mi błąd:
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
● mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/http://www.php.net/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/http://www.php.net/system/http://www.php.net/mysql.service.d └─limits.conf Active: failed (Result: exit-code) since Fri 2018-10-19 14:20:50 CEST; 13s ago Process: 19029 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 18940 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR | Process: 18938 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 18934 ExecStartPre=/usr/bin/install -m 755 -o http://www.php.net/mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 19029 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Oct 19 14:20:47 rekin2 systemd[1]: Starting MariaDB database server... Oct 19 14:20:48 rekin2 mysqld[19029]: 2018-10-19 14:20:48 140115641451072 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 19029 ... Oct 19 14:20:50 rekin2 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Oct 19 14:20:50 rekin2 systemd[1]: Failed to start MariaDB database server. Oct 19 14:20:50 rekin2 systemd[1]: mariadb.service: Unit entered failed state. Oct 19 14:20:50 rekin2 systemd[1]: mariadb.service: Failed with result 'exit-code'.
● mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/http://www.php.net/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/http://www.php.net/system/http://www.php.net/mysql.service.d └─limits.conf Active: failed (Result: exit-code) since Fri 2018-10-19 14:31:08 CEST; 7s ago Process: 22148 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 22059 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR | Process: 22056 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 22052 ExecStartPre=/usr/bin/install -m 755 -o http://www.php.net/mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 22148 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Oct 19 14:31:05 rekin2 systemd[1]: Starting MariaDB database server... Oct 19 14:31:05 rekin2 mysqld[22148]: 2018-10-19 14:31:05 139731825349184 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 22148 ... Oct 19 14:31:08 rekin2 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Oct 19 14:31:08 rekin2 systemd[1]: Failed to start MariaDB database server. Oct 19 14:31:08 rekin2 systemd[1]: mariadb.service: Unit entered failed state. Oct 19 14:31:08 rekin2 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Zobacz w /var/log/mysql
ale obstawiam że został plik procesu w /var/run/mysql.pid
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)