cancel
Showing results for 
Search instead for 
Did you mean: 

There has been an error processing your request M 2.3.4

Highlighted

There has been an error processing your request M 2.3.4

{"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.

4 REPLIES 4
Highlighted

Re: There has been an error processing your request M 2.3.4

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.

--
Problem solved? Click Accept as Solution!
Highlighted

Re: There has been an error processing your request M 2.3.4

<?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

Highlighted

Re: There has been an error processing your request M 2.3.4

Yes, that is the correct file. 

 

Under this line:-

                'host' => 'localhost',

Try changing it to:-

                'host' => '127.0.0.1',
NoFrillsCloud | ESTD 2011 | Magento Optimized AWS Cloud Hosting
Powered by AWS cPanel LiteMage Cache DDoS Protection Dev Friendly
Highlighted

Re: There has been an error processing your request M 2.3.4

Why would i change it to ip?. localhost is what the default value isn't it?. it worked properly for all those years.