[Solved] ERROR 1030 (HY000): Got error 168 from storage engine

0 min read 154 words

If you are getting the following error in MySQL:
ERROR 1030 (HY000): Got error 168 from storage engine

Then this usually means that your server has run out of disk space!

This is never a good thing, but can be resolved by simply deleting some files on the server that you don’t need.

Solution 1: Delete some files

If you have some files on the server that you can delete to free up some space, then do so.

Otherwise we need to explore another route..

Solution 2: Clear the Journal

Linux keeps journal entries on disk, and this can take up some space that you can attempt to reclaim from.

Run the following command to vacuum the journal .

journalctl --vacuum-size=500M

Once you have completed this action, you can now run dh -f to see how much space you have available.

You will now be able to run the SQL command that failed beforehand.

Tags:
Andrew
Andrew

Andrew is a visionary software engineer and DevOps expert with a proven track record of delivering cutting-edge solutions that drive innovation at Ataiva.com. As a leader on numerous high-profile projects, Andrew brings his exceptional technical expertise and collaborative leadership skills to the table, fostering a culture of agility and excellence within the team. With a passion for architecting scalable systems, automating workflows, and empowering teams, Andrew is a sought-after authority in the field of software development and DevOps.

Tags

Recent Posts