Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

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