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.