mysql - 来自管理的 Magento SQL 错误未捕获异常 'PDOException'，消息为“SQLSTATE[HY000]”

Question

亲爱的 friend 们，当页面加载时间过长时，我在 Magento 1.7.0.2 中从管理页面收到此错误，这周之前从未发生过，您能帮我解决此问题吗？

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /home/erboris1/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/erboris1/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) /home/erboris1/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) /home/erboris1/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) /home/erboris1/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) /home/erboris1/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE mg_core...', Array)
/home/erboris1/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419):
Zend_Db_Adapter_Pdo_Abstract->query('UPDATEmg_core...', Array) /home/erboris1/public_html/lib/Zend/Db/Adapter/Abstract.php(632): Varien_Db_Adapter_Pdo_Mysql->query('UPDATE `mg in /home/erboris1/public_html/lib/Zend/Db/Statement/Pdo.php on line 234

Answer 1

我们遇到了同样的问题，它与这个非错误相关:http://www.magentocommerce.com/bug-tracking/issue/?issue=10966对于很多类别，顶部菜单的刷新会使用大量的mysql资源，因为它是针对每个唯一的页面进行缓存的。我们的修复是仅在某些情况下使缓存无效。