MySQL Forums
Forum List  »  InnoDB

Re: mysqld got signal 11
Posted by: Michael Camden
Date: March 13, 2009 05:06PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
8022
March 13, 2008 01:34PM
4040
March 20, 2008 01:06PM
Re: mysqld got signal 11
3200
March 13, 2009 05:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.