error code [1030]; Got error 28 from storage engine

This is quick thing which i wanted to share with you all and also the possible cause of this. This error started coming today afternoon on one of our production servers. We wasted some of the time searching logs and some errors which were irrelevant and finally Google for it. Quickly we got the cause which was disk. Disk was full and mysql was unable to take any extra data.

We were some of the things which made above situation for us:

1. Taking backups of DB and not cleaning up.
2. File storage server was running on the same server without any cleanup policy.

We did not realize that these two can eat up all the disk so quickly and learnt our lesson.

Avoid things like these and it is better if you configure daily disk stats in your mail box for all production servers.

Most Commented Posts

If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

Comments

No comments yet.

Leave a comment

(required)

(required)