- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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";}
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Table lock
- Table corruption
- 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.
--- Time fixes everything but your e-commerce bugs. Call MageSpecialist for them!