• 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

Resolved Error on Plesk Admin

P

pbpromotion

New Pleskian
Hello,

i want to start a new backup and get after a while this error when i refresh the tab

Code: 
ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_4316_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `sessions`

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Mysql.php:53)

Search for related Knowledge Base articles

Can anyone help?
 
Here is the backup protocol

Code: 
Error:
Runtime error: The dump has wrong format! backup_info_1702241439.xml: Line 685 error: Element 'rotation': Missing child element(s). Expected is one of ( disabled, by-time, by-entires ). Line 706 error: Element 'file-sharing-settings': Missing child element(s). Expected is ( setting ).
Error:
The dump has wrong format! backup_info_1702241439.xml: Line 685 error: Element 'rotation': Missing child element(s). Expected is one of ( disabled, by-time, by-entires ). Line 706 error: Element 'file-sharing-settings': Missing child element(s). Expected is ( setting ).
Error: server "server"
Cannot encrypt dump file (this is not fatal error!): DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_4316_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `clients`
Warning: server "server"
backup_restore_helper utility returned incorrect result. Extension with ID 3 cannot be backuped. Please, contact your service provider
Warning: server "server"
Unable to get Global settings for APS Applications (ErrorCode: 1, STDOUT:).
Warning: server "server"
Return code of sitebuilder bru utility: 255. Some errors occured during sitebuilder backup. Please see psadump.log file for more information
Warning: domain "pl.pricelook24.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "pl.pricelook24.de"
DNS Service on domain pl.pricelook24.de is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "pl.pricelook24.de"
Broken referencial integrity: DNS zone id 1 is not found in dns_zone
Warning: mysql "bonuswelt"
Not all the data was backed up into /var/lib/psa/dumps/domains/pl.pricelook24.de/databases/bonuswelt_1 successfully. mysqldump: Got error: 1030: "Got error 24 "Too many open files" from storage engine MyISAM" when using LOCK TABLES
Warning: hosting "pl.pricelook24.de"
Unable to backup Site Builder publishing status on site pl.pricelook24.de (ErrorCode: 1, STDOUT:).
Warning: domain "im-schlaf-verdienen.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "im-schlaf-verdienen.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "im-schlaf-verdienen.de"
Broken referencial integrity: DNS zone id 2 is not found in dns_zone
Warning: hosting "im-schlaf-verdienen.de"
Unable to backup Site Builder publishing status on site im-schlaf-verdienen.de (ErrorCode: 1, STDOUT:).
Warning: domain "pricelook24.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "pricelook24.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "pricelook24.de"
Broken referencial integrity: DNS zone id 3 is not found in dns_zone
Warning: hosting "pricelook24.de"
Unable to backup Site Builder publishing status on site pricelook24.de (ErrorCode: 1, STDOUT:).
Warning: domain "piwik.pricelook24.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "piwik.pricelook24.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "piwik.pricelook24.de"
Broken referencial integrity: DNS zone id 4 is not found in dns_zone
Warning: hosting "piwik.pricelook24.de"
Unable to backup Site Builder publishing status on site piwik.pricelook24.de (ErrorCode: 1, STDOUT:).
Warning: domain "pbpromotion.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "pbpromotion.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "pbpromotion.de"
Broken referencial integrity: DNS zone id 5 is not found in dns_zone
Warning: domain "meinefinanzen24.info"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "meinefinanzen24.info"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "meinefinanzen24.info"
Broken referencial integrity: DNS zone id 6 is not found in dns_zone
Warning: hosting "meinefinanzen24.info"
Unable to backup Site Builder publishing status on site meinefinanzen24.info (ErrorCode: 1, STDOUT:).
Warning: domain "sofortgutschriften.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "sofortgutschriften.de"
Broken referencial integrity: forward for domain sofortgutschriften.de is not found in forwarding
Warning: domain "sofortgutschriften.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "sofortgutschriften.de"
Broken referencial integrity: DNS zone id 7 is not found in dns_zone
Warning: domain "bonus-welt.eu"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "bonus-welt.eu"
Broken referencial integrity: forward for domain bonus-welt.eu is not found in forwarding
Warning: domain "bonus-welt.eu"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "bonus-welt.eu"
Broken referencial integrity: DNS zone id 8 is not found in dns_zone
Warning: domain "noback.pbpromotion.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "noback.pbpromotion.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "noback.pbpromotion.de"
Broken referencial integrity: DNS zone id 9 is not found in dns_zone
Warning: hosting "noback.pbpromotion.de"
Unable to backup Site Builder publishing status on site noback.pbpromotion.de (ErrorCode: 1, STDOUT:).
Warning: domain "vbox.pricelook24.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "vbox.pricelook24.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "vbox.pricelook24.de"
Broken referencial integrity: DNS zone id 11 is not found in dns_zone
Warning: hosting "vbox.pricelook24.de"
Unable to backup Site Builder publishing status on site vbox.pricelook24.de (ErrorCode: 1, STDOUT:).
Warning: domain "dating.pricelook24.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "dating.pricelook24.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "dating.pricelook24.de"
Broken referencial integrity: DNS zone id 12 is not found in dns_zone
Warning: hosting "dating.pricelook24.de"
Unable to backup Site Builder publishing status on site dating.pricelook24.de (ErrorCode: 1, STDOUT:).
Warning: domain "frame.pricelook24.de"
backup_restore_helper utility returned incorrect result. Extension with ID 7 cannot be backuped. Please, contact your service provider
Warning: domain "frame.pricelook24.de"
DNS Service on domain is skipped from backup due to error: 'undef' value passed to XmlNode::setAttribute for 'type' at /opt/psa/PMM/agents/shared/XmlNode.pm line 110.
Warning: domain "frame.pricelook24.de"
Broken referencial integrity: DNS zone id 13 is not found in dns_zone
Warning: hosting "frame.pricelook24.de"
Unable to backup Site Builder publishing status on site frame.pricelook24.de (ErrorCode: 1, STDOUT:).
 
