When attempting to alter a table to enable compression by modifying the
KEY_BLOCK_SIZE I received the error:
ERROR 1296 (HY000): Got error 64 'Temp file write failure' from InnoDB
The command run was:
MariaDB [events_prod]> alter table positions KEY_BLOCK_SIZE=8;
The alter table ran for about an hour before generating this error. The table in question is 280 gigabytes and the filesystem on which it resides has 3.4 terabytes free. I am already using per-table files and barracuda for storage.
I can't seem to find any documentation that explains what the cause of this error might be or where to even start trying to resolve it. Any suggestions are appreciated!