Magento Forum

   
Help! SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
 
barrmy
Sr. Member
 
Avatar
Total Posts:  102
Joined:  2008-06-03
 

I’m suddenly getting the error below...I’m not sure what could have triggered it, since the website was working just yesterday....I would really appreciate someone shedding some light on what went wrong...thanks in advance!

There has been an error processing your request.

SQLSTATE[HY000]General error1030 Got error 28 from storage engine
Trace
:
#0 /home/website/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/website/public_html/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/website/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/website/public_html/lib/Zend/Db/Adapter/Abstract.php(636): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/website/public_html/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(297): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#5 /home/website/public_html/app/code/core/Mage/Cms/Model/Mysql4/Block.php(80): Mage_Core_Model_Mysql4_Abstract->load(Object(Mage_Cms_Model_Block), 'top_nav_links', 'identifier')
#6 /home/website/public_html/app/code/core/Mage/Core/Model/Abstract.php(201): Mage_Cms_Model_Mysql4_Block->load(Object(Mage_Cms_Model_Block), 'top_nav_links', NULL)
#7 /home/website/public_html/app/code/core/Mage/Cms/Block/Block.php(39): Mage_Core_Model_Abstract->load('top_nav_links')
#8 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Cms_Block_Block->_toHtml()
#9 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#10 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml('topNav', true)
#11 /home/website/public_html/app/design/frontend/default/tcskin/template/page/html/header.phtml(33): Mage_Core_Block_Abstract->getChildHtml('topNav')
#12 /home/website/public_html/app/code/core/Mage/Core/Block/Template.php(131): include('/home/website/...')
#13 /home/website/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#14 /home/website/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#15 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#16 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#17 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml('header', true)
#18 /home/website/public_html/app/design/frontend/default/tcskin/template/page/2columns-right.phtml(34): Mage_Core_Block_Abstract->getChildHtml('header')
#19 /home/website/public_html/app/code/core/Mage/Core/Block/Template.php(131): include('/home/website/...')
#20 /home/website/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#21 /home/website/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#22 /home/website/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#23 /home/website/public_html/app/code/core/Mage/Core/Model/Layout.php(505): Mage_Core_Block_Abstract->toHtml()
#24 /home/website/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(319): Mage_Core_Model_Layout->getOutput()
#25 /home/website/public_html/app/code/core/Mage/Cms/Helper/Page.php(77): Mage_Core_Controller_Varien_Action->renderLayout()
#26 /home/website/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(26): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#27 /home/website/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Cms_IndexController->indexAction()
#28 /home/website/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch('index')
#29 /home/website/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#30 /home/website/public_html/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#31 /home/website/public_html/index.php(40): Mage::run()
#32 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
barrmy
Sr. Member
 
Avatar
Total Posts:  102
Joined:  2008-06-03
 

all fixed now

my host had to clear the /tmp folder to free up hard drive space on the server root...i’m on shared hosting

mod feel free to delete post

 
Magento Community Magento Community
Magento Community
Magento Community
 
oskarlind
Jr. Member
 
Total Posts:  15
Joined:  2008-08-23
 

thanks for that, I got the same error… was baffled but when I looked at “service status” in cpanel on my host it showed /tmp 100% and an alarmingly red exclamation mark after it, and that can’t be good!

 
Magento Community Magento Community
Magento Community
Magento Community
 
michiel grotenhuis
Jr. Member
 
Total Posts:  7
Joined:  2009-04-02
 

I have the same error but my storage aint full…

 
Magento Community Magento Community
Magento Community
Magento Community
 
seudo
Guru
 
Avatar
Total Posts:  344
Joined:  2008-04-21
 

@michiel, Have you reached your db size limit?

 
Magento Community Magento Community
Magento Community
Magento Community
 
xinhaozheng
Sr. Member
 
Total Posts:  107
Joined:  2009-03-09
 

clear the cache solve my prob.

 
Magento Community Magento Community
Magento Community
Magento Community
 
winzippy
Sr. Member
 
Avatar
Total Posts:  101
Joined:  2008-02-08
Rochester, NY, USA
 

Cleared var/cache and var/tmp… still have the same problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
irideflatland
Member
 
Avatar
Total Posts:  41
Joined:  2009-10-20
 

I’m getting the same error when trying to add a synonym for a search term

 
Magento Community Magento Community
Magento Community
Magento Community
 
mudejar2009
Jr. Member
 
Total Posts:  10
Joined:  2009-10-29
 

Cleared every folder in var/ and nothing.

Contacted my host server and all ok!!

Please. I need help...!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
irideflatland
Member
 
Avatar
Total Posts:  41
Joined:  2009-10-20
 

I can’t remember what I did to fix this… I think I contacted my host and they were doing something with the servers or something.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mudejar2009
Jr. Member
 
Total Posts:  10
Joined:  2009-10-29
 

You’re right!

I contacted them this morning and told them what happened. 10 minutes later all fixed.

Thanks irideflatland anyway!

Cya

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sequence Digitale
Jr. Member
 
Total Posts:  1
Joined:  2011-01-03
 

Hi!

I know it’s been a while since you post this topic but in case someone else has the same problem.

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

I added this code in the first row of the index.php bootstrap file.

ini_set('memory_limit',             '32M');

Which means to increase you memory limit to 32 Mb instead of 2 or 10, depending of your hosting.

This has worked for me.

Carl.

 
Magento Community Magento Community
Magento Community
Magento Community
 
jpbauer
Sr. Member
 
Total Posts:  159
Joined:  2008-10-09
Paris IDF
 

Hi Could explain with more detail in wich file you add this line because I’ve the same problem

 
Magento Community Magento Community
Magento Community
Magento Community
 
sc_mmc_srl
Jr. Member
 
Avatar
Total Posts:  15
Joined:  2010-04-18
Brasov
 

I deleted all content of cache,report and session folder from var. It worked in my case.

 
Magento Community Magento Community
Magento Community
Magento Community
 
chiefair
Mentor
 
Avatar
Total Posts:  1839
Joined:  2009-06-04
 

Merry Christmas, it’s that time of year for severe server load testing! You will soon know if your hosting plan fits Magento!

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine”;

Error 28 occurs when there is not enough disk space left for MySQL install to run properly. Then you start receiving error 28 messages.

“Error 28” often occurs on

Filesystem full. Hard drive full.
Host oversold their shared hosting.
Host misconfigured their shared MySQL install.

To fix this you must increase the space of your filesystem or make room by deleting files. In other words your hard drive is full and MySQL needs more space.

 
Magento Community Magento Community
Magento Community
Magento Community
 
pyrogo
Jr. Member
 
Total Posts:  1
Joined:  2013-01-01
 

I know It’s an old thread, but I got this error and I’d like to share my solution.

Accidentally I changed the ownership of /usr/local/mysql (or the folder where mysql data are stored).

Changing the permissions back to mysql:mysql or _mysql did the trick.

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