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