Hi,
still no luck, same error being given immediately after pressing
enter.
On 09/10/2012 12:02 PM, Ananda Kumar wrote:
> start with 500MB and try
>
> On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail
> <machiel.richards@stripped <mailto:machiel.richards@stripped>> wrote:
>
> Hi, the sort_buffer_size was set to 8Mb as well as 32M for the
> session (currently 1M) and retried with same result.
>
>
>
>
>
> On 09/10/2012 11:55 AM, Ananda Kumar wrote:
>> can you trying setting sort_buffer_size to big value at your
>> session level and create the table
>>
>> On Mon, Sep 10, 2012 at 2:54 PM, Machiel Richards - Gmail
>> <machiel.richards@stripped <mailto:machiel.richards@stripped>>
>> wrote:
>>
>> Hi
>>
>> We tried that as well, however the databases are quite
>> busy and either other transactions overwrite the info, or
>> there is nothing logged.
>>
>> We even tried running the create statement and
>> immediately running Show innodb status, but nothing for that
>> statement.
>>
>> Regards
>>
>>
>>
>>
>>
>> On 09/10/2012 11:05 AM, Ananda Kumar wrote:
>>> try this command and see if you can get more info about the
>>> error
>>>
>>> show innodb status\G
>>>
>>> On Mon, Sep 10, 2012 at 2:25 PM, Machiel Richards - Gmail
>>> <machiel.richards@stripped
>>> <mailto:machiel.richards@stripped>> wrote:
>>>
>>> Hi All
>>>
>>> I am hoping someone can point me in the right direction.
>>>
>>> We have a mysql 5.0 database which is giving us
>>> hassles when trying to create a temporary table.
>>>
>>> The creation works perfectly on the slave machine as
>>> well as all our other db's, however on the one specific
>>> main server we are getting the message "ERROR 1005
>>> (HY000): Can't create table '/tmp/#sql4a27_68eed1_0.frm'
>>> (errno: -1)"
>>>
>>>
>>> We have been trying to figure this out for more
>>> than a week now with no luck.
>>>
>>> When looking in the mysql error.log file, the
>>> innodb states that there is either another mysqld
>>> running (confirmed and not the case) or it is a
>>> filesystem permissions problem.
>>>
>>>
>>> We have checked several times and the permissions
>>> on the /tmp filesystem is the same as on all servers.
>>>
>>>
>>> Any suggestions would be greatly appreciated as
>>> google didnt help much either.
>>>
>>>
>>> Regards
>>>
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe: http://lists.mysql.com/mysql
>>>
>>>
>>
>>
>
>
