Mysqli statement execute error : Lock wait timeout exceeded

[Nirjonadda]

I am getting Server Error Logs on my Admin CP, Please let me know this fix.

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: নির্জনে পথিক, Thursday at 8:12 PM
Stack Trace

#0 /home/nadda/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nadda/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nadda/public_html/library/XenForo/DataWriter/DiscussionMessage.php(927): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tUPDATE xf_...', Array)
#3 /home/nadda/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(200): XenForo_DataWriter_DiscussionMessage->_updateUserMessageCount(false)
#4 /home/nadda/public_html/library/XenForo/DataWriter/DiscussionMessage.php(559): XenForo_DataWriter_DiscussionMessage_Post->_updateUserMessageCount()
#5 /home/nadda/public_html/library/XenForo/DataWriter.php(1423): XenForo_DataWriter_DiscussionMessage->_postSave()
#6 /home/nadda/public_html/library/XenForo/ControllerPublic/Thread.php(578): XenForo_DataWriter->save()
#7 /home/nadda/public_html/library/VfcodersHH/ControllerPublic/Thread.php(38): XenForo_ControllerPublic_Thread->actionAddReply()
#8 /home/nadda/public_html/library/XenForo/FrontController.php(351): VfcodersHH_ControllerPublic_Thread->actionAddReply()
#9 /home/nadda/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/nadda/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(51) "https://www.nirmoladda.com/threads/133648/add-reply"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(10) {
    ["message_html"] => string(100) "<p><br></p><p>[hide][center][img]https://picload.org/image/raacacaw/27.jpg[/img][/center][/hide]</p>"
    ["_xfRelativeResolver"] => string(42) "https://www.nirmoladda.com/threads/133648/"
    ["brphb_editor_option_forum_id"] => string(3) "113"
    ["attachment_hash"] => string(32) "807008ed7b8a652039ae77a7f9dd83f5"
    ["last_date"] => string(10) "1481206313"
    ["last_known_date"] => string(10) "1481206109"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(16) "/threads/133648/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Paul B]

See this post from Mike: https://xenforo.com/community/threads/server-error-lock-wait-timeout-exceeded.122863/#post-1111612