ERROR 1878 (HY000): Temporary file write failure.

Post Reply
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

ERROR 1878 (HY000): Temporary file write failure.

Post 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.
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

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

Post 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?
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

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

Post 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
Post Reply