被终止的查询仍在运行。因此我停止了服务器并尝试重新启动它。但现在它拒绝启动。错误如下:Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
输出systemctl status mysql.service
:
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2020-05-28 15:52:16 IST; 15s ago
Docs: man:systemd-sysv-generator(8)
Process: 16718 ExecStop=/etc/init.d/mysql stop (code=killed, signal=TERM)
Process: 27200 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Tasks: 28
Memory: 28.9G
CPU: 32.735s
我正在运行 MariaDB 10。
答案1
我找到了pid
formysqld
并发出了 a kill -9
,然后启动了 mysql。成功了。