Magento - SQLSTATE[08004] [1040] Too many connections - Magento Upgrades - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

SQLSTATE[08004] [1040] Too many connections

rking@xpresspc.com Total Posts: 14 Joined: 2008-08-27 Atlanta, GA Ignore user	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}
	Posted: September 19 2008 \| top

PCoulton Total Posts: 6 Joined: 2008-07-28 Ignore user	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}
	Posted: September 23 2008 \| top \| # 1

SimpleHelix.com Total Posts: 905 Joined: 2007-08-31 Huntsville, AL Ignore user	pcoulton: could you submit a ticket to us regarding that issue? we’ll have our techs look into that for you. Signature █ SimpleHelix, LLC █ A World-Class Magento Web Hosting company - Providing scalable, reliable, and secure enterprise hosting solutions █ The creators of super-fast performance hosting. Find out more @ http://www.SimpleHelix.com
	Posted: September 23 2008 \| top \| # 2

PCoulton Total Posts: 6 Joined: 2008-07-28 Ignore user	I have reported this as a bug (#7328) and I’ll post any solutions that are suggested.
	Posted: September 23 2008 \| top \| # 3

PCoulton Total Posts: 6 Joined: 2008-07-28 Ignore user	simplehelix.com: Did you mean submit a Magento ticket or a simplehelix.com ticket?
	Posted: September 23 2008 \| top \| # 4

SimpleHelix.com Total Posts: 905 Joined: 2007-08-31 Huntsville, AL Ignore user	PCoulton: Are you still getting this error? Signature █ SimpleHelix, LLC █ A World-Class Magento Web Hosting company - Providing scalable, reliable, and secure enterprise hosting solutions █ The creators of super-fast performance hosting. Find out more @ http://www.SimpleHelix.com
	Posted: September 23 2008 \| top \| # 5

PCoulton Total Posts: 6 Joined: 2008-07-28 Ignore user	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.
	Posted: September 23 2008 \| top \| # 6

SimpleHelix.com Total Posts: 905 Joined: 2007-08-31 Huntsville, AL Ignore user	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. Signature █ SimpleHelix, LLC █ A World-Class Magento Web Hosting company - Providing scalable, reliable, and secure enterprise hosting solutions █ The creators of super-fast performance hosting. Find out more @ http://www.SimpleHelix.com
	Posted: September 23 2008 \| top \| # 7

PCoulton Total Posts: 6 Joined: 2008-07-28 Ignore user	Okay, thanks for replying.
	Posted: September 23 2008 \| top \| # 8

rking@xpresspc.com Total Posts: 14 Joined: 2008-08-27 Atlanta, GA Ignore user	rking@xpresspc.com - 19 September 2008 08: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}
	Posted: September 23 2008 \| top \| # 9

rking@xpresspc.com Total Posts: 14 Joined: 2008-08-27 Atlanta, GA Ignore user	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
	Posted: January 16 2009 \| top \| # 10

cannonballdex Total Posts: 65 Joined: 2008-10-16 Ignore user	SQLSTATE[08004] [1040] Too many connections Monday April 12, 2009 at 8:00am EST
	Posted: April 13 2009 \| top \| # 11

cannonballdex Total Posts: 65 Joined: 2008-10-16 Ignore user	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.
	Posted: April 13 2009 \| top \| # 12

mhunkler Total Posts: 304 Joined: 2009-05-30 Ignore user	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? Signature Concrete Diamond Saw Blades
	Posted: August 23 2011 \| top \| # 13

Emilianoqa Total Posts: 56 Joined: 2010-05-28 Ignore user	same here.... no solution so far on that SQLSTATE[08004] [1040] Too many connections thanks
	Posted: January 25 2012 \| top \| # 14

Anjan Barik Total Posts: 18 Joined: 2010-03-19 Kolkata Ignore user	Please restart the server for the quick fix and contact to the server provider to upgrade the plan. Signature Blog: http://www.xhtmlandcsshelp.blogspot.in/ website [url=http://www.anjanbarik.com/]http://www.anjanbarik.com/[/url]
	Posted: April 20 2012 \| top \| # 15

Magento Community

Magento Community

Back to top

Fatel error when upgrading to 1.1.6 HELP

Error upgrading to 1.1.6: Did not download optional dependencies: pear/XML_RPC, use --alldeps