Issue: Deadlock found when trying to get lock; try restarting transaction src/XF/Db/AbstractStatement.php:230

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

Generated by: Unknown account Sep 16, 2025 at 5:00 AM

Stack trace

DELETE FROM `xf_vw_accelerate` WHERE entry_type = 'file' AND `entry_name` IN ('Restless Legs Syndrome/src/addons/vw/vw/_core/controller/fetch/stack/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/index/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/index/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/index/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/page/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/page/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/node/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/base/routable/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/base/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/ui/tab/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/ui/tab/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/ui/tab/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/css/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/css/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/page/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/page/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/page/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/reply/redirect/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/reply/redirect/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/reply/redirect/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/ui/page/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/ui/page/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/ui/page/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/nav/paging/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/nav/paging/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/nav/paging/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/response/html/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/response/html/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/response/html/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/base/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/instance/stack/block/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/instance/stack/block/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/instance/stack/block/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/customfield/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/customfield/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/contenttype/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/contenttype/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/sidebar/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/sidebar/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/sidebar/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/tagging/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/tagging/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/tagging/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/proxy/tagging/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/proxy/tagging/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/proxy/tagging/page/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/proxy/tagging/page/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/proxy/tagging/base/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/microdata/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/microdata/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/fetch/language/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/fetch/language/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/fetch/language/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/language/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/language/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/language/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/controller/dm/language/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/stack/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/stack/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/stack/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/tab/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/tab/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/rating/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/rating/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/rating/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/tab/page/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/tab/page/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/tab/page/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/title/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/title/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/title/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/area/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/area/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/index/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/index/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/ui/index/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/nav/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/nav/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/instance/string/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/instance/string/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/instance/string/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/microdata/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/microdata/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/microdata/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_helper/schemaorg/DataType/Article.php','Restless Legs Syndrome/src/addons/vw/vw/_helper/schemaorg/DataType/CreativeWork.php','Restless Legs Syndrome/src/addons/vw/vw/_helper/schemaorg/DataType/Thing.php','Restless Legs Syndrome/src/addons/vw/vw/_helper/schemaorg/DataType.php','Restless Legs Syndrome/src/addons/vw/vw/_helper/schemaorg/Basic.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/block/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/block/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/block/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/block/search/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/block/search/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/model/block/search/vw.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/block/search/xf2.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/block/search/xf0.php','Restless Legs Syndrome/src/addons/vw/vw/_core/view/factory/block/search/vw.php') LIMIT 100
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/vw/vw/_core/controller/db/xf2.php(118): XF\Db\AbstractAdapter->query('DELETE FROM `xf...')
#4 src/addons/vw/vw/_core/model/db/mysql/vw.php(1521): vw_DB_Controller_XF2->query_write('DELETE FROM `xf...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(371): vw_DB_MySQL_Model->shutdown_or_run('DELETE FROM `xf...', false)
#6 src/addons/vw/vw/_core/model/cron/cleanup/vw.php(390): vw_DB_MySQL_Model->delete(Array)
#7 src/addons/vw/vw/_core/model/cron/deferred/cleanup/vw.php(61): vw_Cron_Cleanup_Model->clean_classcache(1757995221)
#8 src/addons/vw/vw/_core/model/cron/deferred/vw.php(66): vw_Cron_Deferred_Cleanup_Model->run(Array)
#9 src/addons/vw/vw/Handler/Job/Defer.php(41): vw_Cron_Deferred_Model->exec()
#10 src/XF/Job/Manager.php(275): vw\vw\Handler\Job\Defer->run(7.77986)
#11 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 7.77986)
#12 src/XF/Job/Manager.php(89): XF\Job\Manager->runJobEntry(Array, 7.77986)
#13 job.php(46): XF\Job\Manager->runQueue(false, 8)
#14 {main}

Request state

array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(38) "https://forum.com/reports/20466/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

VW4.1.19
XF2.3.7
PHP8.3