問題

注意：本文中所描述的問題是由來自 Atomic repository 的 MySQL 更新引起的，因此在執(zhí)行修復(fù)之前請(qǐng)務(wù)必啟用 Atomic repository：

# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
?* atomic: www4.atomicorp.com

• 更新后MySQL無法啟動(dòng)。


• 在 Plesk 中會(huì)顯示以下錯(cuò)誤信息：

Error in Plesk:
ERROR: PleskFatalException 

Unable to connect to database: mysql_connect() [href='function.mysql-connect'>function.mysql-connect]: No 
such file or directory

0: common_func.php3:153 
psaerror(string
 'Unable to connect to database: mysql_connect() [href='function.mysql-connect'>function.mysql-connect]: No 
such file or directory') 
1: auth.php3:116

或

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Abstract.php:144)

Search for related Knowledge Base articles

ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] 
[2002] No such file or directory' in 
/usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 
Stack trace: #0 
/usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): 
PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$Zm...',
 Array) #1 
/usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): 
Zend_Db_Adapter_Pdo_Abstract->_connect() #2 
/usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): 
Zend_Db_Adapter_Pdo_Mysql->_connect() #3 
/usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): 
Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 
/usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): 
Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 
/usr/local/psa/admin/plib/db.php(36): 
Db_Adapter_Pdo_Mysql->query('select param, v...') #6 
/usr/local/psa/admin/plib/db.php(212): db_query('select param, v...', 
false) #7 /usr/local/psa/admin/plib/Plesk/Mode.php(4 (Abstract.php:144)

• 在 /var/log/mysqld.log 中沒有記錄。

原因

Atomic 發(fā)行了損壞的?mysql 包到其 repositories 中。
在更新過程中 mysql 安裝包會(huì)被更新，但是卻未創(chuàng)建所需的目錄 /var/lib/mysql-files。

解決方案

此問題已被 Atomic 通過 5.5.54-1199 版本的 mysql-server 包進(jìn)行修復(fù)。請(qǐng)將包更新到最新版本：

# yum update mysql-server

如果沒有標(biāo)記要更新的包，請(qǐng)清除 yum 緩存：

# yum clean all

# yum update mysql-server