XF 2.2 MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction

[alternadiv]

Does this mean I need to clear the MySQL jobs table?

XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Mar 17, 2022 at 1:17 PM
Stack trace
DELETE  FROM `xf_job` WHERE job_id = ?
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(291): XF\Db\AbstractAdapter->query('DELETE  FROM `x...', 72976)
#4 src/XF/Job/Manager.php(205): XF\Db\AbstractAdapter->delete('xf_job', 'job_id = ?', 72976)
#5 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 7.99554)
#6 job.php(43): XF\Job\Manager->runQueue(false, 8)
#7 {main}
Request state
array(4) {
  ["url"] => string(8) "/job.php"
  ["referrer"] => string(21) "https://tacoma3g.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Hareon]

I am having this problem today.

• XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction
• src/XF/Db/AbstractStatement.php:230

[CODE]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(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(78): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Job/Manager.php(521): XF\Db\AbstractAdapter->insert('xf_job', Array, false, '
execute_cla...')
#5 src/XF/Job/Manager.php(469): XF\Job\Manager->_enqueue('userBadgeUpdate...', 'OzzModz\\Badges:...', Array, false, 1717457736)
#6 src/addons/OzzModz/Badges/Repository/UserBadge.php(263): XF\Job\Manager->enqueueUnique('userBadgeUpdate...', 'OzzModz\\Badges:...', Array, false)
#7 src/addons/OzzModz/Badges/Listener.php(250): OzzModz\Badges\Repository\UserBadge->queueUserBadgeUpdateAndRunUpdateJob(Object(XFRM\XF\Entity\User))
#8 src/XF/Extension.php(81): OzzModz\Badges\Listener::appPubStartEnd(Object(XF\Pub\App))
#9 src/XF/App.php(2994): XF\Extension->fire('app_pub_start_e...', Array, NULL)
#10 src/XF/Pub/App.php(202): XF\App->fire('app_pub_start_e...', Array)
#11 src/XF/App.php(2483): XF\Pub\App->start(true)
#12 src/XF.php(524): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}[/CODE]

I dont know if this is a problem or if I can clear this log.