I'm receiving some strange errors on var/log folder there are bunch of similar errors too…I don't know what does it meant to says, can someone explain about this…How do i fix this?
Sample error log:-
{"0":"SQLSTATE[HY000] [2002] No such file or directory","1":"#1 Zend_Db_Adapter_Pdo_Mysql->_connect() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:410]\n#2 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_connect() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:575]\n#3 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_query('SELECT `url_rewr...', array()) called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:613]\n#4 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->query(&Magento\\Framework\\DB\\Select#0000000011bc4257000000007f7b4680#, array()) called at [generated\/code\/Magento\/Framework\/DB\/Adapter\/Pdo\/Mysql\/Interceptor.php:128]\n#5 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql\\Interceptor->query(&Magento\\Framework\\DB\\Select#0000000011bc4257000000007f7b4680#, array()) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Abstract.php:737]\n#6 Zend_Db_Adapter_Abstract->fetchAll(&Magento\\Framework\\DB\\Select#0000000011bc4257000000007f7b4680#, array(), 2) called at [generated\/code\/Magento\/Framework\/DB\/Adapter\/Pdo\/Mysql\/Interceptor.php:1558]\n#7 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql\\Interceptor->fetchAll(&Magento\\Framework\\DB\\Select#0000000011bc4257000000007f7b4680#) called at [vendor\/magento\/module-url-rewrite\/Model\/Storage\/DbStorage.php:118]\n#8 Magento\\UrlRewrite\\Model\\Storage\\DbStorage->doFindOneByData(array('request_path' => array('catalog\/category...', 'catalog\/category...'), 'store_id' => 1)) called at [vendor\/magento\/module-url-rewrite\/Model\/Storage\/AbstractStorage.php:66]\n#9 Magento\\UrlRewrite\\Model\\Storage\\AbstractStorage->findOneByData(array('request_path' => 'catalog\/category...', 'store_id' => 1)) called at [generated\/code\/Magento\/UrlRewrite\/Model\/Storage\/DbStorage\/Interceptor.php:50]\n#10 Magento\\UrlRewrite\\Model\\Storage\\DbStorage\\Interceptor->findOneByData(array('request_path' => 'catalog\/category...', 'store_id' => 1)) called at [vendor\/magento\/module-url-rewrite\/Model\/CompositeUrlFinder.php:93]\n#11 Magento\\UrlRewrite\\Model\\CompositeUrlFinder->findOneByData(array('request_path' => 'catalog\/category...', 'store_id' => 1)) called at [vendor\/magento\/module-url-rewrite\/Controller\/Router.php:154]\n#12 Magento\\UrlRewrite\\Controller\\Router->getRewrite('\/catalog\/categor...', 1) called at [vendor\/magento\/module-url-rewrite\/Controller\/Router.php:83]\n#13 Magento\\UrlRewrite\\Controller\\Router->match(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/framework\/App\/FrontController.php:95]\n#14 Magento\\Framework\\App\\FrontController->dispatch(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#15 Magento\\Framework\\App\\FrontController\\Interceptor->___callParent('dispatch', array(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#)) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#16 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/module-store\/App\/FrontController\/Plugin\/RequestPreprocessor.php:99]\n#17 Magento\\Store\\App\\FrontController\\Plugin\\RequestPreprocessor->aroundDispatch(&Magento\\Framework\\App\\FrontController\\Interceptor#0000000011bc41f2000000007f7b4680#, &Closure#0000000011bc41d7000000007f7b4680#, &Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#18 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/module-page-cache\/Model\/App\/FrontController\/BuiltinPlugin.php:73]\n#19 Magento\\PageCache\\Model\\App\\FrontController\\BuiltinPlugin->aroundDispatch(&Magento\\Framework\\App\\FrontController\\Interceptor#0000000011bc41f2000000007f7b4680#, &Closure#0000000011bc41d7000000007f7b4680#, &Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#20 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#21 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins('dispatch', array(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#), NULL) called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:26]\n#22 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch(&Magento\\Framework\\App\\Request\\Http#0000000011bc40bc000000007f7b4680#) called at [vendor\/magento\/framework\/App\/Http.php:116]\n#23 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n#24 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n#25 Magento\\Framework\\App\\Bootstrap->run(&Magento\\Framework\\App\\Http\\Interceptor#0000000011bc4042000000007f7b4680#) called at [index.php:39]\n","url":"\/brands?brand=15%2C354&concern=450%2C460%2C516%2C521%2C527%2C534%2C564&product_list_order=position&skin_type=462","script_name":"\/index.php","report_id":"1a014e3f87dbc9664c2d64c4b558e4758fdc4258109d6bfe55f5d9ce5e08c8ec"}
the above is the most recent error log, At this time the site was displaying There has been an error processing your request and after few sec it came back to normal. Also i have noticed that the RAM is dying to process....
I did tried:- some modification on MySQL like increasing innodb_buffer_pool_size 128M to 256M max_connection 100 to 200 but nothing worked.
SPECS:
- Hosting on Digitalocean Server (4 GB / 2 CPU's)
- Ubuntu Server (v16.04)
- Magento V 2.3.4
- Php 7.2
