• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Can't create a new thread (errno 11)

Bill.D

Active member
#1
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Bill, 2 minutes ago
Stack Trace
#0 /home/site/xxxxxxx.com/www/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/site/xxxxxxx.com/www/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/site/xxxxxxx.com/www/forums/library/XenForo/Model/Thread.php(1712): Zend_Db_Adapter_Abstract->query('????INSERT DELA...', 141)
#3 /home/site/xxxxxxx.com/www/forums/library/XenForo/ControllerPublic/Thread.php(151): XenForo_Model_Thread->logThreadView(141)
#4 /home/site/xxxxxxx.com/www/forums/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Thread->actionIndex()
#5 /home/site/xxxxxxx.com/www/forums/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#6 /home/site/xxxxxxx.com/www/forums/index.php(13): XenForo_FrontController->run()
#7 {main}
Request State
array(3) {
["url"] => string(73) "http://xxxxxxxx.com/forums/index.php?threads/forum-server-issues.141/"
["_GET"] => array(1) {
["threads/forum-server-issues_141/"] => string(0) ""
}
["_POST"] => array(0) {
}
Site is X'ed out.

As it stands you can see the list of forums, but when you click on it you just get the system saying there has been a server error and no threads appear.

So I checked the 2 servers that host the site.. Both have Gigs of space available.. I checked the MySQL DB Servers.. Also has gigs of space available.. I rebuilt all the Caches & Ran a File Health Check.. I ran a SQL Check on all of the Tables and they all came out fine.. I ran a repair on all tables in the MySQL DB for the forum. I also added
PHP:
$config['enableListeners'] = 0;
into the config file. I have also rebooted both web hosting servers as well as there Apache instances.

Now the weird part is for maybe five min after adding and removing the code above.. It worked.. So I tried adding it back but it did not reproduces the success..

Please Help :confused:

Thanks,
-Bill
 

ProCom

Well-known member
#3
I know this is an old thread, but I wanted to add some info that was helpful for me.
Short Version: Make sure you have plenty of disk space available!

Long Version:

I started getting these exact errors on all my xF sites. My host NOC was investigating the errors, but on a whim I decided to check my disk space usage on my VPS.

I noticed that we had 89G used on our server that has 90G available. I went ahead and deleted some large backup files and I made free 4G of space. Once that was done it seems that all these (and other random memory errors) I was getting all disappeared!

Sample errors:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Out of memory (Needed 33552396 bytes) - library/Zend/Db/Statement/Mysqli.php:214
Generated By: elevan, 22 minutes ago
Stack Trace
#0 /home/acct/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/acct/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/acct/public_html/library/Zend/Db/Adapter/Abstract.php(791): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array)
#3 /home/acct/public_html/library/XenForo/Model/Thread.php(735): Zend_Db_Adapter_Abstract->fetchCol('?????SELECT thr...', Array)
#4 /home/acct/public_html/library/XenForo/ControllerPublic/FindNew.php(136): XenForo_Model_Thread->getUnreadThreadIds(4758, Array, 0)
#5 /home/acct/public_html/library/XenForo/ControllerPublic/FindNew.php(24): XenForo_ControllerPublic_FindNew->findNewPosts()
#6 /home/acct/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_FindNew->actionPosts()
#7 /home/acct/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/acct/public_html/index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(43) "http://www.acctforums.com/find-new/posts"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
Delete... Close
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug - library/Zend/Db/Statement/Mysqli.php:214
Generated By: elevan, 27 minutes ago
Stack Trace
#0 /home/acct/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/acct/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/acct/public_html/library/XenForo/Search/SourceHandler/MySqlFt.php(110): Zend_Db_Adapter_Abstract->query('?????REPLACE DE...')
#3 /home/acct/public_html/library/XenForo/Search/SourceHandler/MySqlFt.php(82): XenForo_Search_SourceHandler_MySqlFt->_pushToIndex('('post', 3682, ...')
#4 /home/acct/public_html/library/XenForo/Search/Indexer.php(44): XenForo_Search_SourceHandler_MySqlFt->insertIntoIndex('post', 3682, '', '...', 1380476419, 4758, 2101, Array)
#5 /home/acct/public_html/library/XenForo/Search/DataHandler/Post.php(61): XenForo_Search_Indexer->insertIntoIndex('post', 3682, '', '[]...', 1380476419, 4758, 2101, Array)
#6 /home/acct/public_html/library/XenForo/Search/DataHandler/Abstract.php(238): XenForo_Search_DataHandler_Post->_insertIntoIndex(Object(XenForo_Search_Indexer), Array, Array)
#7 /home/acct/public_html/library/XenForo/DataWriter/DiscussionMessage.php(757): XenForo_Search_DataHandler_Abstract->insertIntoIndex(Object(XenForo_Search_Indexer), Array, Array)
#8 /home/acct/public_html/library/XenForo/DataWriter/DiscussionMessage.php(736): XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex()
#9 /home/acct/public_html/library/XenForo/DataWriter/DiscussionMessage.php(582): XenForo_DataWriter_DiscussionMessage->_indexForSearch()
#10 /home/acct/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_DiscussionMessage->_postSave()
#11 /home/acct/public_html/library/XenForo/ControllerPublic/Thread.php(548): XenForo_DataWriter->save()
#12 /home/acct/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_Thread->actionAddReply()
#13 /home/acct/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /home/acct/public_html/index.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
["url"] => string(91) "http://www.acctforums.com/threads/server-error-every-time-i-try-new-posts.2101/add-reply"
["_GET"] => array(0) {
}
["_POST"] => array(9) {
["message_html"] => string(292) "<p><font size="6"><b></b></font></p><p>[]<font size="6"><b>acctForums.com - Error</b></font></p><p><label>A server error occurred. Please try again later.</label>[/]</p><p><br></p><p>It's happening again. &nbsp;And it's happening in the BYH sandbox too.</p><p><label></label></p>"
["_xfRelativeResolver"] => string(82) "http://www.acctforums.com/threads/server-error-every-time-i-try-new-posts.2101/"
["attachment_hash"] => string(32) "c1b61989fe2d80f4359ef2e642887f44"
["last_date"] => string(10) "1380394709"
["last_known_date"] => string(10) "1380394709"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(54) "/threads/server-error-every-time-i-try-new-posts.2101/"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Mysqli statement execute error : Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
 
#4
I'm also getting this issue. My server has plenty of disk space and ram is running at a few mbs of 2gbs and cpu at 2-4%. Any suggestions or help?

I am unable to follow the tutorial from the link posted above as I do not have access to those files.

As a result of this, my forums have gone into lockdown. No threads can be read. :(
 
Last edited:

Tracy Perry

Well-known member
#5
I'm also getting this issue. My server has plenty of disk space and ram is running at a few mbs of 2gbs and cpu at 2-4%. Any suggestions or help?

I am unable to follow the tutorial from the link posted above as I do not have access to those files.

As a result of this, my forums have gone into lockdown. No threads can be read. :(
If you mean that you are on a shared host, then it's time to contact your hosting provider - tell them the error and provide the link to them.