☰

Percona DB 未啟動：initscript mysql，操作「啟動」失敗

tag-icon • tag-icon ubuntu percona
Percona DB 未啟動：initscript mysql，操作「啟動」失敗

安裝 Percona 伺服器後，我收到以下訊息：

 * Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
 * Run the following commands to create these functions:

    mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
    mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
    mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

 * See http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details

Job for mysql.service failed. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package percona-server-server-5.6 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of percona-server-server:
 percona-server-server depends on percona-server-server-5.6; however:
  Package percona-server-server-5.6 is not configured yet.

dpkg: error processing package percona-server-server (--configure):
 dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.21-0ubuntu4) ...
Errors were encountered while processing:
 percona-server-server-5.6
 percona-server-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@public-server-01:~/src# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql (Percona Server) daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Wed 2015-09-30 04:26:52 UTC; 38min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 20916 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Sep 30 04:26:41 public-server-01 systemd[1]: Starting LSB: Start and stop the mysql (Percona Server) daemon...
Sep 30 04:26:41 public-server-01 mysql[20916]: * Starting MySQL (Percona Server) database server mysqld
Sep 30 04:26:52 public-server-01 systemd[1]: mysql.service: control process exited, code=exited status=1
Sep 30 04:26:52 public-server-01 systemd[1]: Failed to start LSB: Start and stop the mysql (Percona Server) daemon.
Sep 30 04:26:52 public-server-01 systemd[1]: Unit mysql.service entered failed state.
Sep 30 04:26:52 public-server-01 mysql[20916]: ...fail!
Sep 30 04:26:52 public-server-01 systemd[1]: mysql.service failed.

我不明白為什麼它沒有開始。

我正在運行 Ubuntu 15。1GB RAM...

答案1

錯誤訊息“軟體包 percona-server-server-5.6 尚未設定。”意味著軟體包沒有安裝。 Percona 軟體包需要按照正確的順序安裝：
先從公共庫開始，然後是客戶端，然後是伺服器-伺服器。

當您使用 dpkg 安裝時，您將看到 dpkg 報告的任何錯誤，必須先解決這些錯誤。有時，只需執行 apt-get -f install 即可透過安裝所需的軟體包來解決問題。

對於 Ubuntu 14.04：

dpkg-i percona-server-common-5.6_5.6.26-74.0-1.trusty_amd64.deb percona-server-client_5.6.26-74.0-1.trusty_amd64.deb percona-server-server-5.6_5.6.26-74.0-1.trusty_amd64.deb

一旦 dpkg 沒有出現錯誤，就可以開始了。

答案2

若要在不啟動 MySQL 服務的情況下強制安裝軟體包，請執行：

RUNLEVEL=1 apt install -y percona-xtradb-cluster-57

來源：安裝軟體包而不啟動後台程序和服務。

安裝軟體包後它將阻止守護進程啟動。

目前尚不清楚為什麼你的Percona伺服器無法啟動 MySQL 伺服器，若要檢查詳細信息，請執行：

journalctl -xe

或檢查MySQL日誌：

tail -n50 /var/log/mysqld.log

最常見的問題是安裝/啟動Percona伺服器叢集配置尚不存在，因此服務無法連接到現有叢集。

如果是這樣，請檢查 中的配置文件/etc/mysql/percona-xtradb-cluster.conf.d/，尤其wsrep_cluster_address是wsrep.cnf.在第一次啟動服務之前，請先嘗試取消註解。

也可以看看：在 Ubuntu 上無人值守安裝 Percona/MySQL。

對於文件頁面，請檢查：Percona XtraDB Cluster 5.7 文檔。

相關內容