Ok i have done it


Code: 
root@pl ~ # systemctl -l status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: active (running) since Fri 2017-02-24 17:27:41 CET; 10min ago
  Process: 23096 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 23125 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysql.service
           ├─23150 /bin/bash /usr/bin/mysqld_safe
           ├─23300 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --open-files-limit=1024000 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
           └─23301 logger -t mysqld -p daemon.error

Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] InnoDB: Highest supported file format is Barracuda.
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] InnoDB: 128 rollback segment(s) are active.
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] InnoDB: Waiting for purge to start
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 226670763
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] Plugin 'FEEDBACK' is disabled.
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] Server socket created on IP: '127.0.0.1'.
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: 170224 17:27:41 [Note] /usr/sbin/mysqld: ready for connections.
Feb 24 17:27:41 pl.pricelook24.de mysqld[23301]: Version: '10.0.29-MariaDB-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Feb 24 17:27:41 pl.pricelook24.de mysql[23125]: Starting MariaDB database server: mysqld.
Feb 24 17:27:41 pl.pricelook24.de systemd[1]: Started LSB: Start and stop the mysql database server daemon.
root@pl ~ #

Is here all OK? Becaue in ssh it is red. And red is not good.
 
Got the same problem :
ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_1a59_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `sessions`

With this in log :
Code: 
[2017-05-17 15:43:17] ERR [1] DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_1a59_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `locales`
[2017-05-17 15:43:17] ERR [panel] DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_1a59_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `locales`:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:53
        Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `locales`')
1: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:171
        Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'locales', NULL null)
2: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:836
        Zend_Db_Table_Abstract->_setupMetadata()
3: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:875
        Zend_Db_Table_Abstract->_setupPrimaryKey()
4: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:1290
        Zend_Db_Table_Abstract->find(string 'en-US')
5: /opt/psa/admin/plib/Db/Table/Abstract.php:97
        Db_Table_Abstract->findOne(string 'en-US')
6: /opt/psa/admin/plib/Locale/Manager.php:192
        Locale_Manager->_getCodes(boolean false, boolean true)
7: /opt/psa/admin/plib/Locale/Manager.php:127
        Locale_Manager->_exists(string 'en-US', boolean true)
8: /opt/psa/admin/plib/Locale/Manager.php:150
        Locale_Manager->isAllowed(string 'en-US')
9: /opt/psa/admin/plib/Session/Ctx/Panel.php:69
        Plesk\Session\Ctx_Panel->_getDefault(string 'locale')
10: /opt/psa/admin/plib/Session/Ctx/Namespace.php:21
        Plesk\Session\Ctx_Namespace->__get(string 'locale')
11: /opt/psa/admin/plib/CommonPanel/Translate.php:102
        CommonPanel_Translate->_init()
12: /opt/psa/admin/plib/CommonPanel/Translate.php:83
        CommonPanel_Translate->__construct(string '')
13: /opt/psa/admin/plib/CommonPanel/Translate.php:325
        CommonPanel_Translate::getTranslate()
14: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:123
        CommonPanel_Application_Abstract->_initTranslate()
15: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:39
        CommonPanel_Application_Abstract->run()
16: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:18
        CommonPanel_Application_Abstract::init()
17: /opt/psa/admin/plib/api-common/AbstractCu.php:1675
        AbstractCu::initCLI()
18: /opt/psa/admin/plib/scripts/interface_async_executor.php:5

In my case these commands solved problem but it came back later :
/etc/init.d/psa stopall
/etc/init.d/psa startall

So i tried KB : https://support.plesk.com/hc/en-us/...ted-with-warning-errno-24-Too-many-open-files
I keep you in touch.
 
You must log in or register to reply here.

Similar threads

bonar
Resolved General error: 1 Can't create/write to file '/var/tmp/#sql_677_0.MAI' (Errcode: 28), query was: DESCRIBE `sessions`I’m
Replies
4
Views
2K
bonar
bonar
W
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
1K
Peter Debik
P
T
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
984
Peter Debik
P
Space Monkey
Issue Help!! Server Error500 Plesk\Exception\Database
Replies
8
Views
1K
Peter Debik
P
A
Issue Remote Backup Failure
Replies
5
Views
370
Peter Debik
P
Back
Top