ERROR 1878 (HY000): Temporary file write failure.

[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]

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]

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