Server issue Error when trying to merge users


Well-known member
Server Error

Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XenForo/Model/User.php at line 2698
XenForo_Model_User->changeContentUser() in XenForo/Model/User.php at line 2764
XenForo_Model_User->mergeUsers() in XenForo/ControllerAdmin/User.php at line 637
XenForo_ControllerAdmin_User->actionMerge() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/vhosts/ at line 13
Any ideas what's going on?


Well-known member
P: I have seen a "Deadlock found when trying to get a lock" MySQL error in my error logs.
S: Reload the page to restart whatever process you were attempting. Deadlocks can occur with any transaction or query in an InnoDB MySQL database. They are very difficult to programmatically prevent and shouldn't occur often. If they occur fairly often, it is recommended that you discuss possible solutions with your host. Here is some further reading related to deadlocks:
Deadlocks are an internal mySQL condition.