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

XF 1.5 Recurring Error

#1
Hello,

Over the last few days, I keep getting the same "Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction". I have put the full details in te spoiler below.

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: Dr doom, 12 minutes ago
Stack Trace
#0 /home/crimecoa/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/crimecoa/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/crimecoa/public_html/library/XenForo/DataWriter/DiscussionMessage.php(927): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tUPDATE xf_...', 501)
#3 /home/crimecoa/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(200): XenForo_DataWriter_DiscussionMessage->_updateUserMessageCount(false)
#4 /home/crimecoa/public_html/library/XenForo/DataWriter/DiscussionMessage.php(559): XenForo_DataWriter_DiscussionMessage_Post->_updateUserMessageCount()
#5 /home/crimecoa/public_html/library/XenForo/DataWriter.php(1423): XenForo_DataWriter_DiscussionMessage->_postSave()
#6 /home/crimecoa/public_html/library/XenForo/ControllerPublic/Thread.php(578): XenForo_DataWriter->save()
#7 /home/crimecoa/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Thread->actionAddReply()
#8 /home/crimecoa/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/crimecoa/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(68) "https://www.crimecoastforums.com/threads/card-selling.3820/add-reply"
["_GET"] => array(0) {
}
["_POST"] => array(9) {
["message_html"] => string(131) "<p>U aint the only one bro I was same a while back didnt know till I was tild but hay I had a massive bb boost once I sold them</p>"
["_xfRelativeResolver"] => string(59) "https://www.crimecoastforums.com/threads/card-selling.3820/"
["attachment_hash"] => string(32) "ecb2f1786b4620e63d7f3b1db79328d7"
["last_date"] => string(10) "1497271889"
["last_known_date"] => string(10) "1497271889"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(27) "/threads/card-selling.3820/"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"

What is this error, how can I prevent it and is it anything to be concerned about?

Regards,
Carl
 

Mike

XenForo developer
Staff member
#3
It's generally indicative of server performance issues, though it could also indicate that there's some process that is taking an extremely long time. You would likely need to catch it while it's happening to look at the processes active in MySQL (and what transactions are open).

If it's happening at a consistent time of day, you may want to look at what crons are running in XF then (and only then). Alternatively, it may be something outside of XF such as a backup process.