{"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"}
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? 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 this error.
I have made some modification on MySQL like increasing innodb_buffer_pool_size 128M to 256M max_connection 100 to 200. Restarted MySql several times also but nothing worked.
Typically this error means your connection to MySQL is configured incorrectly.
Can you share your app/env.php configuration (masking the user/pass) and make sure your MySQL is listening on the correct IP/Port?
Without further info I will take a gut guess and say you are connecting to your database server as "localhost"? If so try changing it to "127.0.0.1" and see if it helps.
<?php return [ 'backend' => [ 'frontName' => 'myadmin' ], 'crypt' => [ 'key' => 'key' ], 'db' => [ 'table_prefix' => '', 'connection' => [ 'default' => [ 'host' => 'localhost', 'dbname' => 'user', 'username' => 'user', 'password' => '1234...', 'active' => '1' ] ] ], 'resource' => [ 'default_setup' => [ 'connection' => 'default' ] ], 'x-frame-options' => 'SAMEORIGIN', 'MAGE_MODE' => 'production', 'session' => [ 'save' => 'files' ], 'cache_types' => [ 'config' => 1, 'layout' => 1, 'block_html' => 1, 'collections' => 1, 'reflection' => 1, 'db_ddl' => 1, 'compiled_config' => 1, 'eav' => 1, 'customer_notification' => 1, 'config_integration' => 1, 'config_integration_api' => 1, 'full_page' => 0, 'config_webservice' => 1, 'translate' => 1, 'vertex' => 1, 'google_product' => 1 ], 'install' => [ 'date' => 'Sun, 24 Mar 2019 11:07:54 +0000' ], 'system' => [ 'default' => [ 'dev' => [ 'debug' => [ 'debug_logging' => '0' ] ] ] ], 'downloadable_domains' => [ 'mydomain.com' ] ];
i found it on app/code/env.php, is it what you asked?
masked user,pass,id,key & domain
Yes, that is the correct file.
Under this line:-
'host' => 'localhost',
Try changing it to:-
'host' => '127.0.0.1',
Why would i change it to ip?. localhost is what the default value isn't it?. it worked properly for all those years.
Hi @winson_joseph , did you then solve the problem?
Hello @winson_joseph
Here is the solution to your query:
→ First of all, connect your Magento 2 Server using SSH/FTP
→ Then, open Error log files from the var/report folder
→ Navigate the file which holds the same number as the error log record number
→ Now, check the content for the error. This log file content tells you everything about the error. So, you can follow the details and resolve the issue.
→ If Magento does not show Error Log, then follow the below steps:
σ Switch to the Developer Mode
σ Open[Magento Root Directory]/app/bootstrap.php
σ Add: error_reporting(E_ALL); ini_set('display_errors', 1); $_SERVER['MAGE_MODE'] = 'developer';
σ Above code will show you a detailed error message, that will help you to solve the error.
→ That’s it!
Problem Solved? Give 'Kudo' and Accept as Solution!
Stay safe, stay connected!
bonjour
jai le meme erreur svp aidez moi je galere