• 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.

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

@amirb322

I have taken some considerable effort to reproduce your issue and there are multiple explanations for the root cause of the problem.

It is or was not a good idea to use the plesk repair utility, meaning that I hope that we can still solve the issue as best as possible.

With respect to your question

what is the "adequate" information?

I suggest that you provide the log of /var/mysql/error.log after a restart of mysql (if that is still possible).

There are three types of log entries that are particular of interest:

1 - all notifications with [error] in the log entry line: you can use a grep command to get those log entries, (and)

2 - notifications hinting InnoDB database corruption: use a command like grep -in corruption /var/mysql/error.log > errors.txt and present the text file in this forum, (and)

3 - if mysql is running, notifications of the kind [Warning] InnoDB: Cannot open table mysql/<table name>: use a similar command as mentioned under point 2 and provide the text file in this forum, to allow us to see if and to what extent your MySQL database server is broken or malfunctioning.

Finally, note that I will be writing some explanation and information with respect to the type of MySQL issue that you have, but I first have to find some time for that.

In the meantime, we can surely focus on your particular issue ......

....... hope the above helps a bit.

Kind regards!
 
My bad, I made a typo: have a look into /var/log/mysql directory! (sorry, I forgot to type the "log" part).
i just found /var/log/mysqld.log
and use grep to see that lines belong today after reboot system
 

Attachments

  • log mysqld.JPG
    log mysqld.JPG
    168.2 KB · Views: 10
this is all log for today:
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 3:47:19 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 5:00:01 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 8:35:53 [Note] /usr/libexec/mysqld: Normal shutdown
180807 8:35:53 [Note] Event Scheduler: Purging the queue. 0 events
180807 8:35:53 InnoDB: Starting shutdown...
180807 8:35:57 InnoDB: Shutdown completed; log sequence number 3841069688
180807 8:35:57 [Note] /usr/libexec/mysqld: Shutdown complete
180807 8:36:00 [Note] Plugin 'FEDERATED' is disabled.
180807 8:36:00 InnoDB: The InnoDB memory heap is disabled
180807 8:36:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180807 8:36:00 InnoDB: Compressed tables use zlib 1.2.3
180807 8:36:00 InnoDB: Using Linux native AIO
180807 8:36:00 InnoDB: Initializing buffer pool, size = 128.0M
180807 8:36:00 InnoDB: Completed initialization of buffer pool
180807 8:36:00 InnoDB: highest supported file format is Barracuda.
180807 8:36:02 InnoDB: Waiting for the background threads to start
180807 8:36:03 InnoDB: 5.5.60 started; log sequence number 3841069688
180807 8:36:03 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
180807 8:36:03 [Note] - '127.0.0.1' resolves to '127.0.0.1';
180807 8:36:03 [Note] Server socket created on IP: '127.0.0.1'.
180807 8:36:12 [Warning] 'user' entry 'livedbuser@support2' ignored in --skip-name-resolve mode.
180807 8:36:12 [Warning] 'db' entry 'livechatdb livedbuser@support2' ignored in --skip-name-resolve mode.
180807 8:36:12 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
180807 8:36:12 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
180807 8:36:12 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
180807 8:36:12 [Note] Event Scheduler: Loaded 0 events
180807 8:36:12 [Note] /usr/libexec/mysqld: ready for connections.

i have reset mysqld at 8:35.
 
