List:General Discussion« Previous MessageNext Message »
From:Bgs Date:September 5 2005 3:33pm
Subject:Sort aborted
View as plain text  
  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

Thread
Sort abortedBgs5 Sep
  • Re: Sort abortedGleb Paharenko6 Sep
    • Re: Sort abortedBgs6 Sep
      • Re: Sort abortedGleb Paharenko6 Sep
        • Re: Sort abortedBgs7 Sep