• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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

C
Question Server Error 500 Plesk\Exception\Database
Replies
1
Views
545
Raul A.
R
F
Issue Server Error 500 Plesk\Exception\Database
Replies
3
Views
415
scsa20
scsa20
W
Resolved Login problem
Replies
2
Views
571
Willi
W
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 DB query failed: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: NO)
Replies
1
Views
1K
Kaspar@Plesk
Kaspar@Plesk
Back
Top