我的 MySQL 服务和数据库似乎在自己的 VPS 上处于离线状态。过去几个月它没有出现任何问题,所以我不确定是什么原因造成的。我做的最后一件事是禁用严格模式,mariadb
以便mybb
插件可以正常工作。
这是一个小时前的事了,现在数据库似乎处于离线状态。
我运行了systemctl status mariadb.service
,输出如下:
# systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset:
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: signal) since Tue 2018-01-30 21:57
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 6979 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_STAR
Process: 6970 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUC
Process: 12929 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_W
Process: 12774 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VA
Process: 12770 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_STAR
Process: 12767 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/r
Main PID: 12929 (code=killed, signal=KILL)
Jan 30 21:57:24 control systemd[1]: mariadb.service: Failed with result 'signal'
lines 1-16/16 (END)...skipping...
● mariadb.service - MariaDB 10.2.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: signal) since Tue 2018-01-30 21:57:24 EST; 2s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 6979 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6970 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Process: 12929 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=KILL)
Process: 12774 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-envir
Process: 12770 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 12767 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 12929 (code=killed, signal=KILL)
Jan 30 21:57:24 control systemd[1]: mariadb.service: Failed with result 'signal'.
我的phpmyadmin
错误是:
#2002 - Connection refused — The server is not responding (or the local server's socket is not correctly configured).
我不确定在我的 Debian 服务器上调试此问题的下一步是什么。
答案1
由于它是 SIGKILL,因此服务可能超时,请参阅扩展TimeoutStartSec
mariadb systemd 文档