Question High server resource and mysql error

[spaceteam]

Server operating system version

centos 7

Plesk version and microupdate number

Version 18.0.52

Hi,
Can anyone advise on the below error?


[2023-06-08 17:18:00.922] 22273:64819cba84ccd ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:113
CommonPanel_Application_Abstract::initDbAdapter(boolean true)
2: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:109
Db_Adapter_Pdo_Mysql->reconnect()
3: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:57
Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `domains`')
4: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Adapter/Pdo/Mysql.php:171
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'domains', NULL null)
5: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:836
Zend_Db_Table_Abstract->_setupMetadata()
6: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:875
Zend_Db_Table_Abstract->_setupPrimaryKey()
7: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:983
Zend_Db_Table_Abstract->info()
8: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Select.php:100
Zend_Db_Table_Select->setTable(object of type Db_Table_Broker_Domains)
9: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Select.php:78
Zend_Db_Table_Select->__construct(object of type Db_Table_Broker_Domains)
10: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:1019
Zend_Db_Table_Abstract->select()
11: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:1376
Zend_Db_Table_Abstract->fetchAll(string '`name` = 'domain.hk'', NULL null, NULL null)
12: /usr/local/psa/admin/plib/Db/Table/Abstract.php:206
Db_Table_Abstract->findByFields(array, boolean true)
13: /usr/local/psa/admin/plib/Db/Table/Abstract.php:256
Db_Table_Abstract->findOneByFields(array)
14: /usr/local/psa/admin/plib/Db/Table/Broker/Domains.php:252
Db_Table_Broker_Domains->getDomainByName(string 'domain.com.hk')
15: /usr/local/psa/admin/plib/Service/Mail/OutgoingMessages/Abstract.php:98
Service_Mail_OutgoingMessages_Abstract->aggregateStatistics(array)
16: /usr/local/psa/admin/plib/Service/Mail/OutgoingMessages/Abstract.php:164
Service_Mail_OutgoingMessages_Abstract->collectStatistics(boolean true)
17: /usr/local/psa/admin/plib/Commands/CollectOutgoingMessagesStats.php:28
Commands_CollectOutgoingMessagesStats->collectStats()
18: /usr/local/psa/admin/plib/DailyMaintainance/Task/StoreOutgoingMessagesStatistics.php:17
DailyMaintainance_Task_StoreOutgoingMessagesStatistics->run(array)
19: /usr/local/psa/admin/plib/DailyMaintainance/Runner/Task.php:56
DailyMaintainance_Runner_Task->runTask(object of type DailyMaintainance_Task_StoreOutgoingMessagesStatistics, array)
20: /usr/local/psa/admin/plib/DailyMaintainance/Runner/Task.php:31
DailyMaintainance_Runner_Task->run()
21: /usr/local/psa/admin/plib/DailyMaintainance/task-script.php:17
[2023-06-08 17:18:01.376] 22285:64819cc924211 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:113
CommonPanel_Application_Abstract::initDbAdapter()
2: /usr/local/psa/admin/plib/Db/Table/Broker.php:144
Db_Table_Broker::_init()
3: /usr/local/psa/admin/plib/Db/Table/Broker.php:48
Db_Table_Broker::get(string 'mailnames')
4: /usr/local/psa/admin/htdocs/mailconfig/index.php:125
[2023-06-08 17:18:01.376] 22277:64819cc9241bf ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:113
CommonPanel_Application_Abstract::initDbAdapter()
2: /usr/local/psa/admin/plib/Db/Table/Broker.php:144
Db_Table_Broker::_init()
3: /usr/local/psa/admin/plib/Db/Table/Broker.php:48
Db_Table_Broker::get(string 'mailnames')
4: /usr/local/psa/admin/htdocs/mailconfig/index.php:125
[2023-06-08 17:18:01.437] 22277:64819cc9241bf ERR [panel] Cannot load settings: DB query failed: SQLSTATE[HY000] [2002] Connection refused
[2023-06-08 17:18:01.438] 22285:64819cc924211 ERR [panel] Cannot load settings: DB query failed: SQLSTATE[HY000] [2002] Connection refused
[2023-06-08 17:18:02.062] 22277:64819cc9241bf ERR [panel] SQLSTATE[HY000] [2002] Connection refused
[2023-06-08 17:18:02.062] 22285:64819cc924211 ERR [panel] SQLSTATE[HY000] [2002] Connection refused
[2023-06-08 17:18:03.007] 21993:64819ccb00d8d ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused

 

[Peter Debik]

What is the output of
# service mariadb status
?

 

[spaceteam]

service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /usr/lib/systemd/system/mariadb.service.d
└─respawn.conf
Active: active (running) since Thu 2023-06-01 20:09:24 CST; 1 weeks 1 days ago
Main PID: 1347 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─ 1347 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─22575 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-fi...

Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.

 

[Maarten.]

Your database server seems to be down.
Start it with:

# systemctl start mariadb

 

[spaceteam]

It is not down, it is active

 

[Peter Debik]

Can you run
# plesk db
and does this log you into the database console?

 

[spaceteam]

Yes, it is

 

[Peter Debik]

Could you please log in to the database through the console (# plesk db) and check how many processes are active? Like
> show processlist;
? The big question is why the connection is refused although the database is online. There can be a number of reasons such as a large number of processes so that the datatabase does not allow more to be added. But it is also possible that the connection is refused, because the "admin" user is lacking permissions. That has been seen when skip_name_resolve was missing from /etc/my.cnf. Could you please show the content of /etc/my.cnf?