Error 28 from Storage Engine is one of the very common error if your backend is connected with MySQL database. In this post, I am going to explain you how to troubleshoot Error 28 from Storage Engine.
Java application will throw java.sql.SQLException: Got error 28 from storage engine exception to indicate MySQL Error 28 from Storage Engine.
Reason for Error 28 from Storage Engine
This error is because of disk space is full and there is not enough disk space to execute and perform operations of MySQL queries.
Troubleshoot Error 28 from Storage Engine
Step 1: Check disk space using df -h . Result will be something like below.
[root@sp /var]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 20G 20G 0 100% /
udev 568K 9.5M 9.5M 6% /dev
....
This shows that disk space is full on server.
Step 2: Above scenario might happen because applications like MySQL, Apache, Tomcat etc… generates log files. This log files sometimes grow in GB if proper mechanism is not in place to move old logs.
Most common place to store log files on linux servers are /var/log and /tmp folder. To check your storage space use du -h command. Server could have been configured to store log files to other locations as well.
[root@sp /var]$cd /var/log
[root@sp /var/log]$ du -h
600K /var/log/installer
424K /var/log/mysql
8.2G /var/log/apache2
250M /var/log/tomcat5.5
8.5G /var/log
It shows that /var/log/apache2 is storing 8.2GB of log files.
Step 3: To solve the problem, consider backing up old log files and creating disk space on server. Restart MySQL service using following commands.
[root@sp /var/log]$ /etc/init.d/mysql stop
[root@sp /var/log]$ /etc/init.d/mysql start
If you want to keep your old files on the server for future use, then consider increasing the disk space on the server.
Step 4: This step is optional. Check free memory space using free -m. This command will show remaining memory on RAM in Megabytes.
[root@sp /var/log]$ free -m
total used free shared buffers cached
Mem: 4096 290 3805 0 0 72
-/+ buffers/cache: 218 3877
Swap: 512 0 512
This will give you the status of free RAM memory on the server.
