由于mysql错误，Magento网站关闭常规错误:1030存储引擎出现错误-1 [英] Magento site down due to mysql error General error: 1030 Got error -1 from storage engine
问题描述
我什至从log_visitor表中删除了所有记录，仍然遇到相同的问题.以下是我得到的堆栈. SQLSTATE [HY000]:常规错误:1030存储引擎出现错误-1
I even deleted all records from log_visitor table, still getting the same issue. Following is the stack I am getting. SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine
#0 /home/site/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/site/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/site/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/site/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `lo...', Array)
#4 /home/site/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `lo...', Array)
#5 /home/site/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `lo...', Array)
#6 /home/site/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('log_visitor', Array)
#7 /home/site/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor))
#8 /home/site/public_html/app/code/core/Mage/Log/Model/Visitor.php(167): Mage_Core_Model_Abstract->save()
#9 /home/site/public_html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#10 /home/site/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'initByRequest', Object(Varien_Event_Observer))
#11 /home/site/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
#12 /home/site/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(528): Mage::dispatchEvent('controller_acti...', Array)
#13 /home/site/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /home/site/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(408): Mage_Core_Controller_Front_Action->preDispatch()
#15 /home/site/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#16 /home/site/public_html/app/code/local/SM/Vendors/Controller/Router/Vendor.php(76): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /home/site/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): SM_Vendors_Controller_Router_Vendor->match(Object(Mage_Core_Controller_Request_Http))
#18 /home/site/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#19 /home/site/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#20 /home/site/public_html/index.php(87): Mage::run('', 'store')
#21 {main}
Fatal error: Exception thrown without a stack frame in Unknown on line 0
这是一个实时站点，我需要使其尽快上线.请帮忙.
This is a live site, I need make it live as soon as possible. Please help.
推荐答案
这是InnoDB无法写入其数据文件时发生的一般错误.
This is a general error that happens when InnoDB cannot write to its data files.
当磁盘已满，或者文件的权限发生更改从而无法写入它们时，我已经看到有关此问题的报告.
I've seen reports of this when the disk is full, or if permissions on the files changed so you can't write to them.
另一个报告是，当某人启用innodb_force_recovery的值大于0时，没有意识到在恢复模式> 0时，InnoDB实际上是只读的.
Another report was when someone enabled innodb_force_recovery to a value greater than 0, not realizing that in recovery modes >0, InnoDB is effectively read-only.
我希望这会有所帮助.
这篇关于由于mysql错误，Magento网站关闭常规错误:1030存储引擎出现错误-1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
