Magento

I just finished upgrading to the 1.3.1 version of Magento. I’m now getting an intermittent error when I try to log into the admin pannel. It takes forever for the the page to load and then I get the following error(s):

QLSTATE[HY000]: General error: 2006 MySQL server has gone away
Trace:
#0 /home/vavavoo1/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/vavavoo1/public_html/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/vavavoo1/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’SELECT `ar`.`ro...’, Array)
#3 /home/vavavoo1/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(259): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT `ar`.`ro...’, Array)
#4 /home/vavavoo1/public_html/lib/Zend/Db/Adapter/Abstract.php(727): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/vavavoo1/public_html/app/code/core/Mage/Admin/Model/Mysql4/User.php(215): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#6 /home/vavavoo1/public_html/app/code/core/Mage/Admin/Model/User.php(139): Mage_Admin_Model_Mysql4_User->getRoles(Object(Mage_Admin_Model_User))
#7 /home/vavavoo1/public_html/app/code/core/Mage/Adminhtml/Block/Page/Menu.php(55): Mage_Admin_Model_User->getRoles()
#8 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Abstract.php(904): Mage_Adminhtml_Block_Page_Menu->getCacheKey()
#9 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Abstract.php(635): Mage_Core_Block_Abstract->_loadCache()
#10 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#11 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml(’menu’, true)
#12 /home/vavavoo1/public_html/app/design/adminhtml/default/default/template/page.phtml(52): Mage_Core_Block_Abstract->getChildHtml(’menu’)
#13 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Template.php(144): include(’/home/vavavoo1/...’)
#14 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView(’adminhtml/defau...’)
#15 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#16 /home/vavavoo1/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#17 /home/vavavoo1/public_html/app/code/core/Mage/Core/Model/Layout.php(526): Mage_Core_Block_Abstract->toHtml()
#18 /home/vavavoo1/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(339): Mage_Core_Model_Layout->getOutput()
#19 /home/vavavoo1/public_html/app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php(87): Mage_Core_Controller_Varien_Action->renderLayout()
#20 /home/vavavoo1/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Adminhtml_Sales_OrderController->indexAction()
#21 /home/vavavoo1/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#22 /home/vavavoo1/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#23 /home/vavavoo1/public_html/app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch()
#24 /home/vavavoo1/public_html/index.php(52): Mage::run()
#25 {main}

The front end of the site is working fine. Anyone have an idea as to what is going on?

I am having the same problem. Does anyone have a solution for this?

1. Server timed out and closed the connection. How to fix: check that wait_timeout variable in your mysqld’s my.cnf configuration file is large enough. On Debian: sudo nano /etc/mysql/my.cnf, set wait_timeout to at least 600 seconds (you can tweak/decrease this value when error 2006 is gone), then sudo /etc/init.d/mysql restart. I didn’t check, but the default value for wait_timeout might be around 28800 seconds (8 hours).

2. Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. You can increase the maximal packet size limit by increasing the value of max_allowed_packet in my.cnf file. On Debian: sudo nano /etc/mysql/my.cnf, set max_allowed_packet to to something like 64M (you can tweak/decrease this value when error 2006 is gone), then sudo /etc/init.d/mysql restart.