Mysql

mysqld 不會在 Fedora 22 上啟動

  • September 30, 2016

我有一個使用 Fedora 22 執行 LAMP 堆棧的 vm。這是一個專用於執行 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

誰能指出我正確的方向?

我發現了問題。硬碟驅動器空間不足。我想 MySQL 沒有足夠的空間寫入日誌,導致它失敗。

由於這是一個虛擬機,我添加了虛擬驅動器空間。

發布此內容是希望對其他人有所幫助,並且我的時間對某人有所幫助。

引用自:https://serverfault.com/questions/806393