XF 2.1 MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction

[Nirjonadda]

Server error log from update reaction score.

XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:217

Generated by: Nargish Apr 9, 2019 at 7:23 PM

Stack trace

            UPDATE xf_user
            SET reaction_score = reaction_score + ?
            WHERE user_id = ?
        
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Entity/ReactionContent.php(192): XF\Db\AbstractAdapter->query('
            UPDATE xf_u...', Array)
#4 src/XF/Entity/ReactionContent.php(149): XF\Entity\ReactionContent->adjustUserReactionScore(298, -1)
#5 src/addons/DBTech/Credits/XF/Entity/ReactionContent.php(164): XF\Entity\ReactionContent->_postDelete()
#6 src/XF/Mvc/Entity/Entity.php(1580): DBTech\Credits\XF\Entity\ReactionContent->_postDelete()
#7 src/XF/Repository/Reaction.php(118): XF\Mvc\Entity\Entity->delete()
#8 src/addons/ThemeHouse/ReactPlus/XF/Repository/Reaction.php(20): XF\Repository\Reaction->reactToContent(1, 'post', 133886, Object(Datio\AllowedEmails\XF\Entity\User), true, false)
#9 src/XF/ControllerPlugin/Reaction.php(65): ThemeHouse\ReactPlus\XF\Repository\Reaction->reactToContent(1, 'post', 133886, Object(Datio\AllowedEmails\XF\Entity\User), true)
#10 src/addons/ThemeHouse/ReactPlus/XF/ControllerPlugin/Reaction.php(17): XF\ControllerPlugin\Reaction->actionToggleReaction(Object(SV\ChangePostDate\XF\Entity\Post), 'posts/reactions', 'posts')
#11 src/XF/ControllerPlugin/Reaction.php(19): ThemeHouse\ReactPlus\XF\ControllerPlugin\Reaction->actionToggleReaction(Object(SV\ChangePostDate\XF\Entity\Post), 'posts/reactions', 'posts')
#12 src/XF/ControllerPlugin/Reaction.php(12): XF\ControllerPlugin\Reaction->actionReact(Object(SV\ChangePostDate\XF\Entity\Post), 'posts', 'posts/react', 'posts/reactions')
#13 src/XF/Pub/Controller/Post.php(368): XF\ControllerPlugin\Reaction->actionReactSimple(Object(SV\ChangePostDate\XF\Entity\Post), 'posts')
#14 src/addons/KL/EditorManager/XF/Pub/Controller/Post.php(23): XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(321): KL\EditorManager\XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Post', 'React', Object(XF\Mvc\RouteMatch), Object(TickTackk\ContentCopyProtection\XF\Pub\Controller\Post), NULL)
#17 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(TickTackk\ContentCopyProtection\XF\Pub\Controller\Post), NULL)
#18 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#20 src/XF.php(390): XF\App->run()
#21 index.php(20): XF::runApp('XF\\Pub\\App')
#22 {main}

Request state

array(4) {
  ["url"] => string(33) "/posts/133886/react?reaction_id=1"
  ["referrer"] => string(61) "/threads/rocketman-augustus.8860/page-2"
  ["_GET"] => array(1) {
    ["reaction_id"] => string(1) "1"
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(39) "/threads/rocketman-augustus.8860/page-2"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Silmarillion]

Hi, everyone,
I have the same problem. Unfortunately there is still no suggested solution in the forum. I hope someone can help me, give me a crucial tip.

XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction

[LIST]
[*]XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
[*]src/XF/Db/AbstractStatement.php:228
[/LIST]
[LIST]
[*]Generiert von: Prof.Dr.Spock
[*]19 Dezember 2021 um 16:14
[/LIST]
Stack-Trace
           SELECT *
           FROM xf_thread
           WHERE thread_id = ?
           FOR UPDATE
    
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(145): XF\Db\AbstractAdapter->query('
           SELECT *
       ...', 61474)
#4 src/XF/Service/Thread/Replier.php(181): XF\Db\AbstractAdapter->fetchRow('
           SELECT *
       ...', 61474)
#5 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\Thread\Replier->_save()
#6 src/XF/Pub/Controller/Thread.php(603): XF\Service\Thread\Replier->save()
#7 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', Object(XF\Mvc\RouteMatch), Object(SV\WhoReplied\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\WhoReplied\XF\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2326): XF\Mvc\Dispatcher->run()
#12 src/XF.php(488): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}

Status der Anfrage
array(4) {
  ["url"] => string(82) "/threads/coronavirus-gefahr-fuer-asien-europa-weltweit-deutschland.61474/add-reply"
  ["referrer"] => string(105) "https://www.fanlager.de/threads/coronavirus-gefahr-fuer-asien-europa-weltweit-deutschland.61474/page-2237"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(10) {
   ["message_html"] => string(514) "<blockquote data-attributes="member: 15356" data-quote="fradiavolo" data-source="post: 3378996"><p>Hat er doch im Bezug auf Russlands Sieg über die westliche Welt lange genug trainieren und perfektionieren können <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2 fr-fic fr-dii" alt=";)" title="Wink&nbsp; &nbsp; ;)" data-shortname=";)"></p></blockquote><p>Russland, Corona, der Aktienmarkt, Beutelchen ist ein Tausendsassa.</p>"
   ["attachment_hash"] => string(32) "9416046ba4bfa7c8e18f7b8435ccda87"
   ["attachment_hash_combined"] => string(87) "{"type":"post","context":{"thread_id":61474},"hash":"9416046ba4bfa7c8e18f7b8435ccda87"}"
   ["last_date"] => string(10) "1639926656"
   ["last_known_date"] => string(10) "1639926656"
   ["load_extra"] => string(1) "1"
   ["_xfToken"] => string(8) "********"
   ["_xfRequestUri"] => string(82) "/threads/coronavirus-gefahr-fuer-asien-europa-weltweit-deutschland.61474/page-2237"
   ["_xfWithData"] => string(1) "1"
   ["_xfResponseType"] => string(4) "json"
  }
}

Best regards,
Silmarillion

 

[faker.king]

got any luck with this/?