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

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error

Discussion in 'Server Configuration and Hosting' started by Nikita Sikka, Apr 20, 2015.

  1. Nikita Sikka

    Nikita Sikka New Member

    Hi,

    I am getting server errors of below exception

    "Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php"

    Stack trace:
    #0 /var/www/html/xenforo/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/html/xenforo/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/html/xenforo/library/XenForo/DataWriter/Alert.php(99): Zend_Db_Adapter_Abstract->query('????UPDATE xf_u...', 1549)
    #3 /var/www/html/xenforo/library/XenForo/DataWriter.php(1409): XenForo_DataWriter_Alert->_postSave()
    #4 /var/www/html/xenforo/library/XenForo/Model/Alert.php(452): XenForo_DataWriter->save()
    #5 /var/www/html/xenforo/library/XenForo/Model/Alert.php(426): XenForo_Model_Alert->alertUser(1549, 40314, 'ITSMETHE', 'post', 110638, 'insert', NULL)
    #6 /var/www/html/xenforo/library/XenForo/Model/ForumWatch.php(322): XenForo_Model_Alert::alert(1549, 40314, 'ITSMETHE', 'post', 110638, 'insert')
    #7 /var/www/html/xenforo/library/XenForo/DataWriter/DiscussionMessage/Post.php(176): XenForo_Model_ForumWatch->sendNotificationToWatchUsersOnMessage(Array, NULL, Array, Array)
    #8 /var/www/html/xenforo/library/XenForo/DataWriter.php(1423): XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #9 /var/www/html/xenforo/library/XenForo/DataWriter/Discussion.php(477): XenForo_DataWriter->save()
    #10 /var/www/html/xenforo/library/XenForo/DataWriter/Discussion.php(426): XenForo_DataWriter_Discussion->_saveFirstMessageDw()
    #11 /var/www/html/xenforo/library/XenForo/DataWriter.php(1409): XenForo_DataWriter_Discussion->_postSave()
    #12 /var/www/html/xenforo/library/XenForo/ControllerPublic/Forum.php(745): XenForo_DataWriter->save()
    #13 /var/www/html/xenforo/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Forum->actionAddThread()
    #14 /var/www/html/xenforo/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #15 /var/www/html/xenforo/index.php(13): XenForo_FrontController->run()
    #16 {main}

    Could anyone please look into this and let me know how to fix this.

    Thanks,
    Nikita
     

Share This Page