List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 10 2012 12:46pm
Subject:Re: Temporary table creation fails
View as plain text  
 please share the command ur using to create the temp table

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

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