Magento Forum

   
When add/edit and save product, magento gives error: 1317 Query execution was interrupted
 
zmmy
Jr. Member
 
Total Posts:  7
Joined:  2009-01-29
 

Hi all.
I just upgrade from 1.4.2 to 1.5.0.1, everything work fine, but when I add/edit and save product information on the backend I get following error: SQLSTATE[70100]: <>: 1317 Query execution was interrupted. Actually the information is updated, but all products on the frontend not show, and I went to the index management, Price, and Category couldn\’t reindex and stay in \’Processing\’.

I think this because when add/update product, the system should also add/update the index. somehow this not working.  the query execution was interrupted.

Anyone know how to fix this?

exception.log file, I got:

Next exception \’Zend_Db_Statement_Exception\’ with message \’SQLSTATE[70100]: <<Unknown error>>: 1317 Query execution was interrupted\’ in /home/hjulian/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/hjulian/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/hjulian/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/hjulian/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\’INSERT INTO `mg...\’, Array)
#3 /home/hjulian/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(\’INSERT INTO `mg...\’, Array)
#4 /home/hjulian/public_html/app/code/core/Mage/Bundle/Model/Mysql4/Indexer/Price.php(365): Varien_Db_Adapter_Pdo_Mysql->query(\’INSERT INTO `mg...\’)
#5 /home/hjulian/public_html/app/code/core/Mage/Bundle/Model/Mysql4/Indexer/Price.php(245): Mage_Bundle_Model_Mysql4_Indexer_Price->_calculateBundleSelectionPrice(1)
#6 /home/hjulian/public_html/app/code/core/Mage/Bundle/Model/Mysql4/Indexer/Price.php(400): Mage_Bundle_Model_Mysql4_Indexer_Price->_calculateBundleOptionPrice()
#7 /home/hjulian/public_html/app/code/core/Mage/Bundle/Model/Mysql4/Indexer/Price.php(46): Mage_Bundle_Model_Mysql4_Indexer_Price->_prepareBundlePrice()
#8 /home/hjulian/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(377): Mage_Bundle_Model_Mysql4_Indexer_Price->reindexAll()
#9 /home/hjulian/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->reindexAll()
#10 /home/hjulian/public_html/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#11 /home/hjulian/public_html/app/code/core/Mage/CatalogRule/Model/Rule.php(272): Mage_Index_Model_Process->reindexAll()
#12 /home/hjulian/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(691): Mage_CatalogRule_Model_Rule->applyAllRulesToProduct(\’3506\’)
#13 /home/hjulian/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->saveAction()
#14 /home/hjulian/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(\’save\’)
#15 /home/hjulian/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#16 /home/hjulian/public_html/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
#17 /home/hjulian/public_html/app/Mage.php(627): Mage_Core_Model_App->run(Array)
#18 /home/hjulian/public_html/index.php(80): Mage::run(\’\’, \’store\’)
#19 {main}

Thanks in advance, sorry for my language

 
Magento Community Magento Community
Magento Community
Magento Community
 
zmmy
Jr. Member
 
Total Posts:  7
Joined:  2009-01-29
 

Hi

I solved this issue.

it’s because the mysql buffer is too small at our shared server. So I change the buffer size, and set other parameter at my.cnf as following:

[mysqld]
tmpdir=/dev/shm
max_connections = 300
max_allowed_packet = 100M //before is 64
query_cache_size = 40M
join_buffer_size = 10M
tmp_table_size = 64M
max_heap_table_size = 64M
thread_cache_size = 5
table_cache = 400 //before 64
innodb_buffer_pool_size = 350M
key_buffer_size = 1000M

This for somebody who get the same issue like me.

Although nobody reply, thanks the forum any way.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top