Re: "Sort Aborted" errors after upgrade to 4.1.14

2005-09-26 Thread Dan Nelson
In the last episode (Sep 26), Kishore Jalleda said: > I know there was an earlier post regarding "sort aborted" error > after upgrading to 4.1.14 from 4.0.xxx, I am getting this error too, > and it never occured to me before, I found out the query which is > doing this, > > mysql error: Error wr

Re: Sort aborted

2005-09-07 Thread Bgs
Hi, I've tried that there is no problem with that. Mysql creates bigger tmp tables from time to time. We had this problem with a specific query onyl I sad had, as last night I tried again and it worked. Beats me... Server was not rebooted, mysql was not restarted and the available space

Re: Sort aborted

2005-09-06 Thread Gleb Paharenko
Hello. What operating system do you use? `su` to mysql user (I think the less ugly method should exists) and check if you able to create big files. Bgs <[EMAIL PROTECTED]> wrote: > > Hi, > > There are no quotas at all. The server has been up since march. This is > the first tim

Re: Sort aborted

2005-09-06 Thread Bgs
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

Re: Sort aborted

2005-09-06 Thread Gleb Paharenko
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