Bug MySQL query error [1213]: Deadlock found when trying to get lock

Status
Not open for further replies.

Nirjonadda

Customer
Server error log.

Code:
XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction src/XF/Db/AbstractStatement.php:217

Generated by: Rosthedestroyer May 20, 2019 at 11:23 PM

Stack trace

UPDATE  `xf_user` SET `dbtech_shop_points` = ? WHERE `user_id` = 7861
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE  `xf_use...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1288): XF\Db\AbstractAdapter->update('xf_user', Array, '`user_id` = 786...')
#5 src/addons/DBTech/Shop/Repository/Currency.php(232): XF\Mvc\Entity\Entity->fastUpdate('dbtech_shop_poi...', G)
#6 src/addons/DBTech/Shop/XF/Entity/Post.php(57): DBTech\Shop\Repository\Currency->addCurrencyAmount(Object(DBTech\Shop\Entity\Currency), 'perreply', 1, Object(Datio\AllowedEmails\XF\Entity\User), 'post', 722058)
#7 src/addons/ThemeHouse/QAForums/XF/Entity/Post.php(167): DBTech\Shop\XF\Entity\Post->_postSave()
#8 src/addons/ThemeHouse/ReactPlus/XF/Entity/Post.php(25): ThemeHouse\QAForums\XF\Entity\Post->_postSave()
#9 src/addons/ThemeHouse/Notifier/XF/Entity/Post.php(9): ThemeHouse\ReactPlus\XF\Entity\Post->_postSave()
#10 src/XF/Mvc/Entity/Entity.php(1208): ThemeHouse\Notifier\XF\Entity\Post->_postSave()
#11 src/XF/Service/Thread/Replier.php(167): XF\Mvc\Entity\Entity->save(true, false)
#12 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\Thread\Replier->_save()
#13 src/XF/Pub/Controller/Thread.php(461): XF\Service\Thread\Replier->save()
#14 src/addons/Snog/ForceSecure/XF/Pub/Controller/Thread.php(17): XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#15 src/addons/xenMade/STFRT/XF/Pub/Controller/Thread.php(111): Snog\ForceSecure\XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#16 src/addons/KL/EditorManager/XF/Pub/Controller/Thread.php(23): xenMade\STFRT\XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(321): KL\EditorManager\XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Thread), NULL)
#19 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Thread), NULL)
#20 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#22 src/XF.php(390): XF\App->run()
#23 index.php(20): XF::runApp('XF\\Pub\\App')
#24 {main}

Request state

array(4) {
  ["url"] => string(60) "/threads/im-looking.60996/add-reply"
  ["referrer"] => string(73) "/threads/im-looking.60996/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(8) {
    ["message_html"] => string(42) "<p>Fgbbjkjhg uunggjjj yujjhghu uujhhbn</p>"
    ["last_date"] => string(10) "1558373010"
    ["last_known_date"] => string(10) "1558372795"
    ["klPage"] => string(0) ""
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(51) "/threads/im-looking.60996/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
    }
}
 
Hello @Nirjonadda,

We hope your ticket regarding DragonByte Shop has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.
 
Hello @Nirjonadda,

As we have not heard back from you, your ticket regarding DragonByte Shop has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.
 
Status
Not open for further replies.

DragonByte Shop

XenForo 1.5.3+ XenForo 2.0.x XenForo 2.1.x XenForo 2.2.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
3,174
Customer rating
5.00 star(s) 3 ratings
Back
Top