XF 2.1 Dozens of Job XF:UserDeleteCleanUp: MySQL query errors Every Minute after User Deletes

[Movie Prop Sites]

We deleted quite a few zero-post users who haven't been to the site in over a year. Did this through the batch update tool and everything seemed to go smoothly, but now we are getting piles and piles of the type of error shown below. Is there a solution for this?

• XF\Db\Exception: Job XF:UserDeleteCleanUp: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
• src/XF/Db/AbstractStatement.php:217
• Generated by: Unknown account
• May 27, 2019 at 3:56 PM

Stack trace
UPDATE IGNORE xf_conversation_master SET
last_message_user_id = 0, last_message_username = 'TY76'
WHERE last_message_user_id = ?

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

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#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...', 125510)
#4 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepReassignContent(4, 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}

 

[sevenmix]

Im having same problem right now, do you found a solution @Movie Prop Sites ?

 

[Movie Prop Sites]

This seemed to simply resolve itself over time if I recall. We are no longer having this error.

 

[sevenmix]

Well ill wait, thanks