XF 1.5 Lock wait timeout exceeded; try restarting transaction


Well-known member

Today I see I can't delete any profile post. And when I want to do it, it waits a lot and then this error comes:
Server Error

Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
Zend_Db_Adapter_Abstract->delete() in XenForo/DataWriter.php at line 1839
XenForo_DataWriter->_delete() in XenForo/DataWriter.php at line 1792
XenForo_DataWriter->delete() in XenForo/ControllerPublic/ProfilePost.php at line 170
XenForo_ControllerPublic_ProfilePost->actionDelete() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/xenforo/domains/my.site.com/public_html/index.php at line 13

Any opinion will be appreciated.
This would normally indicate something else is going on in the background that is also taking a very long time. This could be something like a user rename or deletion, for example. The error should clear, though the you'd need to identify why the initial process has taken so long. With only guessing what it is, that's very difficult. It may simply be indicative of high load on the server (if you're on a shared server, this may not even be caused by you).
Top Bottom