Magento Forum

   
Please help!  - SQLSTATE[00000] [1040] Too many connections
 
tirko
Jr. Member
 
Total Posts:  6
Joined:  2008-11-19
 

Magento is down, and out site is being promoted on TV today!  Any ideas?

There has been an error processing your request.

SQLSTATE[00000] [1040] Too many connections
Trace:
#0 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(167): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/lib/Zend/Db/Adapter/Abstract.php(390): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’SET NAMES utf8’, Array)
#3 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(230): Zend_Db_Adapter_Pdo_Abstract->query(’SET NAMES utf8’, Array)
#4 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Resource/Type/Db/Pdo/Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query(’SET NAMES utf8’)
#5 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Resource.php(83): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Object(Mage_Core_Model_Config_Element))
#6 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(248): Mage_Core_Model_Resource->getConnection(’core_read’)
#7 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(263): Mage_Core_Model_Mysql4_Abstract->_getConnection(’read’)
#8 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(283): Mage_Core_Model_Mysql4_Abstract->_getReadAdapter()
#9 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Mysql4/Collection/Abstract.php(68): Mage_Core_Model_Mysql4_Abstract->getReadConnection()
#10 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Config.php(721): Mage_Core_Model_Mysql4_Collection_Abstract->__construct(Object(Mage_Core_Model_Mysql4_Website))
#11 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Config.php(763): Mage_Core_Model_Config->getModelInstance(’core_mysql4/web...’, Object(Mage_Core_Model_Mysql4_Website))
#12 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/Mage.php(342): Mage_Core_Model_Config->getResourceModelInstance(’core/website_co...’, Object(Mage_Core_Model_Mysql4_Website))
#13 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Abstract.php(191): Mage::getResourceModel(’core/website_co...’, Object(Mage_Core_Model_Mysql4_Website))
#14 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/Abstract.php(196): Mage_Core_Model_Abstract->getResourceCollection()
#15 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/App.php(372): Mage_Core_Model_Abstract->getCollection()
#16 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/code/core/Mage/Core/Model/App.php(246): Mage_Core_Model_App->_initStores()
#17 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/Mage.php(424): Mage_Core_Model_App->init(’’, ‘store’, Array)
#18 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/app/Mage.php(443): Mage::app(’’, ‘store’, Array)
#19 /nfs/c03/h03/mnt/54776/domains/shop.marytedescofitness.com/html/index.php(52): Mage::run()
#20 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial Web Host
Guru
 
Avatar
Total Posts:  364
Joined:  2007-11-08
Phoenix, AZ
 

Hi Tirko,

The problem is that your database server has reached the maximum number of allowable connections for your account. 

Sometimes in shared hosting this is set to an artificially low number to prevent any single client from consuming more than their fair share of ‘shared’ resources.

In the MySQL server configuration file you will likely find two entries;

max_user_connections=50
max_connections=200

You will want raise these, or request that your host increase the max_user_connections and possibly the max_connections, if necessary under your scenario.

This will require a restart of the database server for these changes to take place.

Hope this helps - TV can create very sporadic floods of traffic and you should be sure your hosting environment is equipped to deal with that kind of resource burst.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top