Re[2]: Got error 12 from storage engine on ORDER BY

2005-12-29 Thread Walter Hop
[in reply to [EMAIL PROTECTED], 28-12-2005] Hi, MySQL 4.1.10a on FreeBSD 5.4-RELEASE-p6 ERROR 1030 (HY000): Got error 12 from storage engine Strangely, this problem does not appear when mysqld is restarted and I retry the query. When I wait a day, the error starts to appear again. It seems

Re: Got error 12 from storage engine on ORDER BY

2005-12-28 Thread Gleb Paharenko
Hello. Strangely, this problem does not appear when mysqld is restarted and I retry the query. When I wait a day, the error starts to appear again. It seems like a memory leak. However we can't be sure, may be due some coincidence memory is thrilled by client threads. In my opinion your

Got error 12 from storage engine on ORDER BY

2005-12-27 Thread Walter Hop
Hello all, I'm running into an error which seems to be fairly uncommon. Hopefully somebody can give me some insight! In the monthly run for my accounting software, I am doing a fairly heavy query with a few joins, some date arithmetic, a 'having' condition and finally an 'order by'.