[MySQL] SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
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
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
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.
That’s all from the Gemba.