• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

N
Issue cURL request: SSL connection timeout
Replies
4
Views
509
nico.exe
N
L
Issue Daily Maintenance Script Spawns Off A Bunch Of PHP-FPM processes Leading To Huge Load Spike
Replies
2
Views
369
Ladylinux
L
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
5K
Peter Debik
P
J
Resolved Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
6
Views
10K
JVG
J
Back
Top