XF 1.3 Msql Error

[Lexy]

What is this??

Mysqli prepare error: Out of resources when opening file './adminzon_xen/xf_session.MYD' (Errcode: 24)

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
5. Zend_Db_Adapter_Abstract->insert() in XenForo/Session.php at line 784
6. XenForo_Session->saveSessionToSource() in XenForo/Session.php at line 518
7. XenForo_Session->save() in XenForo/Controller.php at line 412
8. XenForo_Controller->updateSession() in XenForo/Controller.php at line 356
9. XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 354
10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
11. XenForo_FrontController->run() in /home/adminzona/public_html/index.php at line 13

 

[Lexy]

#0 /home/adminzona/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/adminzona/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/adminzona/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/adminzona/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/adminzona/public_html/library/XenForo/Session.php(784): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
#5 /home/adminzona/public_html/library/XenForo/Session.php(518): XenForo_Session->saveSessionToSource('c3297af86d1a714...', false)
#6 /home/adminzona/public_html/library/XenForo/Controller.php(412): XenForo_Session->save()
#7 /home/adminzona/public_html/library/XenForo/Controller.php(356): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#8 /home/adminzona/public_html/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#9 /home/adminzona/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/adminzona/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(31) "http://adminzona.club/index.php"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Chris D]

This may be an issue with the MySQL setting open_files_limit.

Either way, it's a MySQL problem so you should contact your host or server expert for assistance.

 

[Lexy]

thanks got multiple errors in Xenforo ACP server log

 

[Lexy]

how to raise the open file limits??

 

[Chris D]

Speak to your host if you don't know.