XF 1.5 An exception occurred: Mysqli statement execute error : Can't create/write to file

[polle]

I am getting this sometimes when hitting the new posts button.

------------------------------------------------------------------------------------------------------------------------------------------------------

An exception occurred: Mysqli statement execute error : Can't create/write to file '/tmp/#sql_d9e_0.MYI' (Errcode: 28) in /home/site/public_html/forum/library/Zend/Db/Statement/Mysqli.php on line 214

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/User.php at line 327
XenForo_Model_User->getUsers() in WidgetFramework/WidgetRenderer/Birthday.php at line 134
WidgetFramework_WidgetRenderer_Birthday->_render() in WidgetFramework/WidgetRenderer.php at line 683
WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 397
WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 316
WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 126
WidgetFramework_Listener::template_post_render()
call_user_func_array() in XenForo/CodeEvent.php at line 58
XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/Template/Abstract.php at line 528
XenForo_Template_Abstract->__toString() in XenForo/Template/Abstract.php(265) : eval()'d code at line 25
eval() in XenForo/Template/Abstract.php at line 265
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 637
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home/site/public_html/forum/index.php at line 13



An exception occurred: Mysqli statement execute error : Can't create/write to file '/tmp/#sql_d9e_0.MYI' (Errcode: 28) in /home/site/public_html/forum/library/Zend/Db/Statement/Mysqli.php on line 214

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/User.php at line 327
XenForo_Model_User->getUsers() in WidgetFramework/WidgetRenderer/Birthday.php at line 134
WidgetFramework_WidgetRenderer_Birthday->_render() in WidgetFramework/WidgetRenderer.php at line 683
WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 397
WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 316
WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 126
WidgetFramework_Listener::template_post_render()
call_user_func_array() in XenForo/CodeEvent.php at line 58
XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 637
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home/site/public_html/forum/index.php at line 13

------------------------------------------------------------------------------------------------------------------------------------------------------

Of course this was not happening before and everything was working fine. If I hit refresh, everything works fine again. But it happens sometimes.

Why and how to fix it ?

Thanks.

 

[Paul B]

Error code 28 is a full disk or no space left in the partition.

You may need to free up some space on the disk/partition.

 

[polle]

I have this for total:

Storage
Total: 98304 MB
Used: 24576 MB
Free: 73728 MB

So maybe its something else ?

For that account I am using 3,254.24 MB and it has 10000MB assigned.

I need more than 7GB of space free for that single domain so Xenforo works ?

Thanks.

 

[polle]

It was actually a space problem as you said.

For some reason the partition had 24576 MB assigned as total, causing the disk to get full. I just resized it to double that, hopefully everything will be fine.

Thank you again.