List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 10 2012 12:33pm
Subject:Re: Temporary table creation fails
View as plain text  
this temp table will hold how many rows, what would be its size.

On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail <
machiel.richards@stripped> wrote:

> 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?
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

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