From: Machiel Richards - Gmail
Date: September 10 2012 12:41pm
Subject: Re: Temporary table creation fails
List-Archive: http://lists.mysql.com/mysql/228154
Message-Id: <504DE00F.9060500@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------040607020502020104000408"

--------------040607020502020104000408
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>>
>>
>
>


--------------040607020502020104000408--