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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]