XF 2.2 Batch Delete Users Issues

xlegends

Member
Hi,

Earlier today, I batch deleted 25k users. Then I mass mailed the remaining 10k users. After this, the forum became severely laggy. I disabled addons, forced use of native style. Delete php sessions files, restarted served. Until I gave up and restored the DB. I want to attempt again to prune these users. Any advice on what the issue is or what I need to do properly afterwards?

ErrorException: Template error: Method isCustomUnreadNode is not callable on the given object (XF\Entity\Node) src/XF/Template/Templater.php:994
Generated by: harleykc Aug 18, 2020 at 10:20 AM
====================
Stack trace
#0 [internal function]: XF\Template\Templater->handleTemplateError(512, 'Method isCustom...', '/home/admin/web...', 994, Array)
#1 src/XF/Template/Templater.php(994): trigger_error('Method isCustom...', 512)
#2 internal_data/code_cache/templates/l1/s2/public/node_list_forum.php(109): XF\Template\Templater->method(Object(XF\Entity\Node), 'isCustomUnreadN...', Array)
#3 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#4 internal_data/code_cache/templates/l1/s2/public/node_list_forum.php(49): XF\Template\Templater->callMacro('node_list_forum', 'forum', Array, Array)
#5 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#6 internal_data/code_cache/templates/l1/s2/public/forum_list.php(30): XF\Template\Templater->callMacro('node_list_forum', 'depth2', Array, Array)
#7 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#8 internal_data/code_cache/templates/l1/s2/public/forum_list.php(64): XF\Template\Templater->callMacro('forum_list', 'node_list_entry', Array, Array)
#9 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#10 internal_data/code_cache/templates/l1/s2/public/node_list_category.php(31): XF\Template\Templater->callMacro('forum_list', 'node_list', Array, Array)
#11 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#12 internal_data/code_cache/templates/l1/s2/public/forum_list.php(30): XF\Template\Templater->callMacro('node_list_categ...', 'depth1', Array, Array)
#13 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#14 internal_data/code_cache/templates/l1/s2/public/forum_list.php(64): XF\Template\Templater->callMacro('forum_list', 'node_list_entry', Array, Array)
#15 src/XF/Template/Templater.php(701): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#16 internal_data/code_cache/templates/l1/s2/public/forum_list.php(213): XF\Template\Templater->callMacro('forum_list', 'node_list', Array, Array)
#17 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array)
#18 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('forum_list', Array)
#19 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#20 src/XF/Mvc/Dispatcher.php(458): XF\Mvc\Renderer\Html->renderView('XF:Forum\\Listin...', 'public:forum_li...', Array)
#21 src/XF/Mvc/Dispatcher.php(440): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#22 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#23 src/XF/Mvc/Dispatcher.php(58): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#24 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#25 src/XF.php(391): XF\App->run()
#26 index.php(20): XF::runApp('XF\\Pub\\App')
#27 {main}
============================
array(4) {
["url"] => string(17) "/forums/index.php"
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}




and

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:228
Generated by: Unknown account Aug 18, 2020 at 11:16 AM
Stack trace
UPDATE IGNORE xf_reaction_content SET
reaction_user_id = 0
WHERE reaction_user_id = ?

------------

#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(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Service/User/ContentChange.php(255): XF\Db\AbstractAdapter->query('
UPDATE I...', 22298)
#4 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepReassignContent(16, G)
#5 src/XF/Service/User/ContentChange.php(198): XF\Service\User\ContentChange->runLoop(G)
#6 src/XF/Service/User/DeleteCleanUp.php(255): XF\Service\User\ContentChange->apply(G)
#7 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\DeleteCleanUp->stepChangeOwner(NULL, G)
#8 src/XF/Service/User/DeleteCleanUp.php(93): XF\Service\User\DeleteCleanUp->runLoop(G)
#9 src/XF/Job/UserDeleteCleanUp.php(32): XF\Service\User\DeleteCleanUp->cleanUp(G)
#10 src/XF/Job/Manager.php(253): XF\Job\UserDeleteCleanUp->run(G)
#11 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#12 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#13 job.php(42): XF\Job\Manager->runQueue(false, 8)
#14 {main}
Request state
array(4) {
["url"] => string(15) "/forums/job.php"
["referrer"] => string(43) "https://www.dsslegends.com/forums/index.php"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Top