MySQL Forums
Forum List  »  InnoDB

Re: mysqld got signal 11
Posted by: Shailesh Humbad
Date: March 20, 2008 01:06PM

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-24a.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.

Options: ReplyQuote


Subject
Views
Written By
Posted
8038
March 13, 2008 01:34PM
Re: mysqld got signal 11
4049
March 20, 2008 01:06PM
3207
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.