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?

Thread
Temporary table creation failsMachiel Richards - Gmail10 Sep
  • Re: Temporary table creation failsAnanda Kumar10 Sep
    • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
      • Re: Temporary table creation failsAnanda Kumar10 Sep
        • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
          • Re: Temporary table creation failsAnanda Kumar10 Sep
            • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
              • Re: Temporary table creation failsAkshay Suryavanshi10 Sep
                • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
  • Re: Temporary table creation failsRik Wasmus10 Sep
    • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
      • Re: Temporary table creation failsAnanda Kumar10 Sep
        • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
          • Re: Temporary table creation failsAnanda Kumar10 Sep
            • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
              • Re: Temporary table creation failsAnanda Kumar10 Sep
          • Re: Temporary table creation failsAkshay Suryavanshi10 Sep
Re: Temporary table creation failsGarot Conklin10 Sep
  • Re: Temporary table creation failsMachiel Richards - Gmail10 Sep
    • Re: Temporary table creation failsManuel Arostegui10 Sep
Re: Temporary table creation failsGarot Conklin10 Sep
  • Re: Temporary table creation failsShawn Green10 Sep