• 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

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