i'v do that and the new logs here:
180807 13:45:00 [ERROR] Invalid (old?) table or database name 'mysql-files'
180807 13:45:14 [Warning] 'user' entry 'livedbuser@support2' ignored in --skip-name-resolve mode.
180807 13:45:14 [Warning] 'db' entry 'livechatdb livedbuser@support2' ignored in --skip-name-resolve mode.
180807 13:45:55 [Note] /usr/libexec/mysqld: Normal shutdown
180807 13:45:55 [Note] Event Scheduler: Purging the queue. 0 events
180807 13:45:55 InnoDB: Starting shutdown...
180807 13:45:57 InnoDB: Shutdown completed; log sequence number 3843038795
180807 13:45:57 [Note] /usr/libexec/mysqld: Shutdown complete
180807 13:45:58 [Note] Plugin 'FEDERATED' is disabled.
180807 13:45:58 InnoDB: The InnoDB memory heap is disabled
180807 13:45:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180807 13:45:58 InnoDB: Compressed tables use zlib 1.2.3
180807 13:45:58 InnoDB: Using Linux native AIO
180807 13:45:58 InnoDB: Initializing buffer pool, size = 128.0M
180807 13:45:58 InnoDB: Completed initialization of buffer pool
180807 13:45:58 InnoDB: highest supported file format is Barracuda.
180807 13:45:58 InnoDB: Waiting for the background threads to start
180807 13:45:59 InnoDB: 5.5.60 started; log sequence number 3843038795
180807 13:45:59 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
180807 13:45:59 [Note] - '127.0.0.1' resolves to '127.0.0.1';
180807 13:45:59 [Note] Server socket created on IP: '127.0.0.1'.
180807 13:46:05 [Warning] 'user' entry 'livedbuser@support2' ignored in --skip-name-resolve mode.
180807 13:46:05 [Warning] 'db' entry 'livechatdb livedbuser@support2' ignored in --skip-name-resolve mode.
180807 13:46:05 [Note] Event Scheduler: Loaded 0 events
180807 13:46:05 [Note] /usr/libexec/mysqld: ready for connections.

still plesk panel not working :(
 
Last edited:
and this is all happend after "plesk repair db" command:

# plesk repair db
PHP Deprecated: Comments starting with '#' are deprecated in /usr/local/psa/admin/conf/php.ini on line 39 in Unknown on line 0
PHP Deprecated: Comments starting with '#' are deprecated in /usr/local/psa/admin/conf/php.ini on line 40 in Unknown on line 0
[2018-08-07 09:18:43] ERR [panel] SQLSTATE[HY000] [2002] No such file or directory:
0: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:111
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php:460
Zend_Db_Adapter_Abstract->query(string 'select param, val from misc', array)
3: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'select param, val from misc', array)
4: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:30
Db_Adapter_Pdo_Mysql->query(string 'select param, val from misc')
5: /usr/local/psa/admin/plib/db.php:36
db_query(string 'select param, val from misc', boolean false)
6: /usr/local/psa/admin/plib/db.php:212
get_param(string 'disable_provisioning')
7: /usr/local/psa/admin/plib/Plesk/Mode.php:423
Plesk_Mode::isProvisioningDisabled()
8: /usr/local/psa/admin/plib/common_func.php:95
util_exec(string 'send-error-report', array, array, string 'proc_open', NULL null)
9: /usr/local/psa/admin/plib/common_func.php:28
smart_exec(string 'send-error-report', array, array, string 'proc_open')
10: /usr/local/psa/admin/plib/Os.php:116
Os::exec(string 'send-error-report', array, string 'proc_open')
11: /usr/local/psa/admin/plib/CommonPanel/Exception.php:328
CommonPanel_Exception::_sendRuntimeReportXML(string 'Zend_Db_Adapter_Exception', string 'SQLSTATE[HY000] [2002] No such file or directory', string '/usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php', integer '144', integer '2002', string '#0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#3 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
#4 /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
#5 /usr/local/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Application_Abstract::initDbAdapter()
#6 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initDb()
#7 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner->run()
#8 /usr/local/psa/admin/plib/api-cli/repair.php(4): require_once(string '/usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php')
--
#0 /usr/local/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 /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(string 'SET sql_mode = ''', array)
#4 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
#5 /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
#6 /usr/local/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Application_Abstract::initDbAdapter()
#7 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initDb()
#8 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner->run()
#9 /usr/local/psa/admin/plib/api-cli/repair.php(4): require_once(string '/usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php')', integer '1', string '1f2f1b88afaae781b9e915d9ad540137', string '2eb8d2699e722503bf79ae1c7819dc4e')
12: /usr/local/psa/admin/plib/CommonPanel/Exception.php:170
CommonPanel_Exception::sendNotification(object of type Zend_Db_Adapter_Exception)
13: /usr/local/psa/admin/plib/api-common/AbstractCu.php:2432
AbstractCu::reportError(object of type Zend_Db_Adapter_Exception)
14: /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php:27
CliUtilityRunner->run()
15: /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php:35
require_once(string '/usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php')
16: /usr/local/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
 
I would suggest you contact Plesk Support Team. They will fix it directly on your server.
 
Back
Top