Page 1 of 1

ERROR 1878 (HY000): Temporary file write failure.

Posted: Wed Aug 24, 2016 12:27 pm
by mister_v
I'm add a additional index on a table,
but after a few minutes I get the following error message:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.
And the index is not placed.

I check the partition, but there is still more as enough free space.

Re: ERROR 1878 (HY000): Temporary file write failure.

Posted: Wed Aug 24, 2016 5:45 pm
by chris
The error message says that your temporary file-system is full, or has a problem.

Usual it is /tmp/

The destination for the temporary directory is specified in the my.cnf file under the variable tmpdir.
The my.cnf is usually stored in /etc/mysql/my.cnf

Try setting to another partition?

Re: ERROR 1878 (HY000): Temporary file write failure.

Posted: Wed Aug 24, 2016 5:50 pm
by chris
You can find the tmpdir with the command:

Code: Select all

SHOW VARIABLES WHERE Variable_name='tmpdir';
if you change it in /etc/mysql/my.cnf,
you need to restart the mysql-service.

Code: Select all

sudo /etc/init.d/mysql restart