From: Bgs
Date: September 6 2005 9:50am
Subject: Re: Sort aborted
List-Archive: http://lists.mysql.com/mysql/188764
Message-Id: <431D6671.8040103@bgs.hu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


  Hi,

There are no quotas at all. The server has been up since march. This is 
the first time we had this problem, but now it is consistent...

I run the query and after a few seconds, with about 8-10kB written on 
the disk, I get the abort.

Bye
Bgs


Gleb Paharenko wrote:
> Hello.
> 
> Do you have filesystem quotas enabled on your system?
> 
> 
> Bgs <bgs@stripped> wrote:
> 
>> Hi all,
>>
>>
>>We have a problem with our mysql 4.1.11 system. It has been working well 
>>since the installation, we only have one problem. In the case of certain 
>>selects, it always stop with "Sort aborted" error. To the client it 
>>returns errors like "ERROR 3 (HY000): Error writing file '/tmp/MYFh2Ob0' 
>>(Errcode: 28)".
>>
>>The funny thing is that /tmp has 1777 perms as it should and there is 
>>plenty of place left (the select breaks when there are only a few 
>>kilobytes of temporary files there).
>>
>>Browsing for the solution I only found a bug dated back to 2001 and 
>>another mail with similar problems with 4.1.7 that had no answer...
>>
>>Does anybody have a clue, what might be the problem ?
>>
>>Thanks
>>Bgs
>>
>>
> 
> 
>