![]() production.ERROR: PDOException: SQLSTATE: General error: 1205 Lock wait timeout exceeded try restarting transaction in /opt/librenms/vendor/doctrine/dbal/ Where config_id = 796) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 Next Illuminate\Database\QueryException: SQLSTATE: General error: 1205 Lock wait timeout exceeded try restarting transaction (SQL: update config set config_value = “fping6” Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE: General error: 1205 Lock wait timeout exceeded try restarting transaction in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/ #21 index.After migrating the DB to a MariaDB Galera Cluster, used by many other applications and services, we are noticing a bunch of timeout errors only on the LibreNMS application: #18 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #17 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL) #16 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL) #15 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag)) #14 src/XF/Pub/Controller/Thread.php(609): XF\Service\Thread\Replier->save() #13 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\Thread\Replier->_save() #12 src/XF/Service/Thread/Replier.php(214): XF\Mvc\Entity\Entity->save(true, false) #10 src/XF/Entity/Post.php(582): XF\Entity\Post->updateThreadRecord() #9 src/XF/Entity/Post.php(633): XF\Mvc\Entity\Entity->save() #8 src/XF/Mvc/Entity/Entity.php(1277): XF\Entity\Thread->_postSave() #7 src/XF/Entity/Thread.php(1201): XF\Entity\Thread->updateForumRecord() #5 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource() ![]() #4 src/XF/Mvc/Entity/Entity.php(1526): XF\Db\AbstractAdapter->update('xf_forum', Array, ' node_id = 36') #3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_for.', Array) #2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute() #1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err.', 1205, 'HY000') ![]() #0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err.', 1205, 'HY000') UPDATE xf_forum SET message_count = ?, last_post_date = ?, last_post_id = ?, last_post_user_id = ?, last_post_username = ? WHERE node_id = 36 XF\Db\Exception: MySQL query error : Lock wait timeout exceeded try restarting transaction src/XF/Db/AbstractStatement.php:230 We also tried to disabling crons and addons. We tried switching the server ( dedicated server cpu AMD EPYC 7313 ram 64gb disks nvme). Our setup at the time was: xenforo 2.1, php 7.3.33, mariadb 10.3 Īnd now we have: xenforo 2.2.8, php 8.0.28, mariadb 10.5.18 For no reason, last week, our Xen forum got this error and users can no longer write messages or do anything else. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |