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 ?
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET