MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Hang with MySQL 5.0.37/5.0.40          MySQLTalk.org Forum Index -> MySQL Internals View previous topic :: View next topic   Author Message Jocelyn Fournier Guest Posted: Wed May 02, 2007 8:55 pm    Post subject: Hang with MySQL 5.0.37/5.0.40 Hi, I'm currently trying to switch from 5.0.27 to the latest version of MySQL (community : 5.0.37 / enterprise : 5.0.40). With those two versions, after the mysql launch, the server just seems to freeze. When it doesn't freeze immediately, some processes seems to be stuck in the "cleaning up" state. e.g. : | 61 | bestofchat | localhost | mutu_bestofchat | Init DB | 12 | cleaning up | NULL | | 63 | bestofchat | localhost | mutu_bestofchat | Sleep | 12 | | NULL | | 77 | bestofchat | localhost | mutu_bestofchat | Init DB | 12 | cleaning up | NULL | When it freezes I can't even launch the mysql client. (and if I'm inside the mysql client, ctrl+c doesn't work anymore as well). I've noticed the size of tar.gz is much larger than for the 5.0.27 release. Does this mean the 5.0.37 is now a MAX version ? Note I've tried both Linux (x86) and Linux (x86) (non RPM, Intel C/C++ compiled, glibc-2.3) with the same result. Do you have any idea of what change (either in the build process or in the code) could explain this annoying behaviour ? Thanks, Jocelyn Back to top Chad MILLER Guest Posted: Wed May 02, 2007 10:07 pm    Post subject: Re: Hang with MySQL 5.0.37/5.0.40 Hi Jocelyn. On 2 May 2007, at 11:55, Jocelyn Fournier wrote: Quote: I'm currently trying to switch from 5.0.27 to the latest version of MySQL (community : 5.0.37 / enterprise : 5.0.40). With those two versions, after the mysql launch, the server just seems to freeze. When it doesn't freeze immediately, some processes seems to be stuck in the "cleaning up" state. e.g. : | 61 | bestofchat | localhost | mutu_bestofchat | Init DB | 12 | cleaning up | NULL | | 63 | bestofchat | localhost | mutu_bestofchat | Sleep | 12 | | NULL | | 77 | bestofchat | localhost | mutu_bestofchat | Init DB | 12 | cleaning up | NULL | I haven't seen this. What are the threads doing, if you look at it in GDB? Let's start a bug report on this, when you have more information. We needn't discuss it on internals@ unless you think it's too important. Quote: When it freezes I can't even launch the mysql client. (and if I'm inside the mysql client, ctrl+c doesn't work anymore as well). The client too? Bizarre. Let's start with the assumption that it's a separate problem, so that we don't miss something. Quote: I've noticed the size of tar.gz is much larger than for the 5.0.27 release. Does this mean the 5.0.37 is now a MAX version ? Sorry, I don't know. I'll leave that for someone else to answer. - chad -- Chad Miller, Software Developer chad (AT) mysql (DOT) com MySQL Inc., www.mysql.com Orlando, Florida, USA 13-20z, UTC-0400 Office: +1 408 213 6740 sip:6740 (AT) sip (DOT) mysql.com Back to top Chad MILLER Guest Posted: Thu May 03, 2007 12:35 am    Post subject: 5.0.{2,3}7 size was, Re: Hang with MySQL 5.0.37/5.0.40 On 2 May 2007, at 11:55, Jocelyn Fournier wrote: Quote: I've noticed the size of tar.gz is much larger than for the 5.0.27 release. Does this mean the 5.0.37 is now a MAX version ? According to someone on our build team, "we failed to include the debug binary earlier." - chad -- Chad Miller, Software Developer chad (AT) mysql (DOT) com MySQL Inc., www.mysql.com Orlando, Florida, USA 13-20z, UTC-0400 Office: +1 408 213 6740 sip:6740 (AT) sip (DOT) mysql.com Back to top Jocelyn Fournier Guest Posted: Thu May 03, 2007 4:58 am    Post subject: Re: Hang with MySQL 5.0.37/5.0.40 Hi Chad, Chad MILLER a écrit : Quote: Hi Jocelyn. On 2 May 2007, at 11:55, Jocelyn Fournier wrote: I'm currently trying to switch from 5.0.27 to the latest version of MySQL (community : 5.0.37 / enterprise : 5.0.40). With those two versions, after the mysql launch, the server just seems to freeze. When it doesn't freeze immediately, some processes seems to be stuck in the "cleaning up" state. e.g. : | 61 | bestofchat | localhost | mutu_bestofchat | Init DB | 12 | cleaning up | NULL | | 63 | bestofchat | localhost | mutu_bestofchat | Sleep | 12 | | NULL | | 77 | bestofchat | localhost | mutu_bestofchat | Init DB | 12 | cleaning up | NULL | I haven't seen this. What are the threads doing, if you look at it in GDB? I've just opened http://bugs.mysql.com/bug.php?id=28210 to cover this issue. Thanks, Jocelyn Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL Internals All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.