XF 2.2 Server Crashing MySQL Query Error

[SatGuyScott]

Not sure what's going on but my server started crashing last night and has crashed 3 times today. I have not made any changes to the server or software / add ins. So I am at a loss of what's going on.

The errors show in Xenforo are as follows (there are lots of them. Anything I should be looking for? I tried repairing the database. I am the only thing on this server and am the only one with access to it.

Thank you!

Server error log
[LIST]
[*]XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
[*]src/XF/Db/AbstractStatement.php:230
[*]Generated by: Unknown account
[*]Dec 6, 2023 at 5:30 PM
[/LIST]
[HEADING=2]Stack trace[/HEADING]
UPDATE xf_thread SET view_count = view_count + ? where thread_id = ?
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/SV/RedisViewCounter/Repository/ContentView.php(108): XF\Db\AbstractAdapter->query('UPDATE xf_threa...', Array)
#4 src/addons/SV/ElasticSearchEssentials/SV/RedisViewCounter/Repository/ContentView.php(16): SV\RedisViewCounter\Repository\ContentView->logDatabaseUpdate('UPDATE xf_threa...', 'thread', 397307, 1)
#5 src/addons/SV/RedisViewCounter/Repository/ContentView.php(89): SV\ElasticSearchEssentials\SV\RedisViewCounter\Repository\ContentView->logDatabaseUpdate('UPDATE xf_threa...', 'thread', 397307, 1)
#6 src/addons/SV/RedisViewCounter/XF/Repository/Thread.php(24): SV\RedisViewCounter\Repository\ContentView->batchUpdateViews('thread', 'xf_thread', 'thread_id', 'view_count')
#7 src/addons/SV/ElasticSearchEssentials/XF/Repository/Thread.php(32): SV\RedisViewCounter\XF\Repository\Thread->batchUpdateThreadViews()
#8 src/XF/Cron/Views.php(13): SV\ElasticSearchEssentials\XF\Repository\Thread->batchUpdateThreadViews()
#9 src/XF/Job/Cron.php(37): XF\Cron\Views::runViewUpdate(Object(XF\Entity\CronEntry))
#10 src/XF/Job/Manager.php(260): XF\Job\Cron->run(8)
#11 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#12 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 8)
#13 job.php(43): XF\Job\Manager->runQueue(false, 8)
#14 {main}
[HEADING=2]Request state[/HEADING]
array(4) {
  ["url"] => string(12) "/xen/job.php"
  ["referrer"] => string(89) "https://www.satelliteguys.us/xen/threads/6-24-2015-12-47-uplink-report-37-changes.351335/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[SatGuyScott]

BTW te error messages are all different with the same 1205 error.

Here is another one...

[code[

• XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
• src/XF/Db/AbstractStatement.php:230
• Generated by: charlesrshell
• Dec 6, 2023 at 5:03 PM

Stack trace​

UPDATE xf_post SET reaction_score = ?, reactions = ?, reaction_users = ? WHERE post_id = 4856394
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_pos...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1526): XF\Db\AbstractAdapter->update('xf_post', Array, 'post_id = 485...')
#5 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Reaction/AbstractHandler.php(113): XF\Mvc\Entity\Entity->save()
#7 src/XF/Repository/Reaction.php(276): XF\Reaction\AbstractHandler->updateContentReactions(Object(SV\ThreadReplyBanTeeth\XF\Entity\Post), Array, Array)
#8 src/XF/Entity/ReactionContent.php(204): XF\Repository\Reaction->rebuildContentReactionCache('post', 4856394, false, false)
#9 src/XF/Entity/ReactionContent.php(142): XF\Entity\ReactionContent->rebuildContentReactionCache()
#10 src/XF/Mvc/Entity/Entity.php(1277): XF\Entity\ReactionContent->_postSave()
#11 src/XF/Repository/Reaction.php(191): XF\Mvc\Entity\Entity->save()
#12 src/XF/Repository/Reaction.php(144): XF\Repository\Reaction->insertReaction(1, 'post', 4856394, Object(SV\BookmarkEssentials\XF\Entity\User), true, false)
#13 src/XF/ControllerPlugin/Reaction.php(67): XF\Repository\Reaction->reactToContent(1, 'post', 4856394, Object(SV\BookmarkEssentials\XF\Entity\User), true)
#14 src/XF/ControllerPlugin/Reaction.php(21): XF\ControllerPlugin\Reaction->actionToggleReaction(Object(SV\ThreadReplyBanTeeth\XF\Entity\Post), 'posts/reactions', 'posts')
#15 src/XF/ControllerPlugin/Reaction.php(14): XF\ControllerPlugin\Reaction->actionReact(Object(SV\ThreadReplyBanTeeth\XF\Entity\Post), 'posts', 'posts/react', 'posts/reactions')
#16 src/XF/Pub/Controller/Post.php(381): XF\ControllerPlugin\Reaction->actionReactSimple(Object(SV\ThreadReplyBanTeeth\XF\Entity\Post), 'posts')
#17 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XFost', 'React', Object(XF\Mvc\RouteMatch), Object(NF\GiftUpgrades\XF\Pub\Controller\Post), NULL)
#19 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\GiftUpgrades\XF\Pub\Controller\Post), NULL)
#20 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#22 src/XF.php(524): XF\App->run()
#23 index.php(20): XF::runApp('XF\\Pub\\App')
#24 {main}

Request state​

array(4) {
["url"] => string(38) "/xen/posts/4856394/react?reaction_id=1"
["referrer"] => string(75) "https://www.satelliteguys.us/xen/threads/mesh-router-recommendation.407365/"
["_GET"] => array(1) {
["reaction_id"] => string(1) "1"
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(47) "/xen/threads/mesh-router-recommendation.407365/"
["_xfWithData"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

[/code]

 

[Alan_SP]

Are you managing your server, or someone else do it for you?

Anyway, when you google, you get this (among other things): https://bobcares.com/blog/mysql-error-1205-lock-wait-timeout/

 

[SatGuyScott]

I am managing it myself.

Anyways found the MySQL error log finally and found a few crashed tables, which I have repaired. Have been solid with no crashes ever since.

Fingers crossed that its fixed now.