Can anyone suggest me how to fix the following error file? It create a lot those error file in var/report
.
Am I right that I can simply delete all those error file in Var/report
?
a:4:{i:0;s:106:"SQLSTATE[42000] [1203] User advancea_mage2 already has
more than 'max_user_connections' active connections";i:1;s:3566:"#0
/home/advancea/domains/advanceauto.co.th/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(109):
Zend_Db_Adapter_Pdo_Abstract->_connect() #1
/home/advancea/domains/advanceauto.co.th/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(320):
Zend_Db_Adapter_Pdo_Mysql->_connect() #2
/home/advancea/domains/advanceauto.co.th/public_html/lib/Zend/Db/Adapter/Abstract.php(460):
Varien_Db_Adapter_Pdo_Mysql->_connect() #3
/home/advancea/domains/advanceauto.co.th/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238):
Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #4
/home/advancea/domains/advanceauto.co.th/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428):
Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #5
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource.php(169):
Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8') #6
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource.php(110):
Mage_Core_Model_Resource->_newConnection('pdo_mysql',
Object(Mage_Core_Model_Config_Element)) #7
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320):
Mage_Core_Model_Resource->getConnection('core_write') #8
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350):
Mage_Core_Model_Resource_Db_Abstract->_getConnection('write') #9
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335):
Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter() #10
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360):
Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter() #11
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134):
Mage_Core_Model_Resource_Db_Abstract->getReadConnection() #12
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Config.php(1348):
Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website))
13 /home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Config.php(1380):
Mage_Core_Model_Config->getModelInstance('core_resource/w…',
Object(Mage_Core_Model_Resource_Website)) #14
/home/advancea/domains/advanceauto.co.th/public_html/app/Mage.php(491):
Mage_Core_Model_Config->getResourceModelInstance('core/website_co…',
Object(Mage_Core_Model_Resource_Website)) #15
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Abstract.php(208):
Mage::getResourceModel('core/website_co…',
Object(Mage_Core_Model_Resource_Website)) #16
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/Abstract.php(213):
Mage_Core_Model_Abstract->getResourceCollection() #17
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/App.php(608):
Mage_Core_Model_Abstract->getCollection() #18
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/App.php(466):
Mage_Core_Model_App->_initStores() #19
/home/advancea/domains/advanceauto.co.th/public_html/app/code/core/Mage/Core/Model/App.php(349):
Mage_Core_Model_App->_initCurrentStore('', 'store') #20
/home/advancea/domains/advanceauto.co.th/public_html/app/Mage.php(684):
Mage_Core_Model_App->run(Array) #21
/home/advancea/domains/advanceauto.co.th/public_html/index.php(87):
Mage::run('', 'store') #22
{main}";s:3:"url";s:795:"/our-products.html?amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bp=2&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=5&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bcat=3&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bmode=list&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=19&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=18&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=4&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=18&%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=19&%3Bamp%3Bamp%3Bamp%3Bamp%3Bbrand=8&%3Bamp%3Bamp%3Bamp%3Bcar_type=16&%3Bamp%3Bamp%3Bp=5&%3Bamp%3Bbrand=17&%3Bcar_type=16&p=4";s:11:"script_name";s:10:"/index.php";}
Best Answer
You can safely remove
var/report
folder. But those files inside that directory gives you some feedbacks about your application where things going worse.In this case, it is reporting that you have too many mysql open connection requests. So basically you need to increase the mysql connection count.
See this thread for more details.