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