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

SQLSTATE[08004] [1040] Too many connections
 
rking@xpresspc.com
Jr. Member
 
Total Posts:  14
Joined:  2008-08-27
Atlanta, GA
 

Any idea what went wrong? was working on updating in cms on links in the footer_links page.

There has been an error processing your request.

SQLSTATE[08004] [1040] Too many connections
Trace:
#0 /home/admin/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(136): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /home/admin/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(390): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 /home/admin/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’SET NAMES utf8’, Array)
#3 /home/admin/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(199): Zend_Db_Adapter_Pdo_Abstract->query(’SET NAMES utf8’, Array)
#4 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Resource/Type/Db/Pdo/Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query(’SET NAMES utf8’)
#5 /home/admin/public_html/magento/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 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(248): Mage_Core_Model_Resource->getConnection(’core_read’)
#7 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(263): Mage_Core_Model_Mysql4_Abstract->_getConnection(’read’)
#8 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(283): Mage_Core_Model_Mysql4_Abstract->_getReadAdapter()
#9 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Collection/Abstract.php(68): Mage_Core_Model_Mysql4_Abstract->getReadConnection()
#10 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Config.php(721): Mage_Core_Model_Mysql4_Collection_Abstract->__construct(Object(Mage_Core_Model_Mysql4_Website))
#11 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Config.php(763): Mage_Core_Model_Config->getModelInstance(’core_mysql4/web...’, Object(Mage_Core_Model_Mysql4_Website))
#12 /home/admin/public_html/magento/app/Mage.php(342): Mage_Core_Model_Config->getResourceModelInstance(’core/website_co...’, Object(Mage_Core_Model_Mysql4_Website))
#13 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Abstract.php(191): Mage::getResourceModel(’core/website_co...’, Object(Mage_Core_Model_Mysql4_Website))
#14 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Abstract.php(196): Mage_Core_Model_Abstract->getResourceCollection()
#15 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/App.php(361): Mage_Core_Model_Abstract->getCollection()
#16 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/App.php(239): Mage_Core_Model_App->_initStores()
#17 /home/admin/public_html/magento/app/Mage.php(424): Mage_Core_Model_App->init(’’, ‘store’, Array)
#18 /home/admin/public_html/magento/app/Mage.php(443): Mage::app(’’, ‘store’, Array)
#19 /home/admin/public_html/magento/index.php(52): Mage::run()
#20 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
PCoulton
Jr. Member
 
Total Posts:  6
Joined:  2008-07-28
 

Just got the same message while working on a Static Block, any ideas anyone?

SQLSTATE[08004] [1040] Too many connections

#0 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(136): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(390): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#3 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(199): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#4 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/code/core/Mage/Core/Model/Resource/Type/Db/Pdo/Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#5 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/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 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(62): Mage_Core_Model_Resource->getConnection('core_setup')
#7 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(119): Mage_Core_Model_Resource_Setup->__construct('core_setup')
#8 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/code/core/Mage/Core/Model/Config.php(215): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#9 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/code/core/Mage/Core/Model/App.php(236): Mage_Core_Model_Config->init(Array)
#10 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/Mage.php(424): Mage_Core_Model_App->init('', 'store', Array)
#11 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/app/Mage.php(443): Mage::app('', 'store', Array)
#12 /home/kbssimpl/domains/kbsoffice.com/public_html/magento/index.php(46): Mage::run()
#13 {main}
 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

pcoulton: could you submit a ticket to us regarding that issue? we’ll have our techs look into that for you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
PCoulton
Jr. Member
 
Total Posts:  6
Joined:  2008-07-28
 

