|List:||General Discussion||« Previous MessageNext Message »|
|From:||Machiel Richards - Gmail||Date:||September 10 2012 11:33am|
|Subject:||Re: Temporary table creation fails|
|View as plain text|
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?