XF 2.3 DeadlockException

[steven s]

I've seen several threads similar and still don't understand. All I can tell is that it has something to do with searches.
Do I need XenForo Enhanced Search?


Server error log

• XF\Db\DeadlockException: Job XF\Job\SearchIndex: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction
• src/XF/Db/AbstractStatement.php:230
• Generated by: Unknown account
• Dec 9, 2024 at 1:07 PM

Stack trace​

INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, item_date, user_id, discussion_id) VALUES ('thread',22526,'Who\'d want more?!!','http://forums.bimmerforums.com/forum/showthread.php?t=1021935\n\nPCH/Beach/Ruby\'s/Driving:wink:\n\n Anyone interested in a drive this Saturday June 21st to PCH from Walnut.Alhambra?? Ti\'s MUST be here.lol.\nHopefully you fellas can make it. Sounds like this is going to be a blast and A LOT of bimmers are showing faces here. \n\n(Hopefully you can get a hold of this webpage)','_md_user_5604 _md_content_thread _md_node_60 _md_thread_22526 _md_thread_type_discussion _md_prefix_66',1213958893,5604,22526),
('post',180470,'','sorry i have to work ','_md_user_4845 _md_content_post _md_node_60 _md_thread_22526 _md_prefix_66',1213979477,4845,22526),
('post',180474,'','shoot. i have to work as well. im not having my normal saturdays off anymore. :frown:\nshare some pictures after the meet.','_md_user_4475 _md_content_post _md_node_60 _md_thread_22526 _md_prefix_66',1213979985,4475,22526),
('post',180557,'','I\'ll do my best for pics; but I think i\'ll be having to much fun beating the coupes!... heh heh heh. :wink:If anyone changes their mind drop me a line.','_md_user_5604 _md_content_post _md_node_60 _md_thread_22526 _md_prefix_66',1214017685,5604,22526),
('thread',22882,'OBD Scanners??','I went to the parts house(autozone) today to get a few parts and clear an O2 code on my Ranger(i didnt connect the sensors after installing a trans). I have borrowed scanners from this particular store many times but today they said no. According to the parts guy \'Beginning this week, due to Cali legislation OBD scanners can no longer be lent out by parts stores.\' He said i can either buy one or take it to a dealer! F that! Has anyone else heard about this or is he crazy??','_md_user_6169 _md_content_thread _md_node_60 _md_thread_22882 _md_thread_type_discussion _md_prefix_66',1216175278,6169,22882),
('post',184719,'','First time I hear of this and try another Autozone to see if they tell you the same thing.','_md_user_3781 _md_content_post _md_node_60 _md_thread_22882 _md_prefix_66',1216182705,3781,22882),
('post',184724,'','I\'ve never heard of that either... Sounds like they just want to sell you something... I agree, try another location...','_md_user_4609 _md_content_post _md_node_60 _md_thread_22882 _md_prefix_66',1216183186,4609,22882),
('post',184729,'','I just goggled this and nothing came back, maybe Autozone\'s policy changed but not the law!!','_md_user_3781 _md_content_post _md_node_60 _md_thread_22882 _md_prefix_66',1216185028,3781,22882),
('post',184773,'','If you\'ve got a laptop, it might be worth investing in a USB interface (that is of course if you intend to break down and buy one). It\'s much more flexible than a code reader and costs about the same.','_md_user_1292 _md_content_post _md_node_60 _md_thread_22882 _md_prefix_66',1216217990,1292,22882),
('post',185299,'','I heard the same thing yesterday. Like you I\'ve rented or borrowed scanners many times from Autozone. I\'m sure middle management saw the number of scanners being checked out and believed each rental could be turned into a sale and therefore changed the policy. \nI broke down and brought a scanner, hell I should have a long time ago.','_md_user_4845 _md_content_post _md_node_60 _md_thread_22882 _md_prefix_66',1216481505,4845,22882),
('post',186035,'','

I heard the same thing yesterday.

\n\n+1 tried to borrow a scanner in Erie - said ok, but didn\'t have any available. tried to do so in Pittsburgh - told we don\'t do that.','_md_user_3718 _md_content_post _md_node_60 _md_thread_22882 _md_prefix_66',1216856352,3718,22882) ON DUPLICATE KEY UPDATE title = VALUES(title), message = VALUES(message), metadata = VALUES(metadata), item_date = VALUES(item_date), user_id = VALUES(user_id), discussion_id = VALUES(discussion_id)
------------

#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/XF/Db/AbstractAdapter.php(273): XF\Db\AbstractAdapter->query('INSERT INTO `x...')
#4 src/XF/Search/Source/MySqlFt.php(132): XF\Db\AbstractAdapter->insertBulk('xf_search_index', Array, false, 'title = VALUES(...')
#5 src/XF/Search/Source/AbstractSource.php(102): XF\Search\Source\MySqlFt->flushBulkIndexing()
#6 src/XF/Search/Search.php(139): XF\Search\Source\AbstractSource->disableBulkIndexing()
#7 src/XF/Search/Search.php(92): XF\Search\Search->disableBulkIndexing()
#8 src/XF/Search/Search.php(107): XF\Search\Search->indexEntities('post', Object(XF\Mvc\Entity\ArrayCollection))
#9 src/XF/Job/SearchIndex.php(45): XF\Search\Search->indexByIds('post', Array)
#10 src/XF/Job/Manager.php(275): XF\Job\SearchIndex->run(7.27422)
#11 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 7.27422)
#12 src/XF/Job/Manager.php(89): XF\Job\Manager->runJobEntry(Array, 7.27422)
#13 job.php(46): XF\Job\Manager->runQueue(false, 8)
#14 {main}

Request state​

array(4) {
["url"] => string(14) "/forum/job.php"
["referrer"] => string(37) "https://www.318ti.org/forum/index.php"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
Delete