I have reported this as a bug (#7328) and I’ll post any solutions that are suggested.

 
Magento Community Magento Community
Magento Community
Magento Community
 
PCoulton
Jr. Member
 
Total Posts:  6
Joined:  2008-07-28
 

simplehelix.com: Did you mean submit a Magento ticket or a simplehelix.com ticket?

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

PCoulton:
Are you still getting this error?

 
Magento Community Magento Community
Magento Community
Magento Community
 
PCoulton
Jr. Member
 
Total Posts:  6
Joined:  2008-07-28
 

SimpleHelix.com:
The error resolved itself after a few minutes as would be expected, but it did effect our frontend so I would prefer to know why it happened and how we can avoid it in the future.

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

The issue was due to one of our server being dugged which put a lot of strain on the server at one point.
Issue should be resolved now.

 
Magento Community Magento Community
Magento Community
Magento Community
 
PCoulton
Jr. Member
 
Total Posts:  6
Joined:  2008-07-28
 

Okay, thanks for replying.

 
Magento Community Magento Community
Magento Community
Magento Community
 
rking@xpresspc.com
Jr. Member
 
Total Posts:  14
Joined:  2008-08-27
Atlanta, GA
 
rking@xpresspc.com - 19 September 2008 07:36 AM

Any idea what went wrong? was working on updating in cms on links in the footer_links page.

I resolved my issue it had to do with my hosting service.
R. King

There has been an error processing your request.

SQLSTATE[08004] [1040] Too many connections
Trace:
#0 /home/admin/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(136): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /home/admin/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(390): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 /home/admin/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’SET NAMES utf8’, Array)
#3 /home/admin/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(199): Zend_Db_Adapter_Pdo_Abstract->query(’SET NAMES utf8’, Array)
#4 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Resource/Type/Db/Pdo/Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query(’SET NAMES utf8’)
#5 /home/admin/public_html/magento/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 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(248): Mage_Core_Model_Resource->getConnection(’core_read’)
#7 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(263): Mage_Core_Model_Mysql4_Abstract->_getConnection(’read’)
#8 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(283): Mage_Core_Model_Mysql4_Abstract->_getReadAdapter()
#9 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Collection/Abstract.php(68): Mage_Core_Model_Mysql4_Abstract->getReadConnection()
#10 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Config.php(721): Mage_Core_Model_Mysql4_Collection_Abstract->__construct(Object(Mage_Core_Model_Mysql4_Website))
#11 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Config.php(763): Mage_Core_Model_Config->getModelInstance(’core_mysql4/web...’, Object(Mage_Core_Model_Mysql4_Website))
#12 /home/admin/public_html/magento/app/Mage.php(342): Mage_Core_Model_Config->getResourceModelInstance(’core/website_co...’, Object(Mage_Core_Model_Mysql4_Website))
#13 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Abstract.php(191): Mage::getResourceModel(’core/website_co...’, Object(Mage_Core_Model_Mysql4_Website))
#14 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/Abstract.php(196): Mage_Core_Model_Abstract->getResourceCollection()
#15 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/App.php(361): Mage_Core_Model_Abstract->getCollection()
#16 /home/admin/public_html/magento/app/code/core/Mage/Core/Model/App.php(239): Mage_Core_Model_App->_initStores()
#17 /home/admin/public_html/magento/app/Mage.php(424): Mage_Core_Model_App->init(’’, ‘store’, Array)
#18 /home/admin/public_html/magento/app/Mage.php(443): Mage::app(’’, ‘store’, Array)
#19 /home/admin/public_html/magento/index.php(52): Mage::run()
#20 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
rking@xpresspc.com
Jr. Member
 
Total Posts:  14
Joined:  2008-08-27
Atlanta, GA
 

I had to get my ISP involved to get this problem corrected.
It’s a ressource issue I was told this happens if you are on a shared hosting or vps.

My problem was corrected after ISP got involed. for it’s worht I use http://nexcess.net as an ISP.
I found them on this forum and that has worked well for me so far.

Richard King.
rking@xpresspc.com

 
Magento Community Magento Community
Magento Community
Magento Community
 
cannonballdex
Member
 
Avatar
Total Posts:  65
Joined:  2008-10-16
 

SQLSTATE[08004] [1040] Too many connections

Monday April 12, 2009 at 8:00am EST

 
Magento Community Magento Community
Magento Community
Magento Community
 
cannonballdex
Member
 
Avatar
Total Posts:  65
Joined:  2008-10-16
 

SQLSTATE[08004] [1040] Too many connections

Monday April 12, 2009 at 8:10am EST

Being the busiest day of the week for sales, this isn’t good for me.

* Appears to be an issue with the host server and not the magento software.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mhunkler
Guru
 
Total Posts:  304
Joined:  2009-05-30
 

I am having this same problem on a dedicated server, and we only have a few sites on them, total traffic a day maybe 500 visits… nothing too crazy… Since we have a dedicated server i know GoDaddy will basically tell me to pay or GoF*ckMyself, so does anyone have any idea what can be the issue?

 
Magento Community Magento Community
Magento Community
Magento Community
 
NETRONIANinc
Member
 
Avatar
Total Posts:  57
Joined:  2010-05-28
 

same here....
no solution so far on that

SQLSTATE[08004] [1040] Too many connections

thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Anjan Barik
Jr. Member
 
Avatar
Total Posts:  18
Joined:  2010-03-19
Kolkata
 

Please restart the server for the quick fix and contact to the server provider to upgrade the plan. smile

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