ubuntu - mariadb.service : Failed with result 'signal'

Question

从今天早上开始，我在使用 Plesk 的 Ubuntu 18.04 上运行的 mariadb.service 出现问题。它停止了，我无法再次重新启动它。

service mysqld start
Job for mariadb.service failed because a fatal signal was delivered to the control process.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.27 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 Thu 2019-10-24 21:14:25 CEST; 3s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 26703 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 26699 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 26932 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
  Process: 26717 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (co
  Process: 26715 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 26714 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 26932 (code=killed, signal=ABRT)

Okt 24 18:21:40 XXXXX systemd[1]: mariadb.service: Failed with result 'signal'.
Okt 24 18:21:40 XXXXX systemd[1]: Failed to start MariaDB 10.2.27 database server.
Okt 24 18:21:45 XXXXX systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Okt 24 18:21:45 XXXXX systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1251.
Okt 24 18:21:45 XXXXX systemd[1]: Stopped MariaDB 10.2.27 database server.
Okt 24 18:21:45 XXXXX systemd[1]: Starting MariaDB 10.2.27 database server...
Okt 24 18:21:46 XXXXX mysqld[22593]: 2019-10-24 18:21:46 140599485605184 [Note] /usr/sbin/mysqld (mysqld 10.2.27-MariaDB-1:10.2.27+maria~bionic) starting as process 22593 ...
Okt 24 18:21:47 XXXXX systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT
Okt 24 18:21:47 XXXXX systemd[1]: mariadb.service: Failed with result 'signal'.
Okt 24 18:21:47 XXXXX systemd[1]: Stopped MariaDB 10.2.27 database server.

我已经尝试过以下事情:

服务器重启

mysql service fails to start/hangs up - timeout (Ubuntu, MariaDB)

https://help.univention.com/t/problem-mysql-server-does-not-start-any-more/10010

如何让 mariadb 再次运行？

Answer 1

您必须查看 mysqld 日志才能找到原因，在我的情况下是/var/log/mysql/mysqld.log 文件。搜索包含 [ERROR] [FATAL] 关键字的最后一个字符串，并阅读/谷歌上面的错误消息。