• 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

#1
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