我有一个运行带有 Fedora 22 的 LAMP 堆栈的虚拟机。这是专用于运行 OwnCloud 的服务器。
服务器和 OwnCLoud 运行良好,已经好几个星期了。我不得不重启服务器。重启后,mysqld 无法启动。尝试手动启动服务也失败了。
[root@cloudServ]/home/rcreasy# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with
error code. See "systemctl status mysqld.service" and "journalctl -xe"
for details.
以下是 systemctl status mysqld.service 的结果
[root@cloudServ]/home/rcreasy# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Fri 2016-09-30 12:03:34 EDT; 1min 3s ago
Process: 3851 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 3829 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Sep 30 12:03:34 cloudServ systemd[1]: mysqld.service: Unit entered failed state.
Sep 30 12:03:34 cloudServ systemd[1]: mysqld.service: Failed with result 'exit-code'.
Sep 30 12:03:34 cloudServ systemd[1]: mysqld.service: Service hold-off time over, scheduling ...art.
Sep 30 12:03:34 cloudServ systemd[1]: mysqld.service: Start request repeated too quickly.
Sep 30 12:03:34 cloudServ systemd[1]: Failed to start MySQL Server.
Sep 30 12:03:34 cloudServ systemd[1]: mysqld.service: Unit entered failed state.
Sep 30 12:03:34 cloudServ systemd[1]: mysqld.service: Failed with result 'start-limit'.
journalctl -xe 给出多行(其中 XXX 是几个不同的数字)
Sep 30 12:15:12 cloudServ ownCloud[XXX]: {remote} Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or dir
/var/log/mysqld.log 中没有写入任何新内容,所有权在 /var/lib/mysql,其内容为 mysql:mysql
有人能给我指出正确的方向吗?
答案1
我找到了问题所在。硬盘空间不足。我猜想 MySQL 没有足够的空间写入日志,导致它失败。
因为这是一个虚拟机,所以我添加了虚拟驱动器空间。
发布此信息是希望它能够帮助其他人,并且我的时间能够对某人有所帮助。