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

Constantly having “mysql server disappear” in backend (performance) [RESOLVED]
 
Jonathan123
Sr. Member
 
Total Posts:  215
Joined:  2008-09-14
 

I haven’t seen this happen on the front end, but it happens constantly on the back end.
My mysql settings are:
[mysqld]
skip-bdb
datadir=/var/lib/mysql
skip-locking
safe-show-database
long_query_time=2
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
max_user_connections=30
max_connections=200
interactive_timeout=300
wait_timeout=30
connect_timeout=20
thread_cache_size=16
tmp_table_size=32M
max_heap_table_size=32M
table_cache=1024
key_buffer=64M
max_connect_errors=20
max_allowed_packet=32M
join_buffer=1M
record_buffer=1M
sort_buffer_size=4M
read_buffer_size=4M
read_rnd_buffer_size=2M
thread_concurrency=4
myisam_sort_buffer_size=16M
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=20M
innodb_flush_log_at_trx_commit=2
innodb_log_file_size=64M

Any suggestions?

UPDATE: I have changed all the timeouts to their defaults (removed my settings from my.cnf), and haven’t had a problem since.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Jonathan123
Sr. Member
 
Total Posts:  215
Joined:  2008-09-14
 

The exact error is:  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

I get this on the backend very often. Mainly when trying to add or edit products. I have gotten it for other things, but can’t recall which. Sometimes I’ll get it just trying to change to the “categories” tab when editing a product.

 
Magento Community Magento Community
Magento Community
Magento Community
 
EmJaInteractive
Sr. Member
 
Avatar
Total Posts:  121
Joined:  2009-04-29
Charlotte, NC USA
 

I have had 1 report from one of my testers about this on the FRONT END:

Magento Commerce
There has been an error processing your request.

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Trace:
#0 /home/arcarock/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/arcarock/public_html/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/arcarock/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/arcarock/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(230): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/arcarock/public_html/lib/Zend/Db/Adapter/Abstract.php(617): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/arcarock/public_html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(777): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
#6 /home/arcarock/public_html/app/code/core/Mage/Core/Model/Abstract.php(216): Mage_Eav_Model_Entity_Abstract->load(Object(Mage_Catalog_Model_Product), ‘12’, NULL)
#7 /home/arcarock/public_html/app/design/frontend/default/default/template/catalog/product/list_home_cat.phtml(41): Mage_Core_Model_Abstract->load(’12’)
#8 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(144): include(’/home/arcarock/...’)
#9 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#10 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#11 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#12 /home/arcarock/public_html/app/code/core/Mage/Core/Model/Email/Template/Filter.php(74): Mage_Core_Block_Abstract->toHtml()
#13 /home/arcarock/public_html/lib/Varien/Filter/Template.php(128): Mage_Core_Model_Email_Template_Filter->blockDirective(Array)
#14 /home/arcarock/public_html/app/code/core/Mage/Cms/Block/Block.php(52): Varien_Filter_Template->filter(Array, Array)
#15 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Cms_Block_Block->_toHtml(’{{block name="c...’)
#16 /home/arcarock/public_html/app/design/frontend/default/default/template/checkout/cart.phtml(133): Mage_Core_Block_Abstract->toHtml()
#17 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(144): include(’/home/arcarock/...’)
#18 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView()
#19 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView(’frontend/defaul...’)
#20 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#21 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#22 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Text_List->_toHtml()
#23 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#24 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml()
#25 /home/arcarock/public_html/app/design/frontend/default/default/template/page/1column.phtml(62): Mage_Core_Block_Abstract->getChildHtml(’content’, true)
#26 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(144): include(’/home/arcarock/...’)
#27 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView(’content’)
#28 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView(’frontend/defaul...’)
#29 /home/arcarock/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#30 /home/arcarock/public_html/app/code/core/Mage/Core/Model/Layout.php(525): Mage_Core_Block_Abstract->toHtml()
#31 /home/arcarock/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(326): Mage_Core_Model_Layout->getOutput()
#32 /home/arcarock/public_html/app/code/core/Mage/Checkout/controllers/CartController.php(134): Mage_Core_Controller_Varien_Action->renderLayout()
#33 /home/arcarock/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(349): Mage_Checkout_CartController->indexAction()
#34 /home/arcarock/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch()
#35 /home/arcarock/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Standard->match(’index’)
#36 /home/arcarock/public_html/app/Mage.php(447): Mage_Core_Controller_Varien_Front->dispatch(Object(Mage_Core_Controller_Request_Http))
#37 /home/arcarock/public_html/index.php(52): Mage::run()
#38 {main}

Magento is a trademark of Irubin Consulting Inc. DBA Varien. Copyright © 2008 Irubin Consulting Inc.

What does all that mean? Anything I can fix?  It is a rare error and out of the 30 web site testers I used only 1 reported this error.

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