List:General Discussion« Previous MessageNext Message »
From:Machiel Richards - Gmail Date:September 10 2012 12:41pm
Subject:Re: Temporary table creation fails
View as plain text  
no selinux , checked this as well.

We generally dont use selinux and disable it completely from installation.

I have also gone through the firewall settings and that is only rules 
for connections.




On 09/10/2012 02:40 PM, Ananda Kumar wrote:
> did u check if there any firewall settings, forbidding you to create 
> files, check if " SELinux is disabled"
>
> On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail 
> <machiel.richards@stripped <mailto:machiel.richards@stripped>> wrote:
>
>     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