Bug Error on the last version

Cheb

New Member
Joined
Aug 25, 2017
Messages
29
Hi,

I am getting that error :

  • XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
  • src/XF/Db/AbstractStatement.php:217
Code:
INSERT  INTO `xfa_wrtt_thread_read` (`thread_id`, `user_id`, `thread_read_date`) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
------------

#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(221): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XFA/WhoReadThisThread/XF/Repository/Thread.php(27): XF\Db\AbstractAdapter->insert('xfa_wrtt_thread...', Array, false, 'thread_read_dat...')
#5 src/addons/xenMade/LAU/XF/Repository/Thread.php(26): XFA\WhoReadThisThread\XF\Repository\Thread->markThreadReadByVisitor(Object(XFA\WhoReadThisThread\XF\Entity\Thread), 1556704761)
#6 src/XF/Pub/Controller/Thread.php(89): xenMade\LAU\XF\Repository\Thread->markThreadReadByVisitor(Object(XFA\WhoReadThisThread\XF\Entity\Thread), 1556704761)
#7 src/addons/ForoAgency/PrivateMessageReplies/XF/Pub/Controller/Thread.php(11): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#8 src/addons/XenConcept/HideBBCode/XF/Pub/Controller/Thread.php(21): ForoAgency\PrivateMessageReplies\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php(16): XenConcept\HideBBCode\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/addons/XenConcept/AdvancedPermissions/XF/Pub/Controller/Thread.php(21): Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/addons/XFA/TrophiesEnhancement/XF/Pub/Controller/Thread.php(19): XenConcept\AdvancedPermissions\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(321): XFA\TrophiesEnhancement\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(XFA\WhoReadThisThread\XF\Pub\Controller\Thread), NULL)
#14 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFA\WhoReadThisThread\XF\Pub\Controller\Thread), NULL)
#15 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#17 src/XF.php(390): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
From where it comes please ?

Thanks
 

Fredxd

Administrator
Staff member
Joined
Nov 14, 2015
Messages
1,582
Hello,

Je n'ai rien trouvé d'anormal à ce niveau.
L'erreur est apparu une seul fois? ou c'est régulier et toujours sur la même requête ?
 

Fredxd

Administrator
Staff member
Joined
Nov 14, 2015
Messages
1,582
Est-il possible d’avoir le détail de cette erreur

Merci
 

Cheb

New Member
Joined
Aug 25, 2017
Messages
29
Est-il possible d’avoir le détail de cette erreur

Merci
Oui bien sur :

Code:
INSERT  INTO `xfa_wrtt_thread_read` (`thread_id`, `user_id`, `thread_read_date`) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
------------

#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(221): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XFA/WhoReadThisThread/XF/Repository/Thread.php(27): XF\Db\AbstractAdapter->insert('xfa_wrtt_thread...', Array, false, 'thread_read_dat...')
#5 src/XF/Pub/Controller/Thread.php(89): XFA\WhoReadThisThread\XF\Repository\Thread->markThreadReadByVisitor(Object(XFA\WhoReadThisThread\XF\Entity\Thread), 1557653240)
#6 src/addons/ForoAgency/PrivateMessageReplies/XF/Pub/Controller/Thread.php(11): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/addons/XenConcept/HideBBCode/XF/Pub/Controller/Thread.php(21): ForoAgency\PrivateMessageReplies\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#8 src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php(16): XenConcept\HideBBCode\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/addons/XenConcept/AdvancedPermissions/XF/Pub/Controller/Thread.php(21): Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/addons/XFA/TrophiesEnhancement/XF/Pub/Controller/Thread.php(19): XenConcept\AdvancedPermissions\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(321): XFA\TrophiesEnhancement\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(XFA\WhoReadThisThread\XF\Pub\Controller\Thread), NULL)
#13 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFA\WhoReadThisThread\XF\Pub\Controller\Thread), NULL)
#14 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#16 src/XF.php(390): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}