Shailesh Humbad Wrote:
-------------------------------------------------------
> I figured out the problem. MySQL 5.0.24 has a
> known bug with temporary tables, confirmed in
> linux, freebsd, and windows. The bug was fixed in
> 5.0.24a.
>
>
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-24
> a.html
>
> I added code that was using temporary table, this
> caused the bug to resurface.
>
> Taking out the temporary tables code and using
> static tables caused the crashing to go away.
> Then, I upgraded MySQL to 5.0.51a using vuninstall
> mysql5.0 and then vinstall mysql5.0 (VPS-specific
> commands). Now, even with the temporary tables
> code, the server is stable.
I was having the exact same issue, and Verio had no clue. Thanks for this posting, it fixed my problems.