Nirjonadda
Well-known member
- Affected version
- 2.0.4
Getting Server error log from deleting user.
Code:
[LIST]
[*]XF\Db\DeadlockException: Job XF:UserDeleteCleanUp: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction
[*]src/XF/Db/AbstractStatement.php:212
[*]Generated by: Unknown account
[*]Apr 11, 2018 at 11:51 PM
[/LIST]
Stack trace
INSERT INTO `xf_job` (`execute_class`, `execute_data`, `unique_key`, `manual_execute`, `trigger_date`) VALUES (?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE
execute_class = VALUES(execute_class),
execute_data = VALUES(execute_data),
manual_execute = VALUES(manual_execute),
trigger_date = VALUES(trigger_date),
last_run_date = NULL
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Job/Manager.php(467): XF\Db\AbstractAdapter->insert('xf_job', Array, false, '\n\t\t\texecute_cla...')
#5 src/XF/Job/Manager.php(414): XF\Job\Manager->_enqueue(NULL, 'XF:SearchUserCh...', Array, false, 1523469072)
#6 src/XF/Search/Source/AbstractSource.php(43): XF\Job\Manager->enqueue('XF:SearchUserCh...', Array)
#7 src/XF/Search/Search.php(132): XF\Search\Source\AbstractSource->reassignContent(375, 0)
#8 src/XF/Service/User/ContentChange.php(339): XF\Search\Search->reassignContent(375, 0)
#9 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepReassignSearchIndex(NULL, 4.0553438663483)
#10 src/XF/Service/User/ContentChange.php(194): XF\Service\User\ContentChange->runLoop(4.2258999347687)
#11 src/XF/Service/User/DeleteCleanUp.php(191): XF\Service\User\ContentChange->apply(4.2258999347687)
#12 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\DeleteCleanUp->stepChangeOwner(NULL, 4.2258999347687)
#13 src/XF/Service/User/DeleteCleanUp.php(92): XF\Service\User\DeleteCleanUp->runLoop(4.2557098865509)
#14 src/XF/Job/UserDeleteCleanUp.php(32): XF\Service\User\DeleteCleanUp->cleanUp(4.2557098865509)
#15 src/XF/Job/Manager.php(241): XF\Job\UserDeleteCleanUp->run(4.2557098865509)
#16 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 4.2557098865509)
#17 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 4.2557098865509)
#18 job.php(15): XF\Job\Manager->runQueue(false, 8)
#19 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(23) "/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
