MySQL server has gone away (error 2006)

[GoogleCodeExporter]

A customer is getting intermittent order failures when the order goes through, 
but the files and ZP details are missing. ZP finishes the processing and 
obviously sends a response, but it doesn't register with mage.

See error log below.

== Questions ==
What is causing the timeout?
Do we have very long transactions waiting for a ZP response?
Is there anything we can do?

We definitely need to document this in installation prerequisites. 
Post the timeout requirements and instructions on where to change it here.

2012-01-13T18:46:45+00:00 ERR (3): 
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 
MySQL server has gone away' in 
/home/salesaid/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php:305
Stack trace:
#0 /home/salesaid/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(305): 
PDO->beginTransaction()
#1 /home/salesaid/public_html/lib/Zend/Db/Adapter/Abstract.php(495): 
Zend_Db_Adapter_Pdo_Abstract->_beginTransaction()
#2 /home/salesaid/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(152): 
Zend_Db_Adapter_Abstract->beginTransaction()
#3 
/home/salesaid/public_html/app/code/core/Mage/Core/Model/Resource/Abstract.php(7
0): Varien_Db_Adapter_Pdo_Mysql->beginTransaction()
#4 /home/salesaid/public_html/app/code/core/Mage/Core/Model/Abstract.php(313): 
Mage_Core_Model_Resource_Abstract->beginTransaction()
#5 
/home/salesaid/public_html/app/code/community/ZetaPrints/WebToPrint/Model/Events
/Observer.php(407): Mage_Core_Model_Abstract->save()
#6 /home/salesaid/public_html/app/code/core/Mage/Core/Model/App.php(1272): 
ZetaPrints_WebToPrint_Model_Events_Observer->complete_zetaprints_order(Object(Va
rien_Event_Observer))
#7 /home/salesaid/public_html/app/code/core/Mage/Core/Model/App.php(1253): 
Mage_Core_Model_App->_callObserverMethod(Object(ZetaPrints_WebToPrint_Model_Even
ts_Observer), 'complete_zetapr...', Object(Varien_Event_Observer))
#8 /home/salesaid/public_html/app/Mage.php(416): 
Mage_Core_Model_App->dispatchEvent('checkout_type_o...', Array)
#9 
/home/salesaid/public_html/app/code/core/Mage/Checkout/Model/Type/Onepage.php(75
8): Mage::dispatchEvent('checkout_type_o...', Array)
#10 
/home/salesaid/public_html/app/code/core/Mage/Checkout/controllers/OnepageContro
ller.php(499): Mage_Checkout_Model_Type_Onepage->saveOrder()
#11 
/home/salesaid/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(
420): Mage_Checkout_OnepageController->saveOrderAction()
#12 
/home/salesaid/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Stan
dard.php(253): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
#13 
/home/salesaid/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(1
76): 
Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_R
equest_Http))
#14 /home/salesaid/public_html/app/code/core/Mage/Core/Model/App.php(340): 
Mage_Core_Controller_Varien_Front->dispatch()
#15 /home/salesaid/public_html/app/Mage.php(627): 
Mage_Core_Model_App->run(Array)
#16 /home/salesaid/public_html/index.php(80): Mage::run('', 'store')
#17 {main}

Original issue reported on code.google.com by ad...@zetaprints.com on 14 Jan 2012 at 9:52

[GoogleCodeExporter]

This particular customer had a very short timeout. The problem went away when 
they increased it.

Let's put it in the FAQ.

Original comment by ad...@zetaprints.com on 7 Feb 2012 at 8:26

• Changed state: Docos
• Removed labels: Unit-0.5

[GoogleCodeExporter]

Can you post those timeout details?
Don't know what to say in the FAQs, whats the minimum timeout value and where 
is it set?

Original comment by agur...@gmail.com on 13 Mar 2012 at 1:13

[GoogleCodeExporter]

i suggest at least: 
wait_timeout = 300 

Original comment by danielos...@gmail.com on 22 Mar 2012 at 9:36

[GoogleCodeExporter]

Done:
http://www.zetaprints.com/magentohelp/faq-2/

Original comment by agur...@gmail.com on 29 Mar 2012 at 12:07

• Added labels: Help-V
• Removed labels: Help-X

[GoogleCodeExporter]

Original comment by ad...@zetaprints.com on 3 Apr 2012 at 12:04

• Changed state: Done