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.