XF 1.5 Lock wait timeout exceeded; try restarting transaction

Nirjonadda

Well-known member
Why I am getting this error? Please let me know this fix.

Code:
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: Nirjon, 13 minutes ago
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/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
#3 /home/nadda/public_html/library/XenForo/DataWriter.php(1839): Zend_Db_Adapter_Abstract->delete('xf_user', '(user_id = 605)')
#4 /home/nadda/public_html/library/Bookmarks/XenForo/DataWriter/User.php(31): XenForo_DataWriter->_delete()
#5 /home/nadda/public_html/library/XenForo/DataWriter.php(1792): Bookmarks_XenForo_DataWriter_User->_delete()
#6 /home/nadda/public_html/library/Bookmarks/XenForo/DataWriter/User.php(36): XenForo_DataWriter->delete()
#7 /home/nadda/public_html/library/XenForo/Controller.php(1021): Bookmarks_XenForo_DataWriter_User->delete()
#8 /home/nadda/public_html/library/XenForo/ControllerAdmin/User.php(613): XenForo_Controller->_deleteData('XenForo_DataWri...', 'user_id', 'admin.php?users...')
#9 /home/nadda/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_User->actionDelete()
#10 /home/nadda/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/nadda/public_html/admin.php(13): XenForo_FrontController->run()
#12 {main}

Request State

array(3) {
  ["url"] => string(64) "https://www.mysite.com/admin.php?users/nbwberksdf.605/delete"
  ["_GET"] => array(1) {
    ["users/nbwberksdf_605/delete"] => string(0) ""
  }
  ["_POST"] => array(2) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 

Nirjonadda

Well-known member
Still I am getting server error log.

Code:
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: Unknown Account, 31 minutes ago
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/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
#3 /home/nadda/public_html/library/XenForo/Model/Session.php(444): Zend_Db_Adapter_Abstract->update('xf_user', Array, '(user_id = 1)')
#4 /home/nadda/public_html/library/XenForo/CronEntry/CleanUp.php(32): XenForo_Model_Session->updateUserLastActivityFromSessions()
#5 /home/nadda/public_html/library/XenForo/Model/Cron.php(356): XenForo_CronEntry_CleanUp::runHourlyCleanUp(Array)
#6 /home/nadda/public_html/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /home/nadda/public_html/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 99.999998092651, '')
#8 /home/nadda/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 99.999998092651, '', false)
#9 /home/nadda/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 100, '', false)
#10 /home/nadda/public_html/deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}

Request State

array(3) {
  ["url"] => string(39) "https://www.mysite.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(16) "/threads/166947/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
Top