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

Alternadiv

Well-known member
Does this mean I need to clear the MySQL jobs table?


Code:
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) {
  }
}
 
Top Bottom