• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:
    https://pt-research.typeform.com/to/AmZvSXkx
  • 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.

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
3K
bonar
bonar
S
Issue Server Error - 500 Plesk\Exception\Database
Replies
12
Views
1K
The 8th
The 8th
W
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
2K
Peter Debik
P
T
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
1K
Peter Debik
P
Space Monkey
Issue Help!! Server Error500 Plesk\Exception\Database
Replies
8
Views
2K
Peter Debik
P
Back
Top