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

Server issue Error when trying to merge users

ineedhelp

Well-known member
#1
Code:
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/xxxxxxxxx.com/httpdocs/admin.php at line 13
Any ideas what's going on?
 

Jeremy

Well-known member
#2
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:
http://xenforo.com/community/threads/mysql-deadlock.60778/
http://xenforo.com/community/threads/deadlock.60097/
http://xenforo.com/community/thread...to-get-lock-try-restarting-transaction.47820/
http://xenforo.com/community/threads/vb-3-8-xf-via-cli-importer-discrepancies.27794/#post-327157
Deadlocks are an internal mySQL condition.