List:General Discussion« Previous MessageNext Message »
From:Machiel Richards - Gmail Date:September 10 2012 12:38pm
Subject:Re: Temporary table creation fails
View as plain text  
Hi


at the moment this does not really matter to us.

     we have even tried to create a temp table with only one field in 
order to insert one row for testing, but we are currently not able to 
create any temporary tables whatsoever as even the simplest form of 
table still gives the same error.

Regards


On 09/10/2012 02:33 PM, Ananda Kumar wrote:
> 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 <mailto: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