cancel
Showing results for 
Search instead for 
Did you mean: 

Checkout "inceppato"

Checkout "inceppato"

Buonasera a tutti,

da stamattina i clienti non riescono più a completare l''evasione di un ordine.

Dopo il primo step (inserimento dei propri dati) e prima del passaggio alla fatturazione il sistema si blocca dopo aver "girato a vuoto" per un bel po'.

A volte ritorna alla pagina iniziale del carrello, altre volte restituisce un messaggio di errore con relativo file di log che allego.

 

_________________________________________________________________________

 

a:5:{i:0;s:203:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away, query was: SELECT `mage_salesrule_label`.`store_id`, `mage_salesrule_label`.`label` FROM `mage_salesrule_label` WHERE (rule_id = :rule_id)";i:1;s:3005:"#0 /home/tcb2stor/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/tcb2stor/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/tcb2stor/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/tcb2stor/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `mage_sa...', Array)
#4 /home/tcb2stor/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `mage_sa...', Array)
#5 /home/tcb2stor/public_html/lib/Zend/Db/Adapter/Abstract.php(811): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/tcb2stor/public_html/app/code/core/Mage/SalesRule/Model/Resource/Rule.php(220): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select), Array)
#7 /home/tcb2stor/public_html/app/code/core/Mage/SalesRule/Model/Rule.php(359): Mage_SalesRule_Model_Resource_Rule->getStoreLabels('47')
#8 /home/tcb2stor/public_html/app/code/core/Mage/SalesRule/Model/Rule.php(340): Mage_SalesRule_Model_Rule->getStoreLabels()
#9 /home/tcb2stor/public_html/app/code/core/Mage/SalesRule/Model/Validator.php(936): Mage_SalesRule_Model_Rule->getStoreLabel(Object(Mage_Core_Model_Store))
#10 /home/tcb2stor/public_html/app/code/core/Mage/SalesRule/Model/Validator.php(509): Mage_SalesRule_Model_Validator->_addDiscountDescription(Object(Mage_Sales_Model_Quote_Address), Object(Mage_SalesRule_Model_Rule))
#11 /home/tcb2stor/public_html/app/code/core/Mage/SalesRule/Model/Quote/Discount.php(106): Mage_SalesRule_Model_Validator->process(Object(Mage_Sales_Model_Quote_Item))
#12 /home/tcb2stor/public_html/app/code/core/Mage/Sales/Model/Quote/Address.php(1013): Mage_SalesRule_Model_Quote_Discount->collect(Object(Mage_Sales_Model_Quote_Address))
#13 /home/tcb2stor/public_html/app/code/core/Mage/Sales/Model/Quote.php(1331): Mage_Sales_Model_Quote_Address->collectTotals()
#14 /home/tcb2stor/public_html/app/code/core/Mage/Checkout/Model/Cart.php(458): Mage_Sales_Model_Quote->collectTotals()
#15 /home/tcb2stor/public_html/app/code/core/Mage/Checkout/controllers/CartController.php(144): Mage_Checkout_Model_Cart->save()
#16 /home/tcb2stor/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Checkout_CartController->indexAction()
#17 /home/tcb2stor/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#18 /home/tcb2stor/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /home/tcb2stor/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#20 /home/tcb2stor/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#21 /home/tcb2stor/public_html/index.php(87): Mage::run('', 'store')
#22 {main}";s:3:"url";s:15:"/checkout/cart/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

1 REPLY

Re: Checkout "inceppato"

A giudicare dall'errore direi che non si tratta di un problema "interno" a Magento, ma di un problema di MySQL.

Nello specifico il tuo MySQL chiude la connessione durante l'elaborazione delle regole di carrello.

 

Se hai un numero elevato di regole di carrello ti consiglierei di eliminarne qualcuna, ma molto più probabilmente hai uno dei seguenti problemi:

  1. Table lock
  2. Table corruption
  3. Troppa poca memoria MySQL

Per prima cosa prova banalmente a riavviare MySQL, se non risolve prova un:

mysqlcheck -A --repair

 

Controlla "https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html" per la sintassi.

 

Se questo non risolve valuta l'incremento della memoria a disposizione di MySQL.

--- Riccardo Tempesta - http://www.magespecialist.it
--- Time fixes everything but your e-commerce bugs. Call MageSpecialist for them!