• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue Mysql Broken after update

I

iceman333

Basic Pleskian
Plesk 17.5 Ubuntu 16.04

After MicroUpdate is broken today after the connection to Mysql.


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 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$E0...', Array) #1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /opt/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /opt/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /opt/psa/admin/plib/Plesk/Mode.php(433): get_param('disable_provisi...') #8 /opt/psa/admin (Abstract.php:144)

Search for related Knowledge Base articles


I can also not plesk repair.

What can I do that the server is running.

Wolfgang
 
First of all try to fix it with

# plesk repair installation
 
it is no runnig
This is mistake


plesk repair installation
[2017-05-30 11:26:37] ERR [panel] SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:111
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php:460
Zend_Db_Adapter_Abstract->query(string 'select param, val from misc', array)
3: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'select param, val from misc', array)
4: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:30
Db_Adapter_Pdo_Mysql->query(string 'select param, val from misc')
5: /opt/psa/admin/plib/db.php:36
db_query(string 'select param, val from misc', boolean false)
6: /opt/psa/admin/plib/db.php:212
get_param(string 'disable_provisioning')
7: /opt/psa/admin/plib/Plesk/Mode.php:433
Plesk_Mode::isProvisioningDisabled()
8: /opt/psa/admin/plib/common_func.php:95
util_exec(string 'send-error-report', array, array, string 'proc_open', NULL null)
9: /opt/psa/admin/plib/common_func.php:28
smart_exec(string 'send-error-report', array, array, string 'proc_open')
10: /opt/psa/admin/plib/Os.php:116
Os::exec(string 'send-error-report', array, string 'proc_open')
11: /opt/psa/admin/plib/CommonPanel/Exception.php:329
CommonPanel_Exception::_sendRuntimeReportXML(string 'Zend_Db_Adapter_Exception', string 'SQLSTATE[HY000] [2002] No such file or directory', string '/opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php', integer '144', integer '2002', string '#0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#3 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
#4 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
#5 /opt/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Application_Abstract::initDbAdapter()
#6 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initDb()
#7 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner->run()
#8 /opt/psa/admin/plib/api-cli/repair.php(4): require_once(string '/opt/psa/admin/plib/api-cli/CliUtilityRunner.php')
--
#0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct(string 'mysql:dbname=psa;host=localhost;port=3306;charset=utf8', string 'admin', string '******', array)
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
#5 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
#6 /opt/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Application_Abstract::initDbAdapter()
#7 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initDb()
#8 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner->run()
#9 /opt/psa/admin/plib/api-cli/repair.php(4): require_once(string '/opt/psa/admin/plib/api-cli/CliUtilityRunner.php')', integer '1', string '1f2f1b88afaae781b9e915d9ad540137', string '2eb8d2699e722503bf79ae1c7819dc4e')
12: /opt/psa/admin/plib/CommonPanel/Exception.php:170
CommonPanel_Exception::sendNotification(object of type Zend_Db_Adapter_Exception)
13: /opt/psa/admin/plib/api-common/AbstractCu.php:2432
AbstractCu::reportError(object of type Zend_Db_Adapter_Exception)
14: /opt/psa/admin/plib/api-cli/CliUtilityRunner.php:27
CliUtilityRunner->run()
15: /opt/psa/admin/plib/api-cli/CliUtilityRunner.php:35
require_once(string '/opt/psa/admin/plib/api-cli/CliUtilityRunner.php')
16: /opt/psa/admin/plib/api-cli/repair.php:4
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)
exit status 1
 
Try

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
 
done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
===> Tue May 30 11:30:00 CEST 2017, args: status
active
===> Tue May 30 11:30:00 CEST 2017, args: stop
Trying to start service mysql... /usr/sbin/mysqld is stopped
May 30 11:30:19 rv1331 systemd[1]: Failed to start MySQL Community Server.
May 30 11:30:19 rv1331 systemd[1]: mysql.service: Unit entered failed state.
May 30 11:30:19 rv1331 systemd[1]: mysql.service: Failed with result 'exit-code'.

WARNING!
Some problems are found during start service mysql(see log file: /var/log/plesk/psa_service.log)
 
In mysql logs try to find a reason why mysql service can't be started.
 
Now is runnig

there ist a Prob whis the last update


now i can repair

There are still some errors
 

Attachments

  • plesk_17.5.3_repair.log
    6.6 KB · Views: 12
iceman333 said:
There are still some errors
Click to expand...
I see nothing suspicious there except warning about server hostname:

Warning!
Unable to detect the fully qualified domain name of the host.
Please make sure that FQDN of the host is correctly specified in /etc/hosts and goes right after the host's IP address
(depending on your OS, you might need to set the host name in /etc/HOSTNAME or /etc/hostname).

Setting it to localhost.localdomain
Trying to resolve hostname 'localhost.localdomain' and validate its IP address... done
Click to expand...

You can set up server hostname with correct FQDN format or ignore this warning.
 
No idea what that is. The server has been running under the same name for years.

Is there guidance as I can change that
 
You must log in or register to reply here.

Similar threads

S
Question High server resource and mysql error
Replies
7
Views
2K
Peter Debik
P
Christopher-James
Issue DB query failed: SQLSTATE[HY000] [2002] Connection refused: after Obsidian update 18.0.53
Replies
10
Views
4K
Peter Debik
P
J
Resolved Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
2
Views
154
JVG
J
nethubonline
Resolved Plesk install failure on AlmaLinux 9
Replies
3
Views
1K
nethubonline
nethubonline
O
Resolved Cannot create subscription - fails on "Configuring mail"
Replies
8
Views
1K
octet
O
Back
Top