From: Machiel Richards - Gmail
Date: September 10 2012 11:33am
Subject: Re: Temporary table creation fails
List-Archive: http://lists.mysql.com/mysql/228149
Message-Id: <504DCFFC.4090500@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,
     We confirmed that the /tmp directory permissions is set to 
rwxrwxrwxt and is owned by root , the same as all our other servers.

     There is also about 60Gb of free space on the filesystem where /tmp 
resides.

Regards




On 09/10/2012 01:11 PM, Rik Wasmus wrote:
>> the message "ERROR 1005 (HY000): Can't create table
>> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
> Basics first:
> 1) Is the /tmp directory write & readable for the user mysql runs as?
> 2) Has the /tmp directory enough free space?