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

Tadashi Shigeoka ·  Thu, March 15, 2012

When I was updating data for a web service running on PHP (symfony1.4) + Apache2 + MySQL, the following error occurred:

500 | Internal Server Error | Doctrine_Connection_Mysql_Exception
SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
MySQL

Cause of Error 28

Error 28 occurred because there wasn’t enough free disk space for MySQL.

When I checked disk usage with the df command, it was indeed using 100%.

# df -h
Filesystem          サイズ  使用  残り 使用% マウント位置
/dev/mapper/VolGroup00-LogVol00
                      9.1G  8.9G     0 100% /
/dev/xvda1             99M   21M   73M  23% /boot
tmpfs                 129M     0  129M   0% /dev/shm

Solution for Error 28

I resolved it by deleting large log files and unnecessary files.

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.

Source: Magento - Help! SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine - HTML, XHTML, CSS, Design Questions - eCommerce Software for Growth

That’s all from the Gemba.