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 <[EMAIL PROTECTED]> 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






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to