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

XF 1.5 Lock wait timeout exceeded; try restarting transaction

Discussion in 'XenForo Questions and Support' started by Dadparvar, Mar 15, 2016.

  1. Dadparvar

    Dadparvar 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.
  2. Mike

    Mike XenForo Developer Staff Member

    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).
    Xon and Dadparvar like this.

Share This Page