0
I made a mirror copy of a website in Malta. The site runs cute on front-end, loads fast and all, but when I try to access the admin, besides taking a long time to the login (2.3 minutes), when I do the login, it returns this error:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Trace: #0 /home/floraweb/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/floraweb/public_html/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array) #2 /home/floraweb/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `admin_u...', Array) #3 /home/floraweb/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `admin_u...', Array) #4 /home/floraweb/public_html/lib/Zend/Db/Adapter/Abstract.php(725): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #5 /home/floraweb/public_html/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(352): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select)) #6 /home/floraweb/public_html/app/code/core/Mage/Admin/Model/Mysql4/User.php(141): Mage_Core_Model_Mysql4_Abstract->load(Object(Mage_Admin_Model_User), '1', NULL) #7 /home/floraweb/public_html/app/code/core/Mage/Core/Model/Abstract.php(225): Mage_Admin_Model_Mysql4_User->load(Object(Mage_Admin_Model_User), '1', NULL) #8 /home/floraweb/public_html/app/code/core/Mage/Admin/Model/User.php(281): Mage_Core_Model_Abstract->load('1') #9 /home/floraweb/public_html/app/code/core/Mage/Admin/Model/Observer.php(48): Mage_Admin_Model_User->reload() #10 /home/floraweb/public_html/app/code/core/Mage/Core/Model/App.php(1228): Mage_Admin_Model_Observer->actionPreDispatchAdmin(Object(Varien_Event_Observer)) #11 /home/floraweb/public_html/app/code/core/Mage/Core/Model/App.php(1209): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Admin_Model_Observer), 'actionPreDispat...', Object(Varien_Event_Observer)) #12 /home/floraweb/public_html/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array) #13 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(497): Mage::dispatchEvent('controller_acti...', Array) #14 /home/floraweb/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(152): Mage_Core_Controller_Varien_Action->preDispatch() #15 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Adminhtml_Controller_Action->preDispatch() #16 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index') #17 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #18 /home/floraweb/public_html/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch() #19 /home/floraweb/public_html/app/Mage.php(596): Mage_Core_Model_App->run(Array) #20 /home/floraweb/public_html/index.php(83): Mage::run('', 'store') #21 {main}
DNS is not configured because I am still developing, I am accessing through IP and have updated this information in the fields "web/Unsecure/base_url" and "web/Secure/base_url". The site was working pretty, even the panel admin was coming in. This problem appeared from one day to the next.
You are facing problems with your database. Either it is unstable or your application is consuming more resources than it can offer and your hosting provider is causing this error to get your attention. Also check your connection data in the/etc/local.xml app ...
– Marcos Vinicius
Friend, first of all, thank you for answering. Yes, it’s a Mysql error, but I don’t think the problem is with the database, otherwise the front-end tbm would be giving Zica, the local.xml document is properly configured... I believe the problem is in the same resources, something is making the query last longer than the time allowed to access the backend.
– Higor Freire da Fonseca