Mysqli errors while doing various things.

Slavik

XenForo moderator
Staff member
Had someone inform me it was when they tried to post and another while trying to reply to a conversation, all turned up this morning.

PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 27 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
#7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(81) "[URL]http://www.koi-forums.com/index.php?conversations/your-company-sub-forum.4/unread[/URL]"
  ["_GET"] => array(1) {
    ["conversations/your-company-sub-forum_4/unread"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}

PHP:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 26 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
#7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(37) "[URL]http://www.koi-forums.com/favicon.ico[/URL]"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 23 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
#7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(35) "[URL]http://www.koi-forums.com/index.php[/URL]"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}


PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 22 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
#7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(35) "[URL]http://www.koi-forums.com/index.php[/URL]"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}


PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 20 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
#7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(35) "[URL]http://www.koi-forums.com/index.php[/URL]"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
Kier has had this happen a couple times locally, and we had one other report of it. As far as I can tell, it seems like a MySQL bug as the documented circumstances for it really should never happen. (Each error is coming from the same query.) I'm not sure what to suggest, though it seems like it might be ok now as I can load your site.

Do you know your MySQL version, BTW?
 
Kier has had this happen a couple times locally, and we had one other report of it. As far as I can tell, it seems like a MySQL bug as the documented circumstances for it really should never happen. (Each error is coming from the same query.) I'm not sure what to suggest, though it seems like it might be ok now as I can load your site.

Do you know your MySQL version, BTW?

5.1.49
 
Error Showed up this morning also. My other vbulletin run forums seemed fine, but these ones were totally offline for 5 mins or so.

PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 6 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
#7 /var/www/vhosts/koi-forums.com/httpdocs/admin.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
["url"] => string(50) "http://www.koi-forums.com/admin.php?nodes/&last=34"
["_GET"] => array(2) {
["nodes/"] => string(0) ""    ["last"] => string(2) "34"
}
["_POST"] => array(0) {
}
}

PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 12 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(725): Zend_Db_Adapter_Abstract->query('????SELECT node...', 25)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/Forum.php(29): Zend_Db_Adapter_Abstract->fetchRow('????SELECT node...', 25)
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerHelper/ForumThreadPost.php(175): XenForo_Model_Forum->getForumById(25, Array)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerHelper/ForumThreadPost.php(38): XenForo_ControllerHelper_ForumThreadPost->getForumOrError(25, Array)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerPublic/Forum.php(31): XenForo_ControllerHelper_ForumThreadPost->assertForumValidAndViewable(25, Array)
#7 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(303): XenForo_ControllerPublic_Forum->actionIndex()
#8 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #9 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(59) "http://www.koi-forums.com/index.php?forums/cdh-software.25/"
["_GET"] => array(1) {
["forums/cdh-software_25/"] => string(0) ""
}
["_POST"] => array(0) {
}
 }

PHP:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 16 minutes ago
Stack Trace
#0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model.php(218): Zend_Db_Adapter_Abstract->query('?????SELECT *??...', Array, 2)
#3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/Node.php(178): XenForo_Model->fetchAllKeyed('?????SELECT *??...', 'node_id')
#4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/Node.php(715): XenForo_Model_Node->getAllNodes(false, true)
#5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerPublic/Index.php(28): XenForo_Model_Node->getNodeDataForListDisplay(false, 0)
#6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(303): XenForo_ControllerPublic_Index->actionIndex()
#7 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(35) [URL]http://www.koi-forums.com/index.php[/URL]
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

Each error shows up twice, but thats all I have, theres no server side generated error logs to correspond to these ones generated by Xenforo. Any suggestions?
 
Is it happening at a standard time of the day? If so, it sounds like there's something going on with your server at that point -- perhaps backups? Unfortunately, there's not a lot we can do to prevent it. It's being triggered by MySQL, and it can come from any query.
 
Is it happening at a standard time of the day? If so, it sounds like there's something going on with your server at that point -- perhaps backups? Unfortunately, there's not a lot we can do to prevent it. It's being triggered by MySQL, and it can come from any query.

Updating this.

My cron tasks have myseriously moved 5 hours into the day, this was causing the errors. Now resolved.
 
Top Bottom