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

Posts regarding the MySQL database server
Post Reply
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

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

Post by mister_v »

Hi,

I have the following error in MySQL,
when I do an alter statement:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.
the Alter command:

Code: Select all

ALTER TABLE f_inside_trade ADD COLUMN source TINYINT UNSIGNED;
Anyone know what the reason is?
Its the first time I get this error.
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

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

Post by chris »

When you do a ALTER TABLE in MySQL it re-create the table,
so two copies of the table exists on the system.

So you need enough free space.
specially in /tmp/
Because this dir is used as default.
you can change it in /etc/mysql/my.cnf

Code: Select all

tmpdir          = /tmp
Post Reply