Can't create a new thread (errno 11)

[Bill.D]

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

$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

Thanks,
-Bill

 

[Jake Bunce]

Server problem. I found this with a Google search:

http://www.jigsawboys.com/2006/04/13/mysql-error-1135-cant-create-a-new-thread-errno-11/

 

[ProCom]

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

 

[Clovis]

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.

 

[TPerry]

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.