If you run MySQL and this error occurs:
then check if your server isn’t using the famous “overflow” filesystem for
/tmp, limited to 1 MB space.
The MySQL error message is - as usual - misleading and non-descriptive.
There are many other possible causes for this error code, so this one here might just be a hint.